The format must be a comma-separated value (CSV) file with the following specifications.
All imported files will be copied to an Imports directory and renamed with the date and time of the import.
Company Number, Journal, Reference Number, Transaction Date, Posting Month, Posting Year, Header Comment, GL Account, PC, Department, Entity Ref, Entity Number, Stock Number, Debit, Credit, Unit Count, Line Comments
(asterisk indicates required fields)
The routine can be run automatically on a scheduled task by passing the parameter Auto to the program.
The import will also check the file information and compare the previous import by Time, Name, Created Date, and verify that the file isn’t the same information. If a match occurs and the program is run automatically it will NOT import anything. If a match occurs and not run automatically it will ask the user if they would like to continue.
([Text in brackets] indicates the type of variable.)