Reconciling Material Usage with Receipts

Par location reconciliation begins with the Material Usage Reconciliation report (INS9070), which gathers all receipts from purchase orders and all issues from inventory for a specific par location over a specific period of time. The receipts and issues result from the Create Par Replenishment Requests process (INPGCDMD), which compares par location counts with the optimum quantity defined for the par location. If the count is less than the optimum quantity (presumably due to usage for a patient from the par location), a requisition, purchase order, or material stock request is created.

The Material Usage Reconciliation report also gathers the number of items from the par location that have been charged to a consumer. After collecting data, you can generate the Consumer Usage Reconciliation - Summary report to compare consumer usage with receipts and issues for the par location over a given period of time and identify any lost charges. For any given item in a par location, the issue and receipt quantity should equal the total quantity charged to consumers. This information is also collected for non-par locations, referred to in PeopleSoft as internal locations.

The Consumer Usage Reconciliation - Summary report lists the actual receipt transactions and usage that meet report request parameters. The report is a set of three detail reports: the Usage Detail report, Shipment Detail Report, and Receipt Detail report. The detail reports can be used in conjunction with the Consumer Usage Reconciliation - Summary report, Review Consumer Usage page, Review Shipment History page, and Receipt By Loc page to assist you in the manual process of researching items that do not reconcile for a location.

This topic discusses:

• Setting Up Reconciliation.

• Determining the Last Purchase Order Price Paid.

• Researching Lost Charges.