Tuesday, October 30, 2018

CSV Import > Journal Entry > Please enter the value(s) for Account error appears even if the Account field has already been included in the Field Mapping

This occurs when there is an extra line in the CSV file, usually a line or row for the total of both the Debit and the Credit column.

Since we assign one row per Account line, the system will then treat this as another Account line. Therefore, it will look for the required fields in a Journal Entry import which includes, but not limited to, the Account field.

1. Modify the CSV file and remove the extra row for the total. Save.

2. Navigate to Transactions > Financial > Make Journal Entries > Import.

3. Click the Select button and upload the modified CSV file.

4. Click Next.

5. Map the fields with the NetSuite fields. Click Next.

Note: Result shows that the import is now successful.

No comments:

Post a Comment