Daily Transaction Summary (IC37.1)

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 general ledger 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.

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.