Aged Receiving Report

Purpose: This report displays inventory aged based on receipt transactions (Transaction code R in the Item Transaction History file). Only items with an on-hand quantity display on the report. If there are no items with an on-hand quantity for a vendor, a blank page with the vendor number and name displays.

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.

How to print: Press Enter at the Aged Receiving Report Screen.

CWDirect Rel 12.0 Aged Receiving Report KBOTTGER INR1798 9/06/10 14:33:02 Page 1 KAB Co Vendor# . . . . . . . . . : 12345 12345 ARGON LIMITED Include returns in aging buckets : N Last Last Primary ------------------ Aged Receivings ------------------ Item SKU Purch Cost Rec Date Loc On Hand 0-90 91-180 181-360 360+ Unknown 12345A 5.0000 9/06/10 MAIN 50 10 20 20 CANNING JAR LIDS - REGULAR 15 30 30 Buyer: BERNADETTE T MIRANDA Cost: 1.5000 Ext: 75.0000 ------------------------------------------------------------------------------------------------------------------------------- 12345B 5.0000 9/06/10 MAIN 111 10 20 30 40 11 CANNING JAR LIDS - WIDE MOUTH 15 30 45 60 17 Buyer: BERNADETTE T MIRANDA Cost: 1.5000 Ext: 166.5000 ------------------------------------------------------------------------------------------------------------------------------- 2005AB89DDXN 1.0000 2050101 1 1 CANNING JAR LIFTER 1 Buyer: BERNADETTE T MIRANDA Cost: 1.0000 Ext: 1.0000 ------------------------------------------------------------------------------------------------------------------------------- Total Cost 0-90 91-180 181-360 360+ Unknown 242.5000 30.00 60.00 75.00 60.00 17.50

Contents:

• Vendor #: The number and name of the vendor associated with the inventory. This is the vendor defined in the Vendor number field for the item in the Item file.

• 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.

• Y = Return transactions are included in the Aged Receiving buckets.

• N = Return transactions are included in the Unknown bucket.

For each item/SKU:

• item: The item number for the inventory received. The first 20 positions of the description of the item displays below the item number.

• SKU: The SKU code for the inventory received. The description of the SKU displays next to the item description.

• Last purchase cost: The unit cost of the item on the last purchase order received. This is the last purchase cost from the Last purchase cost field in the SKU file.

• Last receipt date: The date the last purchase order was received. This is the last receipt date from the Receipt date field in the SKU file.

• Primary location: The primary location defined for the item. This is the location from the Location field in the SKU file.

• On hand: The total on hand for the item, across all warehouses. This is the on hand quantity from the On hand quantity field in the Item Warehouse file. If the item is located in more than 1 warehouse, the system sums the on hand quantity defined for each item warehouse to determine the total on hand quantity.

• Aged receiving: The system splits the on hand quantity into the appropriate aging bucket based on when the inventory was received. See Determining the Age of Inventory Receipts for more information on how the system determines the quantity to place in each aging bucket.

• 0-90: The total units received for the item in the last 90 days.

• 91-180: The total units received for the item in the last 91-180 days.

• 181-360: The total units received for the item in the last 181-360 days.

• 360+: The total units received for the item over 360 days ago.

• Unknown: The total units of the on hand quantity added to inventory by a method other than purchase order receipts. Transactions that update this value are positive inventory transactions, returns (that affect inventory), and purged inventory transaction history records. Returns are only included in the Unknown bucket if the Include returns in aging buckets field on the Aged Receiving Report Screen is set to N; otherwise, returns are included in the Aged receiving buckets.

• Extended cost for aging receiving: (unlabeled field below the units for each aging bucket): The extended cost of the item for the specific aging bucket. This is the cost from the Average cost, Standard cost, or FIFO cost field in the SKU file (depending on your Costing Method (A25)) multiplied by the aging quantity (cost x aging quantity = extended cost). Note: The system rounds the extended cost for aging to the nearest dollar. For example, if the extended cost for the unknown aging bucket is 16.50, the extended cost on the report is 17.

• Buyer: The name of the buyer from the Buyer field in the Item file.

• Cost: The cost of the item from the Average cost, Standard cost, or FIFO cost field in the SKU file (depending on your Costing Method (A25)).

• Extended cost for item/SKU: The extended cost of the item/SKU. This is the cost from the Average cost, Standard cost, or FIFO cost field in the SKU file (depending on your Costing Method (A25)) multiplied by the on hand quantity (cost x on hand quantity = extended cost).

Note: If there is no cost for an item/SKU in the Average cost, Standard cost, or FIFO cost field in the SKU file (depending on your Costing Method (A25), no cost or extended cost is listed on the report.

Report totals:

• Total cost: The total cost of the inventory, across all inventory received. This is the sum of the extended cost defined for each item/SKU on the report.

• Total 0-90 aged receiving cost: The total cost of the units received in the last 90 days. This is the sum of the extended cost defined for the 0-90 bucket for each item/SKU on the report.

• Total 91-180 aged receiving cost: The total cost of the units received in the last 91-180 days. This is the sum of the extended cost defined for the 91-180 bucket for each item/SKU on the report.

• Total 181-360 aged receiving cost: The total cost of the inventory received in the last 181-360 days. This is the sum of the extended cost defined for the 181-360 bucket for each item/SKU on the report.

• Total 360+ aged receiving cost: The total cost of the inventory received over 360 days ago. This is the sum of the extended cost defined for the 360+ bucket for each item/SKU on the report.

• Total unknown cost: The total cost of the inventory received by a method other than purchase order receipts. This is the sum of the extended cost defined for the unknown bucket for each item/SKU on the report.