Prerequisite: Populate DivisionConversion Table.
Clear out all AR Data out of ERP database.
Modify ArImportLocation & ArArchiveLocation columns in ClientSetting Table in Customers SQL ERP DB to folder on SQL Server Drive.
ex: ArImportLocation=C:\ArImportFiles and ArArchiveLocation=C:\ArImportFiles\Archive
Run ARV35095ERP aging to get open balances. Creates file OPENINVS.csv. Get AR Open Invoices Template.xlsx template from Import Templates.
Run ARV39271 in CMC against customer DB. This Creates file to copy to ERP SQL Server folder (ex: C:\ArImportFiles).
Files in /dbc/txt/unpr directory: tot_CCYYMMDDHHMMSS_CO.txt, dtl_CCYYMMDDHHMMSS_CO.txt, rem_CCYYMMDDHHMMSS_CO.txt, rcp_CCYYMMDDHHMMSS_CO.txt
Aeros Import Invoices: Receivables > Utilities > Import Receivables
Select Import the invoice data records click Next Button
Select Company/Division from drop down.
Select Process all files and display data for import click Next Button
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.
Click Import All Valid Records Button.
Aeros Import Payments: Receivables > Utilities > Import Receivables
Select Import the payments data records click Next Button
Select Company/Division from drop down.
Select Process all files and display data for import click Next Button
Grid will populate data from CMC extract files. Payments to Import TAB will contain payment data.
Errors will display in Records With Errors (Will not Import) TAB.
Click Import All Valid Records Button.