Unable to Import Journal Error - Cannot insert the value NULL into column
Description of Issue
Error that includes syntax "Cannot insert the value NULL into column" received when using a custom Journal Import file format
Context
- Journal Import
- Custom Template
Cause
- A required value is missing from the import data file
- Missing Account for defined amount
- Missing Amount for defined account
Resolution
- Review datafile and identify missing required values and make necessary corrections
- Save file
- Exit file completelyÂ
- Attempt the import again
- If errors continue contact Munis Financial Support or log an Online Support Client Portal categorized as General Ledger
Additional Information
Test a known working import file used before to prove imports are working