Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ex: ArImportLocation=C:\ArImportFiles  and ArArchiveLocation=C:\ArImportFiles\Archive

Get Customer Master Template.xlsx from  Import Templates. Populate customer template for Customer and Location tabs, Use SQL Statement to add Customers then Locations.

...

To ERP Logistics > Invoice then Update and Register invoices one accounting period at a time. Once all invoices have been registered, run AR Aging and balance to the CMC Aging report. 


Get Items Template.xlsx  from  Import Templates. Populate items template for UOM and Item Master. Use SQL Statements to add UOM and Item Master codes to ERP.

...

Select Import the invoice data records click Next Button

Image Added

Select Company/Division from drop down.

Select Process all files and display data for import click Next Button


Image Added

Grid will populate data from CMC extract files. Invoice Header, Invoice Detail and Invoice Detail Misc. Charge TAB will contain invoice data.

Errors will display in Records With Errors (Will not Import) TAB.

Example of error messages

Image Added

Click Import All Valid Records Button.

...