Jcurve Support Articles

Importing Fixed Asset Records

Go to Setup > Import/Export > Import CSV Records.

Triggering Scripts and Workflows on CSV Import

User Event scripts and workflows can be triggered using CSV Import by enabling the feature "Run Server SuiteScript and Trigger Workflows"

Prevent User Event Scripts Running On CSV Imports

With the "Run Server SuiteScript and Trigger Workflows" option enabled (inSetup > Import/Export > CSV Import Preferences) User Event scripts deployed on a record will also run for CSV Imports for the very same record.

Use Script Function to Avoid Blank Cells When Generating CSV File via SuiteScript

The data from the field must first undergo this logic so that it can be formatted to fit through a single column each time a data is being passed and assigned to a column. This will avoid a next line placement for each line within the item description.

CSV Import Execution Context in User Event Scripts

Trigger User Events scripts in CSV Imports.

How to Create a Script That Parses CSV Files

Some records are not available for CSV import, but it might access through scripts. Therefore, a script might import records or use a CSV file to perform some other action.

Remove Purchase Price on Items in Bulk via CSV Import

A user wants to blank out the Purchase Price field for multiple items simultaneously due to thousands of records with existing purchase prices.

CSV Import > Sales Order > Error: Invalid item reference key XXX for subsidiary XXX

During an update of a transaction via CSV import, the error"Invalid item reference key XXX for subsidiary XXX"is encountered.

CSV Import on Inventory Adjustment Throws an Error: "You cannot create an inventory detail for this item"

When importing a CSV File to create or update anInventory Adjustmentrecord, an error: "You cannot create an inventory detail for this item" can be encountered when the item you are importing is not aSerial/Lot Numbered Itemor does not use bins.

Resolve Error: "Invalid item reference key xxxx" in CSV Import of Inventory Adjustment

User received an error message on the CSV file forInvalid item reference key XXXXafter following the usual process of importing transactions such as Inventory Adjustment.

Update Item Record to Add Price Level via CSV Import

User tried to update theItem Price Levelin theItem Recordvia CSV Import. The result shows that the import was successful but the Item Record was not updated.

Order to Cash

CSV Import of Unapplied Customer Payment

CSV Import of Unapplied Customer Payment.

Add Permission to CSV Import Bin Records

A custom role is unable to perform a CSV Import for bins. When navigating to the Import CSV File page, the selection for Import Type : Supply Chain andRecord Type : Bin is not available.

Journal Import of Sales with GST Not Showing Up in the Business Activity Statement Report

The user has imported a sales transaction through CSV import of general journals and the CSV template has no mapping for Tax Account column in the Journal which in result made the sales transaction not reflect in the Business Activity Statement Report.

Make Accounts Available to All Subsidiaries using Saved Search and CSV Import

The user wants to mass-update all Accounts in the Chart of Accounts to apply to multiple Subsidiaries.

Budgets in NetSuite

You can save estimates of income and expense as budgets for financial planning purposes. In NetSuite, each budget covers a year and permits the entry of an amount per account for each accounting period in the year. Budgets provide information for reports. They do not control actual income and expense.

Importing Vendor Records with Special Characters

To import Vendor or Customer Name with special characters, do the following;

Restrict Users from Updating Field Mapping of a Shared CSV Import

A user needs to restrict users from editing the mapping and settings of a saved CSV import that they have shared.

Updating a Custom Checkbox Field of Items Through CSV Import When Item Location Configuration Feature is Enabled

A user wants to know how to mass update the custom checkbox field they created for their inventory items when the Item Location Configuration Feature is Enabled.