How to use archiving in Produmex WMS

In order to improve system performance and database size from time to time it is recommended to archive data.

You can archive your standard SAP Business One transactional data, and separately you can also archive Produmex WMS related data.

For more information about standard SAP Business One archiving feature please check the OFFICIAL HELP.

In preparation for the archiving for WMS objects please consider the following documentation:

• http://wiki.produmex.name/doku.php?id=implementation:wms:archiving
• http://wiki.produmex.name/doku.php?id=implementation:wms:archivingcontroller

Tips:

• Before running archiving check your data volume with the queries below.
• Based on the amount of data, you may need to run the archiving in several steps to avoid performance issues.
• Make sure that the archiving is running in a quite period, with no users working in the database

You can check the data in your WMS tables before the archiving:

SELECT COUNT(*) FROM PMX_COHE
SELECT COUNT(*) FROM PMX_COLI
SELECT COUNT(*) FROM PMX_DLPL
SELECT COUNT(*) FROM PMX_DSST
SELECT COUNT(*) FROM PMX_IMHE
SELECT COUNT(*) FROM PMX_IMLI
SELECT COUNT(*) FROM PMX_INVD
SELECT COUNT(*) FROM PMX_LPLM
SELECT COUNT(*) FROM PMX_MOHE
SELECT COUNT(*) FROM PMX_MOLI
SELECT COUNT(*) FROM PMX_MVHE
SELECT COUNT(*) FROM PMX_MVLI
SELECT COUNT(*) FROM PMX_PIOP
SELECT COUNT(*) FROM PMX_PLHE
SELECT COUNT(*) FROM PMX_PLLI
SELECT COUNT(*) FROM PMX_PLLO
SELECT COUNT(*) FROM PMX_PLPH
SELECT COUNT(*) FROM PMX_PLPL
SELECT COUNT(*) FROM PMX_RTHE
SELECT COUNT(*) FROM PMX_RTLI
SELECT COUNT(*) FROM PMX_SSHH
SELECT COUNT(*) FROM PMX_SSHL
SELECT COUNT(*) FROM PMX_WAVE
SELECT COUNT(*) FROM PMX_WDET

Steps for the archiving:

1. Database backup
2. Setup the Archiving Controller in OSE
   
   
   
   NOTE: only closed documents will be archived. Open documents are not archived
3. Setup the Archiving TAB of the organization structure
4. Run the archiving
   
   
   
   
   
   

Results (example):