IC31.1 - Item Location Balances

This form displays balance totals for an item at a specific location. This
form includes totals for available, stock-on-hand, allocated, picked
unallocated, backordered, inspection hold, on-order, work-in-process, and
intransit inventory.  Unallocated, allocated, picked, and backorder totals are
based on customer orders in the Order Entry and Requisition system. Inspection
hold totals are maintained in the Purchase Order system. Intransit totals are
based on transfers set up as intransit in the Inventory Control system.
Work-in-process totals are based on work orders in process in the Work Order
system.

For catch weight items, balance totals are based on the secondary unit of
measure. Otherwise, balance totals are based on the stock unit of measure.
Both stock and secondary unit of measure quantities display for stock-on-hand
totals.

Secondary on-hand totals display for memo purposes only. Inventory valuation
is based on stock unit of measure totals.

Note: This form lets you display balance totals for an item at all locations
using the Total form action. You can use the same form action you can also
display totals for a report group at all locations.

Updated Files

    CKPOINT    - This file is used in the event of a program or system failure
                 to enable a batch update program to continue from where it left
                 off.


    ICCOMPANY  - Used to validate the existence of the company.

    ITEMLOC    - Contains item location records.


Referenced Files

    GLCODES    - Used in a General Ledger common routine.

    ICBIN      - Used to obtain bin information.

    ICCATEGORY - Used to retrieve account information.

    ICLOCATION - Used to validate the existence of the location.

    ICRPTGRP   - Used to validate the existence of the report group.

    ITEMMAST   - Contains Item Master records.