2Monthly Processing
Option 3Transaction Detail
If the Keep Detail in Transact File? option in the Parameters file is set to ‘Y’, this report shows detail from the Inventory Transaction file for the number of months specified in the Parameters file. It includes all posted transactions in Inventory Control.
When Inventory Control transactions and inventory-related transactions from Accounts Payable, Order Entry, or Purchase Orders are posted, detail from these transactions will also be posted to this file.
The following transactions from external applications are posted to the Inventory Control Transaction file:
- From Accounts Payable: invoices and adjustments
- From Purchase Orders: invoices
- From Order Entry: invoices A sample Transaction Detail report is shown below.
Expert Distributing, Inc.
05/24/91 11:01 am KAY Page: 1
Transaction Detail Report
Date
Time Jrnl Date Product Wh Account Quantity Cust Sales Vendor Cost
====================================================================================================================================
Journal Code ICAJ
07/30/89 15:38:38.92 ICAJ 08/05/89 10 20 1100001001WH 0.00 00000000 00000000 10.00
07/30/89 15:38:39.81 ICAJ 08/15/89 40 20 1100001001WH 45.00 00000000 00000000 19.65
07/30/89 15:38:40.55 ICAJ 08/03/89 20 10 1100001001WH 0.00 00000000 00000000 40.00
06/27/90 11:47:23.78 ICAJ 08/03/89 20 10 1100001001WH 0.00 40.00
---------- ----------
-- Journal Code Subtotals --> 109.65
========== ==========
Journal Code ICAP
07/30/89 16:06:49.05 ICAP 07/30/89 10 10 414.00 00000000 00000000 19665.00
07/30/89 16:06:49.64 ICAP 07/30/89 40 20 173.00- 00000000 00000000 71.30-
07/30/89 16:06:50.12 ICAP 07/30/89 10 20 149.00 00000000 00000000 7077.50
07/30/89 16:06:50.63 ICAP 07/30/89 30 20 322.00 00000000 00000000 4347.00
07/30/89 16:06:51.02 ICAP 07/30/89 40 30 18.00- 00000000 00000000 7.20-
07/30/89 16:06:51.52 ICAP 07/30/89 20 10 415.00 00000000 00000000 10375.00
07/30/89 16:06:52.16 ICAP 07/30/89 20 20 162.00 00000000 00000000 4050.00
07/30/89 16:06:53.06 ICAP 07/30/89 20 30 230.00 00000000 00000000 5750.00
07/30/89 16:06:53.37 ICAP 07/30/89 30 30 430.00 00000000 00000000 5805.00
07/30/89 16:48:37.20 ICAP 07/30/89 40 20 3.00 00000000 00000000 1.20
07/30/89 16:48:39.92 ICAP 07/30/89 10 20 7.00- 00000000 00000000 332.50-
07/30/89 16:48:42.22 ICAP 07/30/89 30 20 12.00- 00000000 00000000 162.00-
07/30/89 16:48:43.28 ICAP 07/30/89 20 20 290.00 00000000 00000000 7250.00
07/31/89 11:46:57.21 ICAP 07/31/89 40 20 3.00- 00000000 00000000 1.20-
07/31/89 11:46:57.85 ICAP 07/31/89 10 20 7.00 00000000 00000000 332.50
07/31/89 11:46:58.36 ICAP 07/31/89 30 20 12.00 00000000 00000000 162.00
07/31/89 11:46:58.70 ICAP 07/31/89 20 20 7.00- 00000000 00000000 175.00-
---------- ----------
-- Journal Code Subtotals --> 64066.00
========== ==========
Journal Code ICPT
07/30/89 15:37:12.22 ICPT 08/15/89 40 30 1100001001WH 5.00 00000000 00000000 67.50
07/30/89 15:37:13.00 ICPT 08/15/89 30 20 1100001001WH 5.00- 00000000 00000000 67.50-
07/30/89 15:37:14.52 ICPT 08/15/89 10 10 1100001001WH 1.00 00000000 00000000 52.50