Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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'

...