V3 - Inventory Movement (IC45)

The V3 - Inventory Movement folder displays transactions that affect the On Hand quantity of the Product selected in the Header section. These transactions include Stock Receipts, Customer Sales and Inventory Adjustments.

Note: If an Invoice or Credit Note detail line is assigned a TAT code that is coded to NOT update inventory balances (as for defective merchandise) then that transaction is NOT recorded in the in the Inventory Movement folder of IC45.

You can control the Inventory Movement history within Enterprise. To purge Inventory Movement history, run Purge Inventory Movement (IC90).

1. To locate a specific transaction date, or to list all transactions in the list box from a specific date, enter the date in the Transaction Date field above the list box. The list will begin with the date entered. For more information on the icons associated with the Transaction Date field, click here.

2. The list box automatically displays information for the Transactions associated with the current Product. The following list defines each column in the list box:

   • Trans. Type - the code indicating the type of transaction posted. The following list indicates a number of possible Transaction Types:
     • Adjustment Codes - Adjustment Codes set up in Maintain Inventory Tables (IM09/Inventory Adjustment Codes) appear as well as the following standard Adjustment Codes:
       • ADJ-X - General Quantity Adjustments posted via Enter Inventory Adjustments (IC50).
       • ADJ-C - Cost Adjustments posted via IC50.
       • ADJ-R - Receipt Inventory Adjustments posted via IC50.
       • ADJ-T - Transfers posted via IC50.
       • ADJPHY - Physical Inventory Adjustments posted via Transfer Physical to Book (PI19).

     • REC'PT - Stock Received and posted through Enter Receipts/In-Transits (PO60) and Receive In-Transit to Stock (PO63).

     • INVOIC /Company Code - Depending on the "Update Inventory Movement Transactions By" setting in Company Control Initialization (CC00/Invoicing), the Trans. Type displays either INVOIC or the Customer Code.
       • When the 'Update Inventory Movement Transactions By' is set to Invoice in CC00, the Trans. Type displays the Customer Code for Invoices.
       • When set to Daily or Monthly, the Trans. Type field displays INVOIC for Invoices.

     • CRC-C - Cost recalculation posted through Enter Revised Landing Factors (PO65).

   • Trans.I.D. - the ID number used to trace the transaction back to the source document.
     • Adjustments - refers to the transaction ID generated in IC50 for the adjustment. This transaction ID is reported on the Print Stock Adjustments Report (IC51) as the Adjustment Register Report number.
     • Receipts - refers to the receipt number generated when the PO is received in PO60.
     • Invoice - refers to the Invoice or Credit Note number if CC00 is set to Invoice. If CC00 is set to Daily then the Trans.I.D. field displays INV/DAY; if set to Monthly then the field displays INV/MTH.

   • Trans. Date - the date on which the transaction took place.

   • To Whse - the Warehouse to which the Product is being sent or received.

   • Units In/Units Out - the quantity of the Product coming in or moving out. These quantities increase/decrease the On Hand quantity.
     • If the Trans I.D. column has INV/MTH, the quantity is the total quantity for the month. The same is true for INV/DAY, the quantity is the total quantity for the day.

3. The Opening Balance displayed below the list box represents the Inventory balance for the current Product after the most recent Purge Inventory Movement (IC90) run.

 

^{Folder V3 - Inventory Movement}