Requirement We will be able to create a Sales report in NetSuite to understand the revenue, cost, gross profit and gross profit percentage from a transaction. Solution Create a Transaction Saved search Add the following filters to the Criteria section Type = Sales Order, Invoice Main line = true Add the following columns in the… Continue reading Sales Report which shows the Revenue, Cost and Gross Profit
Category: NetSuite ERP
NetSuite ERP
Currency record Creation
If our NetSuite account has more than one currency needed, then we have to enable the multi-currency feature. Once the feature is enabled, we can create new currency records. To create a new currency record, Go to Lists > Accounting > Currencies > New. In the Name field, enter a unique name for the currency. … Continue reading Currency record Creation
How to add Project Task on Item Line Level of Purchase Order
The Project Task will be visible on the Item Line Level of a Purchase Order only when the Job Costing and Project Budgeting feature is activated in the NetSuite account. To enable Job Costing and Project Budgeting, follow these steps: Navigate to Setup > Company > Enable Features Job Costing and Project Budgeting: Enter Checkmark… Continue reading How to add Project Task on Item Line Level of Purchase Order
Set a Preferred Custom Form as the Default form for FAM Asset Records
Scenario – A custom asset form has already been created and the ‘ FORM IS PREFERRED’ checkbox has been marked. However, on opening the asset records, the standard form is shown as default. Check the preferred forms for roles in the FAm asset custom record. Using Administrator Role, navigate to Customization > Lists, Records & Fields > Record Types Click on FAM Asset In… Continue reading Set a Preferred Custom Form as the Default form for FAM Asset Records
Cost of Sales GL adjustments by system
Scenario – The item costing method is FIFO and the system is causing GL changes and the direct cause cannot be pinpointed. In the Item Fulfillment transactions, the system changes the GL impact due to a change in the costs. There are various reasons for the cause of the change. With our current costing engine,… Continue reading Cost of Sales GL adjustments by system
Clarification required: Is it possible that the “sorting option” works correctly on the suite let page?
Is it possible that the “sorting option” works correctly on the suite let page? Solution:
No GL Impact on the Item Fulfillment record
When an Item Fulfillment has no journal entry in the GL Impact, one probable cause is that the Item Fulfillment is dated before the Inventory Adjustment. Below are the steps that can be taken to reflect the GL impact: Open the Inventory Adjustment record > Edit > Date it before the Item Fulfillment > Save. Open the Item Fulfillment record > Edit > uncheck and check the fulfill checkboxes on the item lines > Save. View the GL Impact. It should have… Continue reading No GL Impact on the Item Fulfillment record
Change in Fidelity for U.S. Bank Feeds in NetSuite
Connections to Fidelity credential-based sites in NetSuite will no longer be supported beginning December 13, 2023. What is Changing? To improve security, Fidelity is transitioning to Open Banking technology. Connections to their credential-based sites in NetSuite will no longer be supported beginning December 13, 2023. This change affects existing Fidelity Investments connections created through the Connect to… Continue reading Change in Fidelity for U.S. Bank Feeds in NetSuite
Items are not listing in Sales order
While creating a Sales order, some of the items are not listed in the line-level item list. In most cases, this issue happens when the item is made inactive. If the item is active and still the item is not listed in the sales order, check for the accounts given under the accounting tab. If… Continue reading Items are not listing in Sales order
Report to know transactions with Standard Approval not submitted for Approval
SCENARIO: Client wants to know the transactions that are not submitted for approval so that they can reach to employees to submit for approval SOLUTION: Create a Saved Transaction Serach: Once the transaction search page opens: In Criteria provide following details In Results provide following details: Provide a name for the report and click on… Continue reading Report to know transactions with Standard Approval not submitted for Approval