Item Purchase and Sales Aging Report

How to print: Use the Item Purchase and Sales Aging Report (LIPS) menu option.

For more information: See the sample report in PDF format.

Note: This report is also available as a spreadsheet file, which you can open in a spreadsheet application such as Microsoft Excel®. See Reports Available in Spreadsheet Format for more information.

Contents:

• Warehouse

• Vendor number and description

• Item/SKU

• On hand quantity

• Month to date

• Year to date

• Reserved quantity

• Open purchase order quantity

• Weekly receipts aging buckets (updates when you receive the item)

- 0-7 days

- 8-14 days

- 15-21 days

- 22-28 days

- 28 and over days

• Last purchase order number

• Weekly sales aging buckets (updates when you confirm the item)

- 0-7 days

- 8-14 days

- 15-21 days

- 22-28 days

- 28 and over days

• Last receipt date

CS06_01r OMS 17.1 September 2018 OTN