V3-Inventory Movement (IC45)

TIP: This program has access to the iTopia Quick Link feature. For more information, click here.

Technical Note: If you select an ADJ type transaction in the list box and then you right click and select Movement, you will receive the following error: "The domain specified in the URL parameter appUrl is invalid." ADJ transactions include a space that the system cannot currently handle, for example ADJ - C.

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 Inventory Movement Purge (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 Inventory Adjustment Codes (IM03) appear as well as the following standard Adjustment Codes:
       • ADJ-X - General Quantity Adjustments posted via Inventory Adjustment Entry (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 Physical Inventory Physical-Book Transfers (PI19).

     • REC'PT - Stock Received and posted through P/O Receipt and In Transit Entry (PO60) and P/O In-Transit to Stock Receiving Entry (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 P/O Landing Factor Revisions (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 Inventory Stock Adjustment Print (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 Inventory Movement Purge (IC90) run.

 

^{Folder V3 - Inventory Movement}