Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms

IC42


IC42.1 - Stock by Detail

Use IC42 forms to display 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 display 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 display 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 display lot detail
information and IC42.3 (Serial Numbers) to display 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 display 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

Use this form to display 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 display 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

Use this form to display 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

Use this form to display 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 display 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
display 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 display 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