Printing the Aged Receiving Report (PARR)

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

The Aged Receiving report displays inventory aged based on receipt transactions. 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 aging 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 table is blank) display at the beginning of the report under the vendor number 0.

Determining the Age of Inventory Receipts

CWSerenade looks at receipt transaction records (transaction code R) in the Item Transaction History table 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/07. CWSerenade finds the following receipt transaction records in the Item Transaction History table:
3/15/07:	receipt transaction for 5 units
2/01/06:	receipt transaction for 10 units
8/01/06:	receipt transaction for 15 units
2/01/06:	receipt transaction for 20 units
In this situation, CWSerenade splits the inventory into the following receipt aging buckets:
0-90 days:	15 units (5 units received on 3/15/07 + 10 units received on 2/01/06)
181-360 days:	15 units (15 units received on 8/01/06)
360+ days:	20 units (20 units received on 2/01/06)
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/07. CWSerenade finds the following receipt transaction records in the Item Transaction History table:
2/15/07:	receipt transaction for 170 units
12/15/06:	receipt transaction for 100 units
1/10/06:	receipt transaction for 110 units
In this situation, CWSerenade splits the inventory into the following receipt aging buckets:
0-90 days:	75 units (170 units received on 2/15/07)
The remaining units associated with receipt transactions are ignored since the total on hand quantity (75 units) has been accounted for.

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.

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.

Field

Description

Select vendor #

The vendor number for which you wish to generate the Aged Receiving report.

An error message indicates 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 table.

Numeric, 7 positions; optional.

How to print:

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

2. Select OK.