Prerequisite: Populate DivisionConversion Table for the ERP-[CompanyName]-Staging database.
1.) Create Miscellaneous Charge code MISCLN.
This can be found in the MTSMiscCharge table. This needs to be done from ERP.
Set IsUseCustomerConversionDivision in ClientSetting table to '1' if CustomerConversion table is being used..
(ie: UPDATE ClientSetting SET IsUseCustomerConversionDivision = 1)
Bank Code in Stored Proc. spEtlCmcCashReceiptSourceToARStaging must be changed to company Bank Code.
(ie: UPDATE CashReceiptRaw SET BankCode = '3' where CompanyCode = '01')
Set Return Charge Code in Division Master under the Logistics and Invoicing tab to a Misc. Charge code.
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 ARV39271ERP 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.