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.

Beginning Balances:

Run ARV35095ERP aging to get open balances. Creates file OPENINVS.csv. Get AR Open Invoices Template.xlsx template from Import Templates.

Take data from OPENINVS.csv and insert into the appropriate columns of the AR Open Invoices Template.xlsx and use the SQL Statement in the template to add beginning balances invoices to ERP.


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.

Run ARV39271ERP in CMC against customer DB. This Creates file to copy to ERP SQL Server folder (ex: C:\ArImportFiles).

...