...
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, '"', '')
...
transfer data to ERP-Iowa-Staging table. If you are not using conversion tables then use original tables; for instance use Glacct instead of GlAccountConversion, Vendors instead of VendorConversion in scripts below and adjust to appropriate columns in joins.
SELECT DISTINCT Vendor FROM [CMC-IOWA].dbo.APBegBalance a
LEFT JOIN ERP_Iowa_Staging.dbo.VendorConversion v
ON v.OldVendorCode = a.Vendor
WHERE v.VendorConversionID IS NULL
...
Run Import Vouchers program under ERP Payables > Utilities. This may show error and one of the error is: could not map default bank. Make sure you have a default bank account set and associate all vendors to that default bank account seq no.
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 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.