How to configure GL_GeneralJournalHeader import when importing Journal Entries in Sage 100
Description
How to configure GL_GeneralJournalHeader import when Credit and Debit amounts are in same column in source file when importing journal entries in Sage 100
Resolution
- In the VI Job, include the field L.DebitAmount on Data tab
- Set Operation to Replace and enter the Column that contains amount in the source file
Note: The field L.CreditAmount is not needed when source file contains bother credits and debits in the same column
The negative values will automatically be imported as credits
Support
If necessary, seek the assistance of Acute Data Systems to help provide assistance with this process.