|
|
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.
- If Multi-Store, Merge the data back in first
- MAKE A BACKUP!!!!! top of Artisan Tools->Backup (at the main site)
- Probably best to leave this as they are, but you can OPTIONALLY: Reset Numbers: System Administration>Configuration Settings>Business and Financial>Numbering Schemes
- Export Customer records to a .DBF, change Y for all fields, so we can re-create store credits.
- Exit Artisan and delete the following files from the data directory:
- accthist.*, pomain.*, pplog.*, stkunit.*, tender.*, tranline.*, transact.*, vendinv.*
- 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.
- Run a consistency check (non-interactive).
- Re-import customers, mapping customer ID and Store Credit fields only:
- Map CNUM to CUSTOMER_ID
- Map CURBAL to BALANCE_DUE
- If multi-store, push data back out.
- 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.
|
| |
| |
|
|
|
|
|
|
|