User Tools

Site Tools


data_conversion_-_5.41_stock_control_routines

This is an old revision of the document!


Stock Control Routines for v5.41.0.23

System Five Revision 5.41.0.23 now contains tighter stock control routines. Previous versions may have stock data that fall outside of these constraints and will need to be corrected.

After updating to Version 5.41.0.23 the following Toolbox Routines need to be run to detect and correct existing data problems:

In the Toolbox, under Inventory Routines > Stock Control Routines

Run the following routines:

  1. Fix PO Received
  2. Fix PO Stock
  3. Fix PO Stock Records
  4. Recalculate Invoice Oversold (Enter the date of the original conversion from 5.35.8 or earlier version - See below 1) )
  5. Verify Non-countable Received Quantities
  6. Fix Returned Serials
  7. Remove Serialized Stock


If Department Transfers and Serial Numbers are in use :

  1. Fix Transferred Serials
  2. Rebuild Transfer Stock Records

Once completed, run the Inventory and Purchases > Inventory > Inventory Reports > Inventory Integrity Report with the following additional item checked:

Fix Inventory Stock Quantities

The ‘Fix Inventory Stock Quantities’ item will recalculate the Stock quantities for all inventory now that the toolbox routines have corrected the stock records.

1) Look in the data folder for a file called ‘stockconvert-detail-YYYYMMDD-HHMM.txt’ the Date and Time of the data original conversion are embedded in the file name.





Author: jdaniels
Editor: arose
Last Edited: 1-May-2008

data_conversion_-_5.41_stock_control_routines.1209678270.txt.gz · Last modified: 2008/05/01 14:44 (16 years ago) by andrew