Archive Data / Purge Transaction Data
Reference Number: AA-00324 Views: 902 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.

Quick Jump Menu