Author: Karishma Krishnadas

The PO# field in the Inventory Back Order Report is labelled as Reference Number found in the Order Items Pending Fulfillments folder. Here are the steps:                 1. Navigate to Reports > Inventory/Items > Inventory Back Order Report > Customize.                 2. In the Edit Columns tab, add Reference Number from the Order Items Pending Fulfillments folder.                 3. Click Save.

Customer has access to Account “124567 Company A” using the email address abc@noemail.com. The same customer was given access to another NetSuite account. For instance, Account 012456 Company B, using the same email address (abc@noemail.com). When the customer log in to his account, he cannot see the role/s assigned to him for Account 012456 Company… Continue reading User cannot see one of the accounts he has access to in the “View All Roles” page.

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