Make sure all AP data is purged before running these scripts. Bring in Open AP Vouchers (APV33315ERP) prior to running scripts.
Navigate to Import Templates. Use Voucher Import Template.xlsx to bring in AP data from CMC CSV file created by APV33315ERP.dbc.
Run Import Vouchers program under ERP Payables > Utilities.
Scripts to be run against the CMC_Migrate DB created from Convert CMC AP Data to ERP AP Step.
Run SQL Script '1 - CMC Import - Create Scrub Tables,sql'
Run SQL Script '2 - CMC Import - Voucher Scrub.sql'
Run Pre Requisite Company / Division Conversion Section at top of Script 2. No SQL data returned means scrubbing process completed successfully.
If SQL data is returned possible issues could be:
Missing Vendor(s), GL Account(s), Accounting Period(s), Bank Code(s).
Run SQL Script '3 - CMC Import - Vouchers Insert.sql'
Set proper start/end year (@RunBegYear/@EndRunYear) for data to be migrated. Then set proper Month (@RunMonth) when on current year. Search for these variables in scripts.
Comment and Uncomment code based on migration year and/or month.
Run SQL Script '4 - CMC Import - Cancelled Vouchers Insert.sql'
Set proper start/end (@RunBegDate,@RunEndDate) dates at top of script.
Run SQL Script '5 - CMC Import - Cancelled Vouchers KeyOffs.sql'
Set proper start/end (@RunBegDate,@RunEndDate) dates at top of script.
Run SQL Script '6 - CMC Import - Payments Scrub.sql'
No SQL data returned means scrubbing process completed successfully.
If SQL data is returned possible issues could be:
Missing Vendor(s), Voucher(s), GL Account(s), Accounting Period(s), Bank Code(s).
Run SQL Script '7 - CMC Import - Payments Insert.sql'
Set proper period (@RunYear, @RunMonth) to process payments.