Skip to main content

Remove Inventory Historical Data

Posted Wed, 05/27/2009 - 18:08 by wu.ben

In order to improve system performance and reduce database storage sizes, we provide a new function to remove inventory historical data.
Based on the specific closing date, system will merge all the inventory transactions on or before the inputted date into one opening transaction. If current lot number on-hand qty is zero and opening transaction qty is zero too, this lot number will be deleted. At the same time, the Issue Document and Transfer Document will be deleted too.

Admindsk - Modules - Inventory - Remove Inventory Historical Data

Interface:

Explanation:
1. Merge inventory transactions: Merge all the inventory transactions on or before the inputted closing date into one opening transaction in order to reduce database storage sizes.
2. If the on-hand quantity now is zero and the opening transaction qty is zero too, this lot number will be deleted.
3. All the related transfer and issue documents will be deleted too.
4. Options: Delete the lot numbers with zero on-hand quantity and last transaction date is later than inputted closing date.
(1) If this option is not selected, system will only merge or delete those lot number with last transaction date on/before the inputted date.
(2) If this option is selected, system will ignore the adjustment and merge transaction when determine the last transaction date. For example, on 1 Jun 2009, users want to remove inventory historical data on or before 31 Dec 2008, but the deleted lot numbers still have balance quantity. So before users delete the historical data, they should adjust the on-hand quantity to zero first. Then even the last transaction date is after the inputted closing date, system will also delete those lot numbers because the on-hand quantity is zero.
5. Since the deleted records are permanently deleted and are un-recoverable, so this function is set in Admindsk.exe. So only those authorized persons can run this function.