Printing the Aged Receiving Report (PARR)

Purpose: Use this menu option to print the Aged Receiving report for a selected vendor or for all vendors.

In this topic:

• Determining the Age of Inventory Receipts

• Aged Receiving Report Screen

• Aged Receiving Report

The Aged Receiving report displays inventory aged based on receipt transactions (Transaction code R in the Item Transaction History file). The age of the inventory is divided into 4 aging buckets: received 0-90 days ago, received 91-180 days ago, received 181-360 days ago, and received over 360 days ago. If inventory is increased by another method other than receipts, such as a positive adjustment, return, or purged inventory transaction history record, the units associated with the transaction are placed in a separate Unknown bucket.

Only items with an on-hand quantity display on the report. If there are no items with an on-hand quantity for a vendor, inventory for the vendor does not display on the report.

The total cost of the inventory across all vendors and items displays at the bottom of the report.

The Aged Receiving report sorts by vendor. For each vendor, the report sorts in item, SKU sequence. Items that are not associated with a vendor (the Vendor number field for the item in the Item file is blank) display at the beginning of the report under the vendor number 0.

Determining the Age of Inventory Receipts

CWDirect looks at receipt transaction records (Transaction code R) in the Item Transaction History file to determine how to split the on hand quantity into the receipt aging buckets that display on the report. The system looks for receipt transaction records until the current on hand quantity across all warehouses has been accounted for. If an on hand balance remains that cannot be accounted for in receipt transactions, the remaining quantity is placed in the other aging bucket on the report. An on hand balance may exist if inventory was increased as a result of a positive inventory adjustment, returns, or purged inventory transaction history records.

Example 1
The current on hand quantity is 75 units. The current date is 3/13/02. CWDirect finds the following receipt transaction records in the Item Transaction History file:
3/15/02:	receipt transaction for 5 units
2/01/01:	receipt transaction for 10 units
8/01/01:	receipt transaction for 15 units
2/01/01:	receipt transaction for 20 units
In this situation, CWDirect splits the inventory into the following receipt aging buckets:
0-90 days:	15 units (5 units received on 3/15/02 + 10 units received on 2/01/01)
181-360 days:	15 units (15 units received on 8/01/01)
360+ days:	20 units (20 units received on 2/01/01)
unknown:	25 units (25 units not associated with a receipt transaction to reach the current on hand quantity of 75 units)

Example 2
The current on hand quantity is 75 units. The current date is 3/13/02. CWDirect finds the following receipt transaction records in the Item Transaction History file:
2/15/02:	receipt transaction for 170 units
12/15/01:	receipt transaction for 100 units
1/10/01:	receipt transaction for 110 units
In this situation, CWDirect splits the inventory into the following receipt aging buckets:
0-90 days:	75 units (170 units received on 2/15/02)
The remaining units associated with receipt transactions are ignored since the total on hand quantity (75 units) has been accounted for.

Including Returns in Aged Receiving

The Include returns in aging buckets field on the Aged Receiving Report Screen defines whether the system includes return transactions (Transaction code C in the Item Transaction History file) in the Aged Receiving buckets or the Unknown bucket on the Aged Receiving Report.

• If the Include returns in aging buckets field is set to Y, the system includes return transactions in the Aged Receiving buckets.

• If the Include returns in aging buckets field is set to N, the system includes return transactions in the Unknown bucket.

Example: The following inventory transaction history records exist in the Item Transaction History file for item AB1.

Date	Transaction code	Quantity	Old on hand	New on hand
9/06/05	R (receipt)	40		40
2/06/06	R (receipt)	30	40	70
5/06/06	R (receipt)	20	70	90
9/06/06	R (receipt)	10	90	100
9/06/06	A (adjustment)	10	100	110

Based on the transaction records in the Item Transaction History file for item AB1, the Aged Receiving Report contains the following information for item AB1.

Item	On Hand	0 - 90	91 - 180	181 - 360	Over 360	Unknown
AB1	110	10	20	30	40	10

You perform a return for 1 unit of item AB1. The Aged Receiving Report contains the following information for item AB1, based on the setting of the Include returns in aging buckets field:

Include returns in aging buckets	Item	On Hand	0 - 90	91 - 180	181 - 360	Over 360	Unknown
Y	AB1	111	11	20	30	40	10
N	AB1	111	10	20	30	40	11

Aged Receiving Report Screen

Purpose: Use this screen to generate the Aged Receiving report for the vendor you select. If you do not define a vendor, the system prints the Aged Receiving report for all vendors.

Optionally, you can select to include returns in the aging buckets rather than the unknown bucket.

How to display this screen: Enter PARR in the Fast path field at the top of any menu, or select Print Aged Receiving Report from a menu.

INR1796 ENTER Aged Receiving Report 9/06/06 10:44:07 KAB Co Select vendor# . . . . . . . (leave blank for all vendors) Include returns in aging buckets . N (Y/N) F3=Exit F12=Cancel

Field	Description
Select vendor #	The vendor number for which you wish to generate the Aged Receiving report. An error message displays if you enter an invalid vendor number. Leave this field blank if you wish to generate the Aged Receiving report for all vendors. Vendor numbers are defined in and validated against the Vendor file. Numeric, 7 positions; optional.
Include returns in aging buckets	Indicates whether return transactions (Transaction code C in the Item Transaction History file) are included in the Aged Receiving buckets or the Unknown bucket on the Aged Receiving Report. Valid values: Y = Return transactions are included in the Aged Receiving buckets. N (default) = Return transactions are included in the Unknown bucket. See Including Returns in Aged Receiving for an example. Alphanumeric, 1 position; required.

How to print:

1. Optionally, enter a vendor number if you wish to generate the Aged Receiving report for a specific vendor.

2. Indicate whether you wish to include return transactions in the aging buckets.

3. Press Enter.

4. The system returns you to a menus screen and displays a message indicating the Aged Receiving Report has been submitted: Job AGED_RCVNG submitted to job queue QBATCH.