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.Type in APV33315ERP at main menu
Say 'y' to creating csv file
Exit CMC software to release hold on csv file
Go to SQL box
Right-click on CMC-Iowa, tasks, import data
open a query
UPDATE importdata
SET Invoice = REPLACE(Invoice, '"', ''),
[GL Acct] = REPLACE([GL Acct], '"', ''),
Division = REPLACE(Division, '"', '')
TRUNCATE TABLE dbo.APBegBalance
INSERT dbo.APBegBalance
SELECT
Invoice, Amount, Units, InvDte, RcvDte, [GL Acct], Division, Reference, Vendor, [Inv Comment], DueDte, [Exp Comment], [Disc Amount], Status, [Create Dte], CMCVhcr, Type
FROM dbo.importdata
transfer data to ERP-Iowa-Staging table
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
SELECT DISTINCT [GL Acct] FROM [CMC-IOWA].dbo.APBegBalance a
LEFT JOIN ERP_Iowa_Staging.dbo.GLAccountConversion g
ON g.OldGLAccount = a.[GL Acct]
WHERE g.GLAccountConversionID IS NULL
Email list to amy
Run Import Vouchers program under ERP Payables > Utilities.
...