Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

IC37


IC37.1 - Daily Transaction Summary

**Form Purpose
Use Daily Transaction Summary (IC37.1) to view online, the daily inflow and
outflow of released inventory transactions. Think of this as a daily "flash"
of activity.

**More Information
To use the form, enter a company, an inventory location or an inventory
report group, a date option, and a date for which you want to see daily
totals. The date option allows you to accumulate the inventory transactions by
the transaction date, the GL date, or the update date. The date option applies
to different dates that are stored on the inventory transaction record.


1. The Transaction Date is the date an inventory transaction is entered. Such
as when receipt of an inventory item is added into the Purchase Order
application.

2. The GL Date is the date the inventory transaction will post or has posted.
Some transactions, like inventory receipts, have an enterable data item for
the GL date, and you can enter what GL posting date you want on the
transaction. Other transactions, like purchase order receiving, automatically
takes the receiving date and stores it in the GL date field.

3. The Update Date is the date the release function is done on the inventory
transaction.

Note There is a distinction made between when a transaction was entered and
when that transaction was released.

Keep the following in mind when analyzing the data on this inquiry form:


1. Receiving inspection rejections (type RJ) that are NOT "write offs" and
that produce vendor returns (type VR) will not appear in the Adjustments
Receivings (RQ-RJ) category, but will appear in the Outflow Vendor Returns
category after the "ship" function is done on that vendor return. Receiving
inspection rejections (type RJ) that ARE "write offs" WILL appear in the
Adjustments Receivings (RA-RJ) category because there is no further action in
the form of a vendor return.

2. Cost Adjustments hold the units quantity for the Cost Adjustments that are
done on that day, but the units quantity is not included in the Daily Units
Quantity Total because the Cost Adjustment is only a change to the cost and
not a change to the units quantity of the item at the location.

3. All the transactions that are captured are released transactions.




Updated Files

    CKPOINT    -


Referenced Files

    ICCOMPANY  -

    ICLOCATION -

    ICRPTGRP   -

    ICTRANS    -

    PORECEIVE  -