Scenario The error is being thrown when updating Resource Allocation End Date. The Resource Allocation for one employee was incorrectly set up and the End Date was set to 1/22/60×8 instead of 12/13/20×8. The allocation was only for 0:25 hours. The Allocation Type of the Resource Allocation is set to Hard. When user tried to… Continue reading Fix the “Gateway Timeout Error” in Resource Allocation
Tag: csv import
Resolve Error: You have entered an Invalid Field Value x,xxx.xx for the following field: custrecord_slavebookvalue when Importing CSV
Scenario User is unable to proceed to import CSV file because of the above error message received. Solution The reason why user is not able to import the CSV file is because the format of the values in the CSV file relating to the amounts is set to “Number”. The correct format should be General… Continue reading Resolve Error: You have entered an Invalid Field Value x,xxx.xx for the following field: custrecord_slavebookvalue when Importing CSV
Avoid Mandatory Custom Field Validation on CSV Import
Solution Navigate under Setup > Import/Export > Import CSV Records Click Select button for selecting CSV file Click Next Import options (2nd step): Click Advanced Options Validate Mandatory Custom Fields: Remove Checkmark Click Next Set the Field Mapping Click Next Click Save and Run
NetSuite CSV import not triggering realtime export
Problem: When performing a CSV import into NetSuite my real time export is not running even if the Execution Context of the export is set to CSV Import. Solution: The CSV import preference of “RUN SERVER SUITESCRIPT AND TRIGGER WORKFLOWS” is not checked within NetSuite. Without this box checked the user event script that triggers… Continue reading NetSuite CSV import not triggering realtime export
Import Closed Sales Orders for Historical Reference
Scenario Import historical Sales Orders without having them affect the current Inventory levels. Solution Sales Order needs to be imported with a closed status. There are two alternative ways to do this: Add a column to the CSV file that has the header Closed and each line to be imported has the value of Yes This can then be… Continue reading Import Closed Sales Orders for Historical Reference
Error: ‘One of the columns [id, name] must be mapped in the CUSTOMLIST import’
This error might indicate that neither a name nor an internal or external ID was mapped on the field mapping page of the Import Assistant. For the import to succeed, you must select a reference type, either a name or an ID, and map it to your CSV file content, using the edit icon on… Continue reading Error: ‘One of the columns [id, name] must be mapped in the CUSTOMLIST import’
How to add values to a custom list using csv import
When adding many values to a custom list, a CSV import can be more efficient than manually adding each value. To import custom lists, follow these steps: Go to Setup > Import/Export > Import CSV Records. Select Customization as the import type and Custom List as the record type. In the Import Options, choose ‘Update’… Continue reading How to add values to a custom list using csv import
Error on CSV Import of Transactions: “Invalid entity reference key xx for subsidiary yy.”
Scenario User is trying to import a data through CSV but gets an error message stating: “Invalid entity reference key xx for subsidiary yy.” Solution The numbers (xx and yy) found in the error are the Internal IDs of the Entity record (Customer, Vendor, Employee, Other Name) and Subsidiary respectively that are found in NetSuite account 1.… Continue reading Error on CSV Import of Transactions: “Invalid entity reference key xx for subsidiary yy.”
How to Restrict Users from Updating Field Mapping of a Shared CSV Import
Scenario To restrict users from editing the mapping and settings of a saved CSV import that they have shared. Solution Ensure that the Allow Audience to Edit checkbox is unmarked. This checkbox can be found when going to the Setup > Import/Export > Saved CSV Imports > Access column, then Shared. As per Field Level Help, “Check this box to allow users with whom you… Continue reading How to Restrict Users from Updating Field Mapping of a Shared CSV Import
How to do CSV import to exchange rate
A. Prepare a CSV file which contains the following columns: I. For One World NetSuite Accounts: — Base Currency — Currency — Effective Date — Exchange Rate B. CSV Import Process: 1. Navigate to Setup > Import/Export > Import CSV Records 2. Set the following: — Import Type = Accounting — Record Type = Currency Exchange Rates 3.… Continue reading How to do CSV import to exchange rate