NetSuite Export Error - Invalid Field Value

During the export from Ottimate, if any invoice field in Ottimate contains a value that is not valid/does not exist in NetSuite, the invoice will be flagged with an export error message as shown below:

"There was an error in NetSuite: You have entered an Invalid Field Value {Id} for the following field: [NetSuite field]"

NetSuite fields

Account field

The account field in NetSuite points to your GL accounts, and the Field Value matches the NetSuite internal ID for that GL Account. Ensure the correct account has been selected.

Subsidiary field

To address this error, please follow these steps:

1. Navigate to NetSuite, then select Lists > Relationships > Vendors > Search.
2. On the new page, search for the vendor from your Ottimate invoice. Access the vendor page.
3. At the bottom of the vendor page, select Edit to add a subsidiary.
4. From the dropdown, add the correct subsidiary. Click Save when finished.
5. Navigate back to Ottimate. Click on "Resolve" to clear out the export error.
6. Click on "Export" and the invoice will flow to NetSuite properly.

Note: You may need to refresh your NetSuite to see the invoice populate

Entity field

In NetSuite, entity refers to the vendor. The vendor may not be found in NetSuite, or may be inactive. Please ensure the vendor also has access to the location the invoice is in.