Archive Data / Purge Transaction Data
Reference Number: AA-00324 Views: 1745 Created: 2013-12-26 10:00 Last Updated: 2018-03-16 12:11 0 Rating/ Voters


Warning This Article is dangerous if you don't know exactly what you want to do and how to do it. Please contact CerTek Software Support.


  1. If Multi-Store, Merge the data back in first
  2. MAKE A BACKUP!!!!! top of Artisan Tools->Backup (at the main site)
  3. Probably best to leave this as they are, but you can OPTIONALLY: Reset Numbers: System Administration>Configuration Settings>Business and Financial>Numbering Schemes 
  4. Export Customer records to a .DBF, change Y for all fields, so we can re-create store credits.
  5. Exit Artisan and delete the following files from the data directory:
    • accthist.*, pomain.*, pplog.*,  stkunit.*, tender.*, tranline.*, transact.*, vendinv.*
  6. Advanced Database Maintenance (System Admin -> Database Maintenance -> Advance Database Maintenance)
    • Choose #3: Force Stock Units to Match Visible QOH, 
      • Answer YES to confirm and then YES to also include corrections for Activity-Only Discrepancies.
  7. Run a consistency check (non-interactive).
  8. Re-import customers, mapping customer ID and Store Credit fields only: 
    • Map CNUM to CUSTOMER_ID
    • Map CURBAL to BALANCE_DUE
  1. If multi-store, push data back out.
  2. Make a new data set with new local for archived data, this data should also be set to read only via magic (version 3.5); magic readonly


Warning This Article is dangerous if you don't know exactly what you want to do and how to do it. Please contact CerTek Software Support.

Info Item(s) deleted successfully.
Quick Jump Menu