...
Type in APV33315ERP at main menu. These steps are for beginning balance.
Say 'y' to creating csv file
...
Right-click on CMC-Iowa, tasks, import data
. The csv file name is apv33315e01.csv.
...
open a query
UPDATE importdata
SET Invoice = REPLACE(Invoice, '"', ''),
[GL Acct] = REPLACE([GL Acct], '"', ''),
Division = REPLACE(Division, '"', '')
...
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 No SQL data returned means scrubbing process completed successfully.
...
Missing Vendor(s), GL Account(s), Accounting Period(s), Bank Code(s).
Run SQL Script '3 - CMC Import - Vouchers Insert.sql'
...
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.
...
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 @RunMonth) to to process payments.