...
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.
...