Author: Karishma Krishnadas

Recommendations: 1. The CSV Import file shouldcontain the same Item Name format as shown in Transactions > Sales > Enter Sales Orders > Items tab > Items subtab> Item drop down field.  2. Internal ID can also beused instead of Item Name. Just make sure that on the field mapping page, clickon the pencil icon beside the Item field and ChooseReference Type = Internal ID. 3. Verify if theItem is Inactive. If the Item record… Continue reading CSV Import: Sales Order > Error: Invalid item reference key xx.

Close Order button will not be available anymore when:1) The Status of the Sales Order is Pending Approval, Pending Fulfillment, Billed, and Closed.    *A sales order needs to be approved first before it can be closed. This is logical since an unapproved sales order is still not a valid transaction.    *Once a Sales Order has been fulfilled and invoiced (Billed)… Continue reading Close Order Button is not available on the Sales Order

To reflect a price of an Item decreasing on a Sales Order that has been Billed and an Invoice that has been paid the following can be done: 1. Edit the Sales Order and change the price in the Amount column. You will receive the notice: Items on this line have been fulfilled and billed. Are you sure you… Continue reading Change Price on a Billed Sales Order and Paid Invoice

To create this search please follow the steps below: 1) Navigate to Reports > New Search > Transaction 2) Under Criteria tab: –Add Type is Sales Order — Add Main Line is False 3) Under  Results tab: — Add Sales Rep — Summary Type is Group — Add Number (this is the SO number) — Summary Type is Group— Add Amount — Summary Type is Sum— Add Item  — Add Quantity— Add Item Fields…Purchase Price (this is the cost of the item)– Summary Type is Sum… Continue reading Search Saved to Show Profitability Per Transaction

To do this:1) Navigate to Transactions > Sales > Enter Sales Orders > List.2) Click View on one Sales Order record.3) Hover mouse to Customize link, found above the page title, and choose Customize Form.4) Navigate to Actions tab > Standard Actions subtab.5) Mark the Show check box for Close Action Name.6) Click Save.

Under Home > Set Preferences > Alerts tab > Time were already removed under First Selection, Second Selection and Third Selection fields, but the user is still receiving the alert. This setting is role-specific, which means that if the user has multiple roles, the time has to be removed on each role to stop the alert. Steps:1. Log in to NetSuite.2. Click View all roles.3. Log in to role #… Continue reading User Keeps on Getting an Alert when Time under the Alerts tab is Removed from Home > Set Preferences

To reflect a price of an Item decreasing on a Sales Order that has been Billed and an Invoice that has been paid the following can be done: 1. Edit the Sales Order and change the price in the Amount column. You will receive the notice: Items on this line have been fulfilled and billed. Are you sure you… Continue reading Change Price on a Billed Sales Order and Paid Invoice

Create a Client ScriptName: Refresh CacheID: customscript_refreshcacheRecalc Function: RefreshCacheScript File:function RefreshCache(){window.location.reload(true);} No need to deploy Client SuiteScript since this will be called by the button generated by the User Event Script Create a User Event ScriptName: Button CacheBefore Load Function: beforeLoadScriptScript File:function beforeLoadScript(type, form, request){form.setScript(‘customscript_refreshcache’); //reference the Client SuiteScriptform.addButton(‘custpage_clearthatcache’, ‘Refresh Cache’, ‘RefreshCache()’ ); //add button}… Continue reading Create a SuiteScript that will Refresh and Redownload the Page and Contents

When creating or running a report, there is always a Date footer at the bottom. If there is a need to change that Date to another Date field (e.g., Date Closed, Date Received, Due Date, etc.) then follow the steps below: 1.    Customize the report 2.    Go to the Filters tab 3.    Click on the Date filter 4.    Click the Insert button 5.    Select the… Continue reading Remove and Replace the Standard Date Footer on Reports by Another Date Field

Cannot add an item on a Sales Transaction like Sales Order, Cash Sale or Invoice. The item shows up on the list of items that can be added but when the user clicks on it, the sales description and price do not populate.When the user clicks the Add button, the item is not added on the… Continue reading Add Item on a Sales Transaction: Sales Description and Item Price Do Not Populate