Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC42


IC42.1 - Stock by Detail

**Form Purpose
Use Stock by Detail (IC42.1) to view stock-on-hand quantities by location.
These forms let you inquire on Stock by Detail (IC42.1), Stock by Lot
(IC42.2), Serial Numbers (IC42.3), and Secondary Detail (IC42.4). All these
forms let you choose the unit of measure by which to view quantities, except
for IC42.3 (Serial Numbers). If you choose a unit of measure other than the
stock unit of measure, this form converts all quantities based on conversion
data defined for the item in the IC11.1 (Item Master) UOM form and the number
of decimals for quantity defined in the IC11.1 (Item Master) Main form.

Use IC42.1 (Stock by Detail) to view stock detail information. This form
displays item bins (if bin tracked), stock-on-hand quantities, lot/sublots (if
applicable), lot holds (if any), inspection plus allocated totals, and freeze
status (if frozen). Use IC42.2 (Stock by Lot) to view lot detail information
and IC42.3 (Serial Numbers) to view serial numbers.

This form displays secondary unit of measure quantities for catch weight
items in fractions. For example, if an item's stock-on-hand is 20 ounces, this
form displays the secondary unit of measure quantity as 1.4 lbs. Use IC42.4
(Secondary Detail) to view secondary unit of measure quantities in whole
numbers.




Updated Files

    None.


Referenced Files

    ICCOMPANY  - Used to validate the existence of the company number and
                 obtain the bin type description.

    ICLOCATION - Used to validate the existence of the location.

    ICLOT      - Used to validate the existence of the lot/sublot.

    ITEMLOC    - Used as the primary file for sequencing by item.

    ITEMMAST   - Used to display the item description and stock unit of measure.

    SOHDETAIL  - Contains the stock-on-hand quantities at the bin, bin type,
                 lot/sublot, and serial number levels.


IC42.2 - Stock by Lot

**Form Purpose
Use Stock by Lot (IC42.2) to view item stock quantities by lot and sublot
numbers for a specific location. This form applies to items set up for lot
tracking in IC11.1 (Item Master) or IC10.2 (Item Master and Location). This
form displays lot/sublots, bins (if used), expiration dates, stock-on-hand,
unit of measure, lot holds (if any), and inspection plus allocated totals.

This form lets you choose the unit of measure by which to view quantities. If
you choose a unit of measure other than the stock unit of measure, this form
converts all quantities based on conversion data defined for the item in the
IC11.1 (Item Master) UOM form and the number of decimals for quantity defined
in the IC11.1 (Item Master) Main form.




Updated Files

    None.


Referenced Files

    ICCOMPANY  - Used to validate the company number and obtain the bin type
                 description.

    ICLOCATION - Used to validate the location.

    ICLOT      - Used to determine the expiration date and whether or not a lot
                 is on hold.

    ITEMLOC    - Used as the primary file for sequencing by item.

    ITEMMAST   - Used to display the item description and stock unit of measure.

    SOHDETAIL  - Contains the stock-on-hand quantities at the bin level.


IC42.3 - Serial Numbers

**Form Purpose
Use Serial Numbers (IC42.3) to view item stock quantities by serial number
for a specific location. This form applies to items set up for serial number
tracking in IC11.1 (Item Master) or IC10.2 (Item Master and Location). This
form displays the total stock-on-hand quantity for an item and lists serial
numbers, bins (if used), allocation status, and bin types.




Updated Files

    None.


Referenced Files

    ICBIN      - Used to obtain the bin type.

    ICCOMPANY  - Used to validate the existence of the company number.

    ICLOCATION - Used to validate the existence of the location and display the
                 description.

    ITEMLOC    - Used as the primary file for sequencing by item and obtaining
                 the stock-on-hand quantity at the location.

    ITEMMAST   - Used to display the item description and stock unit of measure.

    ITSERIAL   - Used to validate serial numbers.


IC42.4 - Secondary Detail

**Form Purpose
Use Secondary Detail (IC42.4) to view stock detail information for catch
weight items. This form is similar to IC42.1 (Stock by Detail) which displays
item bins (if bin tracking), stock-on-hand quantities, lot/sublot (if
applicable), lot holds (if any), inspection plus allocated totals, and freeze
status (if selected).

This form lets you choose the unit of measure by which to view quantities. If
you choose a unit of measure other than the stock unit of measure, this form
converts all quantities based on conversion data defined in the IC11.1 (Item
Master) UOM form tab and the number of decimals defined for quantity in the
IC11.1 Main form tab. Otherwise, the secondary unit of measure is used to view
quantities by default.

Note Secondary unit of measure quantities for catch weight items display in
whole numbers regardless of the conversion and the number of decimals for
quantity. For example, if an item's stock-on-hand is 20 ounces, this form
displays the secondary unit of measure quantity as 1 lb. Use IC42.1 (Stock by
Detail) to view secondary unit of measure quantities for catch weight items in
fractions.




Updated Files

    None.


Referenced Files

    ICCOMPANY  - Used to validate a company number.

    ICLOCATION - Used to validate an inventory location.

    ICLOT      - Used to obtain lot/sublot records for an item location.

    ITEMLOC    - Used to obtain item location stock quantities.

    ITEMMAST   - Used to obtain item description.

    SOHDETAIL  - Used to obtain item location detail stock quantities.


INVOKED Programs

    ICI1