-
Sales Order with 13,000+ Lines – What is the Recommended NetSuite Approach?
Hello everyone, We have a business requirement where a single customer order can contain approximately 13,000 line items. We understand the documented transaction limits: UI: 500 lines per transaction CSV Import / SOAP Web Services: 5,000 lines per transaction Transactions with more than 1,000 lines may also impact…
-
CSV update preferred bin location for assemblies
I have already mass updated the preferred location for my assemblies and I would like to do it for my assemblies also. I only have two locations I'm worried about, one for each department we have. I had gotten to the point where there was bin 1 and bin 2 options I just didn't want to mass update something incorrectly. I…
-
CSV Import - Custom List - Matrix Option List
I am hoping to get some help figuring out how to import a cleaned up version of one of the preexisting custom lists in NetSuite. For context, we recently went through a reimplementation of NetSuite so our data was moved from our old instance to a new instance. During this move some of our matrix option lists got messy and…
-
Issue in CSV import of Vendor Bills linked to PO
For some time now, I've been performing bulk imports of vendor Bills using CSV files. Within the import fields, I use the "Purchase Order" field to link the vendor bill to a purchase order, and it works perfectly. However, I'm having problems with purchase orders marked "Billing pending/partially received." There are some…
-
CSV Import
I am trying to do a CVS import using a comma column delminiter; however, NetSuite does not identify and of columns.
-
Item Receipt CSV Import for Serialized Inventory Guide
Hello, We are trying to use CSV import for item receipts, and are testing it in our sandbox For our testing scenario, we have an open purchase order with 1 line and 500 of an inventory item (Item XYZ). 0 of the item has been received. We are trying to use a single CSV file for both the Item Receipt itself as well as the…
-
Import Item Fulfillment through CSV
Hello Team, Now we have Item Fulfillment and Item Receipt as options to create it through CSV import. I'm trying to create an item fulfillment using CSV for a transfer order with status pending fulfillment and I'm getting this error: My csv: My importing mapping: Does anyone know what is missing and why I'm getting this…
-
Create a CSV file, save, load and parse the CSV contents using suiteScript
This sample calculates the total for the second column value in a CSV file. Each line in the CSV file has the following format: date,amount Here is the sample data that the script adds to the file: 10/21/14,200.0 10/21/15,210.2 10/21/16,250.3 Code Below: require(['N/file', 'N/error', 'N/log'], function (file, error, log) {…
-
NSC | Item Fulfillment > Mark as Shipped > Unexpected Error
Scenario User is unable to mark an item fulfillment as shipped because an unexpected error occurs during the process. Cause The error is typically caused by an invalid email address in the "To Be E-mailed" field on the associated sales order. An invalid email address may include: Incomplete formats, such as missing domain…
-
NSC | Creating Subprojects (Child Projects) via CSV Import
Importing subprojects in NetSuite works similarly to regular projects, with one key difference: you need to assign a Parent Project as a Customer when importing a .csv file. This is similar to a UI process as discussed in this article: New to NetSuite | Creating Child Projects. For example, there is a Parent Project with…