SM-J-D  Consolidate Inventory Transactions

Purpose of Program

Use this program to selectively purge and consolidate transactions from the inventory transaction file to reduce the overall file size.  All inventory transactions of any type that occur throughout the system are captured in the inventory transaction file.  From this file are derived reports on usage, month end costing, lot control, and serial control.

Note:  The program will automatically exclude parts with Lot or Serial Control from the transactions consolidated to prevent the deletion of Lot and Serial Control History.

General Program Operation

You may selectively consolidate the inventory transaction file by specifying a from/thru range of item numbers, a range of dates, and you can limit the consolidation to specific transaction types, which are listed as follows.

A - Adjustments

S -  Shipments

P -  Purchase Receipts to Stock

J -   Purchase Receipts to WIP

W - Work Order Receipts to Stock

I -    Stock Issues to WIP      

Q - PO Receipts to QC

O - Outside Processing Service PO Receipt to WIP

C - Price Change at AP-C

M - Make From Component Receipt

T - Location Transfer

G - Scrap

B - Bin Transfer within Warehouse

 

Once the types are specified you are prompted for the date of the final consolidation transaction.  The Thru date of the date range being consolidated is suggested so the net of the consolidated transactions fall within the same period as the original detail transactions.

After entering all the fields you will be asked to confirm if you want to run the consolidation.  You must enter a Y for the consolidation to proceed.

A balance forward per month will be created for each transaction type that rolls up the net units and average cost into a single record.  This enables records to be purged without affecting the inventory transaction file's monthly total net units and costs, which are needed by the SM-J-C  Reconcile Inventory On-Hand program to balance the totals in the inventory transaction file with the on-hand quantity in the inventory master record and by the monthly Usage button in IN-A  Inventory Inquiry.

Audit Data

Beginning with the IS Tech Support July 16, 2004 update, each Inventory Transaction is saved with a date/time stamp and, for users running TAS 6 Evolution, the User login ID of the person generating the transaction.  Running this program to consolidate the transaction detail will delete this audit detail as well.