Journal Import results to Error: “Each line must have a non-null value. Zero is permitted.”

The CSV file has the following columns:

  • Account
  • Debit
  • Credit
  • Gross Amount
  • VAT Amount
  • Line Memo
  • Entity
  • Department
  • Location
  • Memo

To resolve this error, we must edit the CSV file.

Delete the following columns/fields:
Gross Amount
VAT Amount
Add a new column for Tax Code

Enter the appropriate Tax Code for each account
Note: If the total Debits and Credits are not equal, you may ignore them as long as the expected Gross Amounts (Debit/Credit + VAT Amount) are equal.

Import the file again

Leave a comment

Your email address will not be published. Required fields are marked *