Inventory Valuation Report | Contents | SCVs | Search | Glossary | Reports | XML | Index | Inventory Transaction Analysis Report |
Chapter 25: Printing the Inventory Transaction Analysis Summary and Detail Reports (PITA)
Purpose: Use the Inventory Transaction Analysis reports to review a summary of inventory transaction activity by warehouse for a range of dates, including:
• activity broken out according to types of transactions (transaction codes) and transaction reasons (transaction reason codes)
• totals for each warehouse and date, including a grand total across all warehouses and dates.
You can print the Inventory Transaction Analysis report in summary format or detail format.
In this chapter:
• Positive or Negative Effect on Inventory Levels
• Print Inventory Transaction Analysis Screen
• Inventory Transaction Analysis Report
• Inventory Transaction Analysis Detail Report
Positive or Negative Effect on Inventory Levels
The Effect on inventory field in the Item Transaction Code file indicates if the transaction code has a positive or negative effect on inventory levels. In addition, the Qty field in the Inventory Transaction History file indicates if the quantity associated with the inventory transaction has increased or decreased inventory. The combination of these values determines if the system considers the inventory transaction a positive or negative effect on inventory.
• Positive effect on inventory: If the system considers the inventory transaction a positive effect on inventory, the system includes the Qty and Cost defined for the inventory transaction in the (+) Units and (+) Cost fields on the Inventory Transaction Analysis Report and displays the Qty and Cost fields on the Inventory Transaction Analysis Detail Report as positive numbers.
• Negative effect on inventory: If the system considers the inventory transaction a negative effect on inventory, the system includes the Qty and Cost fields defined for the inventory transaction in the (-) Units and (-) Cost fields on the Inventory Transaction Analysis Report and displays the Qty and Cost fields on the Inventory Transaction Analysis Detail Report. as negative numbers.
Effect on inventory |
Qty |
Results |
+ |
Positive number |
|
+ |
Negative number |
|
- |
Positive number |
Negative effect on inventory |
- |
Negative number |
Positive effect on inventory |
Print Inventory Transaction Analysis Screen
Use this screen to print the Inventory Transaction Analysis report.
How to display this screen: Enter PITA in the fast path field at the top of any screen, or select Print Inventory Transaction Analysis from a menu.
INR1499 ENTER Print Inventory Transaction Analysis 9/05/03 17:00:23 EZK Mail Order
Date Range: . . . . . . to
Exclude Item Class: . .
Transaction Code: . . .
Reason Code: . . . . . .
Alloc/Non-Alloc/Store: .
Warehouse: . . . . . . .
Print Detail (Y/N): . . N
F3=Exit F9=Submit F12=Cancel |
Field |
Description |
Date range |
The date range you wish to use to generate the Inventory Transaction Analysis report. Enter a “from” date in the first field and a “to” date in the second field. The “to” date must be greater than the “from” date. You cannot enter a date greater than the current date. Numeric, 6 positions (MMDDYY format); required. |
Exclude item class |
A code for the item class you wish to excluded from the Inventory Transaction Analysis report. You can exclude up to 5 item classes. Item class codes are defined in and validated against the Item Class file. Alphanumeric, 3 positions; optional. |
Transaction code |
A code for the inventory transaction you wish to include on the Inventory Transaction Analysis report. If you define a transaction code, the system limits the data on the report to those inventory transactions associated with the specified transaction code. Inventory transaction codes are defined in and validated against the Item Transaction Code file. Alphanumeric, 1 positions; optional. |
Reason code |
A code for the inventory transaction reason you wish to include on the Inventory Transaction Analysis report. If you define a reason code, the system limits the data on the report to those inventory transactions associated with the specified reason code. Inventory transaction reason codes are defined in and validated against the Item Transaction Reason file. Numeric, 2 positions; optional. |
Alloc/Non-alloc/store |
A code for the type of warehouse you wish to include on the Inventory Transaction Analysis report. If you define a warehouse type, the system limits the data on the report to those inventory transactions associated with the specified warehouse type. Valid values: blank = Include all warehouse types on the report. A = Include only “Allocatable” warehouse types on the report. The system considers a warehouse “Allocatable” if the Allocatable flag is set to Y and the Retail outlet flag is set to N. N = Include only “Non-allocatable” warehouse types on the report. The system considers a warehouse “Non-allocatable” if the Allocatable flag is set to N and the Retail outlet flag is set to N. S = Include only “Store” warehouse types on the report. The system considers a warehouse a “Store” if the Retail outlet flag is set to Y, regardless of the setting of the Allocatable flag. You cannot enter a warehouse type if you enter a warehouse code in the Warehouse field: Warehouse and Alloc/Non-alloc/Store flag are mutually exclusive. Alphanumeric, 1 position; optional. |
Warehouse |
A code for the warehouse you wish to include on the Inventory Transaction Analysis report. If you define a warehouse code, the system limits the data on the report to those inventory transactions associated with the specified warehouse code. Warehouse codes are defined in and validated against the Warehouse file. You cannot enter a warehouse if you enter a warehouse type in the Alloc/Non-alloc/Store field: Warehouse and Alloc/Non-alloc/Store flag are mutually exclusive. Numeric, 3 positions; optional. |
Indicates which type of Inventory Transaction Analysis report you wish to print. Valid values: Y = Print the Inventory Transaction Analysis Detail Report. N (default) = Print the Inventory Transaction Analysis Report. Alphanumeric, 1 position; required. |
Completing this screen:
1. Enter both the From and To dates in MMDDYY format. The system validates that the From date is not later than the To date and that the dates are not greater than the current date.
2. Optionally, exclude an Item class or limit the report to a specified Transaction code, Reason code, Warehouse type or Warehouse.
3. Indicate if you wish to print the summary version or detailed version of the Inventory Transaction Analysis report.
4. Press F9. The system submits the INV_VAL job:
• If the Print detail field is set to Y, the system generates the Inventory Transaction Analysis Detail Report.
• If the Print detail field is set to N, the system generates the Inventory Transaction Analysis Report.
Inventory Valuation Report | Contents | SCVs | Search | Glossary | Reports | XML | Index | Inventory Transaction Analysis Report |
WH03_08 CWDirect 18.0 August 2015 OTN