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
  1. Review datafile and identify missing required values and make necessary corrections
  2. Save file
  3. Exit file completely 
  4. Attempt the import again
  5. 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