Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

IC50

IC50.1 - Transaction History

Use transaction history forms to audit transaction history records by update
date (IC50.1), in detail (IC50.2) or by transaction date (IC50.3). Transaction
history records are created as a result of all transaction types updated to
the Inventory Control system.

Use IC50.1 to display item transaction history records by update date. This
is the date transactions were updated to the Inventory Control system. This
form displays the transaction type, update date/time, bin, transaction
quantity, after stock-on-hand quantity, and document ID. Transaction records
list in descending order beginning with the most recent update date.

To display a specific record in a selected form, select the line action X and
the Transfer form action. Then, select a form. For example, you could choose
IC50.2 to display the record in detail or choose IC50.3 to display history
records by transaction date.

To display summarized transaction quantities by period, use IC49.1 (Usage
History).

Updated Files

    None.


Referenced Files

    ICCOMPANY  - Used to validate company numbers.

    ICLOCATION - Used to validate locations.

    ICTRANS    - Used to retrieve inventory transaction information.

    ITEMLOC    - Used to validate items at a location.

    ITEMMAST   - Used to validate item master records.

    PORECLINE  - Used to retrieve purchase order transaction information.


IC50.2 - Detail Transaction History

Use this form to display detail item transaction history records. Transaction
history records are created as a result of all transaction types updated to
the Inventory Control system. The records include adjustments (AJ), bin
transfers (BT), cost adjustments (CA), customer returns (CR), issues (IS),
issue transfers (IS), physical inventory (PI), purchase order receipts (PO),
purchasing receipt adjustments (RA), inventory receipts (RC), rejected PO
inspections (RJ), requisition returns (RR), receipt transfers (RT), and
shipments (SH.)

This form is similar to IC50.1 (Transaction History) but also includes the
secondary quantity and unit of measure for catch weight items, operator name,
before and after stock-on-hand quantities, general ledger and IC update
status, unit cost, reason code, comments, reference notes, and activity.

Note: Transaction history records display in this form by update date/time.
Typically, a transaction record is transferred to this form from IC50.1
(Transaction History) or IC50.3 (Transaction Date History).

Updated Files

    MMUAVAL    - This file defines the user analysis values defined for
                 transactions.



Referenced Files

    CUCONV     - Used in a Currency conversion common routine.

    CURELAT    - Used to validate currency relationships.

    GLSYSTEM   - Used to obtain the activity flag.

    ICCOMPANY  - Used to validate the company number.

    ICLOCATION - Used to validate the location.

    ICTRANS    - Used to retrieve inventory detail transaction information.

    ITEMLOC    - Used to validate items at a location.

    ITEMMAST   - Used to validate items.

    MMDIST     - This record holds an account number and possibly an activity
                 code intended for  a general ledger distribution of an
                 inventory item.


    POCOMPANY  - Used to retrieve Purchase Order historical transactions.

    POLINE     - Used to retrieve an activity from the purchase order line.

    PORECEIVE  - This file contains header information for the Purchase Order
                 receiver.


    PORECLINE  - Used to retrieve purchase order detail transaction information.


    PURCHORDER - Used in a Requisitions common routine.


IC50.3 - Transaction Date History

Use this form to display transaction history records by transaction date.
This is the date transactions were created. Transaction history records are
created as a result of all transaction types updated to the Inventory Control
system. The types include adjustments (AJ), bin transfers (BT), cost
adjustments (CA), customer returns (CR), issues (IS), issue transfers (IT),
physical inventory (PI), purchase order receipts (PO), purchasing receipt
adjustments (RA), inventory receipts (RC), rejected PO inspections (RJ),
requisition returns (RR), receipt transfers (RT), and shipments (SH).

This form displays the transaction type, transaction date/time, bin
transaction quantity, and document code. This form lists transaction in
descending order beginning with the most recent transaction date. Otherwise,
you can display transactions on or before a specified transaction date. To
display a specific record in a selected form, select the line action X and the
Transfer form action. Then, select a form. For example, you could choose
IC50.1 to display item transaction history by update date or IC50.2 to display
detail transaction history.

Updated Files

    None.


Referenced Files

    ICCOMPANY  - Used to validate the company number.

    ICLOCATION - Used to validate the location.

    ICTRANS    - Used to obtain the needed transactions for display.

    ITEMLOC    - Used to validate the item location.

    ITEMMAST   - Used to obtain the item description.

    PORECLINE  - Used to obtain the Purchase Order receiving records.


INVOKED Programs

    IFCR
    IFSG