Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC11


IC11.1 - Item Master

**Form Purpose
Use Item Master (IC11.1) to add non-location specific item information,
including the location of an image file to view for Web-based ordering
applications. Even if an item is shared by multiple companies or locations,
you set up the item only once. For inventoried items, you set up at least one
location with at least one item location record in IC12.1 (Item Location).

**More Information
You can set up item master records directly in IC11.1 or you can customize
the item setup process to meet your specific needs in IC10.1 (Item Formats).
If you customize your own item setup format, you can streamline the process of
adding an item to the Item Master file in IC11.1 and/or to the Item Location
file in IC12.1. Instead of using IC11.1 and IC12.1, you use IC10.2 (Item
Master and Location) to add an item.

In the Item field, you can use two methods for mimicking existing items
(adding selectively or copying exactly).

Select the Add form action to create a new item with selected information.
IC11.1 creates a new item record with the following information:

- Information displayed on the visible form.

- Information from any other IC11.1 forms displayed for the existing item.

Select the Copy form action to quickly add like items to the Item Master
file. IC11.1 creates a new item record exactly like the displayed record.

- Inquire on the existing item.

- Change the item number and other requested fields.

- Select the Copy (Y) form action.

- If needed, select the Change form action to change field values.

If you are using the graphic user interface to enter item data, you can
choose the Attachment button to specify the universal resource locator (URL)
for an image of the item. This image is displayed when using Web-based
ordering.




Updated Files

    HAZARD     - An "in use" flag maintained by the program.

    ICAUDIT    - Created and maintained by the program if the audit flag is set
                 to Yes in IC00.1 (Corporate Item Group).

    ICITEMCODE -

    ICITEUF    -

    ITCOMMENT  - Maintained by the program.  All comments for an item are
                 deleted when the item is deleted.

    ITEMASTOUT -

    ITEMMAST   - Primary file maintained by the program.

    SOHDETAIL  - When the bin tracking flag is changed to Yes, all stock on
                 hand is added to the preferred bin in this file.

    TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and
                 the tax types that define how the tax code is to be used.

    TXCOMPANY  - The Tax Company file contains company information, as well as
                 which tax system the company uses.

    TXTAXCODE  - Used to validate the purchase and sell tax codes.

    TXTAXTABLE - Used in an Accounts Payable common routine.


Referenced Files

    APACCRCODE - An invoice accrual code is used to link a general ledger
                 invoice accrual account to an invoice.

    COLINE     -

    COMPONENT  - Used to check the existence of a kit component.

    CUCONV     - Used in a Currency conversion common routine.

    CURELAT    -

    GLSYSTEM   - Used to obtain the activity flag.

    ICCOMPANY  - Used in editing the deletion of an Item Master record.

    ICCOUT     -

    ICDICT     - Used to reference field names when creating audit records.

    ICGENERIC  - Used to validate the generic name.

    ICMANFCODE - This is a user defined list of codes used to identify
                 manufacturers of items.

    ICUSRFLDEF -

    ICVALUOM   - Used to validate the unit of measure.

    INSTCMDTY  -

    ITEMGROUP  - Used to validate the item group.

    ITEMLOC    - Used to validate the existence of quantities at the location
                 level.

    ITEMNDC    -

    ITEMSKU    -

    ITEMSUB    - Used to edit on a delete.

    ITEMUPC    -

    ITEMUPN1   -

    ITEMUPN2   -

    KITITEM    - Used to edit on a delete.  If the item is a part of a kit, it
                 cannot be
                 deleted.

    KWDDETAIL  -

    KWDSETUP   -

    MACOMPANY  -

    MAJORCL    - Used to validate major classes.

    MAMTCHELEM -

    MATCHCLASS -

    MINORCL    - Used to validate minor classes.

    POITEMVEN  - Used to validate the vendor's item number.

    POLINE     - Used to edit on a delete.

    POUSRFLDEF -

    POVAGRMTLN -

    PROCTEMPLN -

    PROCUREGRP -

    REQLINE    -

    RETURNLINE -

    TXTAXRATE  - Used in an Accounts Payable common routine.


IC11.2 - Item Universal Product Code

**Form Purpose
Use Item Universal Product Code (IC11.2) to enter the UPC (Universal Product
Code) by either manual entry or scanning by a HHT and other devices.

**Processing Effect
The UPC code will be stored whole as it was scanned in and can be used to
print out labels.




Updated Files

    None.


Referenced Files

    ICVALUOM   - Used to edit valid units of measure (UOMs).

    ITEMGROUP  - Used to validate the item group.

    ITEMMAST   - Primary file maintained by the program.

    ITEMUPC    -

    KWDDETAIL  -

    KWDSETUP   -


IC11.3 - Item Universal Product Number 1

**Form Purpose
Use Item Universal Product Number 1 (IC11.3) to enter the UPN (Universal
Product Number) by either manual entry or scanning by a HHT and other devices.


**Processing Effect
The UPN code will be stored whole as it is scanned in and can be used to
print out labels. This UPN is 14 character Alpha and is supported by the HIBCC
international group.




Updated Files

    None.


Referenced Files

    ICVALUOM   -

    ITEMGROUP  - Used to validate the item group.

    ITEMMAST   - Primary file maintained by the program.

    ITEMUPN1   -

    KWDDETAIL  -

    KWDSETUP   -


IC11.4 - Item Universal Product Number 2

**Form Purpose
Use Item Universal Product Number 2 (IC11.4) to enter the UPN (Universal
Product Number) by either manual entry or scanning by a HHT and other devices.


**Processing Effect
The UPN code will be stored whole as it is scanned in and can be used to
print out labels. This UPN is 20 character Numeric and is supported by the
UCC/EAN international group.




Updated Files

    None.


Referenced Files

    ICVALUOM   -

    ITEMGROUP  - Used to access the item group record.

    ITEMMAST   - Primary file created and maintained by program.

    ITEMUPN2   -

    KWDDETAIL  -

    KWDSETUP   -


IC11.5 - Item Stocking Keeping Unit

**Form Purpose
Use Item Stocking Keeping Unit (IC11.5) to enter the SKU (Stock Keeping Unit)
by either manual entry or scanning by a HHT and other devices.

**Processing Effect
The SKU code will be stored whole as it is scanned in and can be used to
print out labels.



$8 IC11 6
**Form Purpose
Use NDC Codes (IC11.6) to create a relationship between the Lawson item
identifier and the National Drug Code (NDC) number.

**More Information
The NDC number represents a specific drug, including the unit of measure and
the maker or distributor. After this procedure, you define one item number and
attach many NDC numbers representing various units of measure.




Updated Files

    None.


Referenced Files

    ICVALUOM   -

    ITEMGROUP  -

    ITEMMAST   -

    ITEMSKU    -

    KWDDETAIL  -

    KWDSETUP   -


IC11.6 - National Drug Code

Updated Files

    None.


Referenced Files

    ICVALUOM   -

    ITEMGROUP  -

    ITEMMAST   -

    ITEMNDC    -

    KWDDETAIL  -

    KWDSETUP   -


INVOKED Programs

    ICIB
    IFAC
    ACAC
    ACCL
    ACTA
    API4
    IFCU
    IFOB
    IFSG
    IFLU
    IFAU
    SLSE
    SLSU
    POI6
    POI4
    ICI4
    ICI1
    ICI5
    ICI6
    ICI7
    ICIC