Import Accounting Transactions Instructions

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

  1. *Company Number [integer] (must be a valid company) – required
  2. *Journal [String] (A1-Z1) – required
  3. *Reference Number [string] (max 20 characters) – required
  4. *Transaction Date [Date] – required
  5. *Posting Month [Integer] (0-12) – required
  6. *Posting Year [Integer] (4 digit year) – required
  7. Header Comment [String] (max 300 characters) – optional
  8. *GL Account [String] (must be a valid Account in the system) – required
  9. *PC [String] (must be a valid PC from GL_ProfitCenters table) – required
  10. *Department [String] (must be a valid Department from GL_Departments table) – required
  11. *Entity Ref [string] (max 20 characters) – required
  12. *Entity Number [string] (must be valid entity number in the system) – optional
  13. *Stock Number [string] (must be valid stock number in the system) – optional
  14. *Debit [double] – required
  15. *Credit [double] – required
  16. *Unit Count [Integer] – required
  17. Line Comments [String] (max 300 characters) – optional

(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.)