NetSuite: Supported fields

The NetSuite integration supports these fields:

ReadSoft Online NetSuite field Note
Header fields
Supplier vendor  
InvoiceNumber tranId  
InvoiceOrderNumber n/a If InvoiceOrderNumber is set on the invoice, the NetSuite vendor bill is initialized from the purchase order.
InvoiceDate tranDate  
InvoiceDueDate dueDate  
InvoiceCurrency currency  
Customer customer

In NetSuite, there is only one field for customer and project data. Therefore, the customer and project fields in ReadSoft Online map to the same "customer" field in NetSuite. In a real-life scenario, organizations that use NetSuite probably have their system configured to use one field or the other. If, however, both fields are used, ReadSoft Online makes sure the project belongs to the customer in NetSuite.

Project customer See the note for the "customer" field above.
location location  
Department department  
Class class  
Memo memo  
TaxCode taxCode  
Line-item fields
LIT_ArticleIdentifier item Alternatively, this can be a Dummy item code if LIT_ArticleIdentifier is empty or an invalid item in NetSuite
LIT_DeliveredQuantity quantity If the value is less than or equal to zero, it is set to 1.
LIT_UnitPriceAmount rate If the value is less than or equal to zero, it is set to the LIT_VatExcludedAmount value.
LIT_ArticleName description LIT_ArticleName is used for item descriptions for PO and non-PO invoices. If LIT_ArticleName is not specified during verification, the suggested value from NetSuite is used when the invoice is posted.
LIT_VatExcludedAmount amount If the invoice has no line items, a row is created using InvoiceTotalVatExcludedAmount.
LIT_Location location  
LIT_Department department  
LIT_Class class  
LI_TaxCode taxCode  
LIT_Customer customer See the note for the "customer" field above.
LIT_Project customer See the note for the "customer" field above.
Line-item expense fields
LIT_GeneralLedgerAccount account

Optionally, if you use account coding, the account code you specify is used. Otherwise, the value is determined by the supplier or by the Target system configuration settings if it cannot be determined by the supplier.

LIT_VatExcludedAmount amount If the invoice has no line items, a row is created using InvoiceTotalVatExcludedAmount.
LIT_Location location  
LIT_Department department  
LIT_Class class  
LIT_Memo or LIT_ArticleName memo If LIT_Memo is defined and has a value, it is used. Otherwise, the value from LIT_ArticleName is used.
LI_TaxCode taxCode  
LIT_Customer customer

In NetSuite, there is only one field for customer and project data. Therefore, the customer and project fields in ReadSoft Online map to the same "customer" field in NetSuite. In a real-life scenario, organizations that use NetSuite probably have their system configured to use one field or the other. If, however, both fields are used, ReadSoft Online makes sure the project belongs to the customer in NetSuite.

LIT_Project customer

In NetSuite, there is only one field for customer and project data. Therefore, the customer and project fields in ReadSoft Online map to the same "customer" field in NetSuite. In a real-life scenario, organizations that use NetSuite probably have their system configured to use one field or the other. If, however, both fields are used, ReadSoft Online makes sure the project belongs to the customer in NetSuite.