header5

Inventory

Inventory Purchase Audit Report

 

Inventory Purchase Audit Reports provide a listing of all items on purchasing orders based on the program ID, the items requested and the location of the order, open or closed.  The report may be set to display open orders, closed orders, or both.  Remember:  This report displays purchasing orders only.

 

 

Report Setup

 

Program ID.  The report may be set to print for any inventory fulfillment program in the system.  The report will not print for Co-op items but will print for Customer Owned items.  Enter the program ID to print.  If the program ID is not known, enter "?" to display the Active Programs window.  Select the program to print by selecting the sequence number to the left of the program ID.  This report may only be printed for one program at a time.

 

Item Number.  The report may be set to print all of the items in a program or only one item.  To print for a particular item, enter the item number.  To print for all items, press Spacebar

 

Order Loc.  Order Location.  The report may be set up to print purchasing orders from open and/or closed order locations.  If only open purchasing orders are to print, enter "O".  Of only closed purchasing orders are to print, enter "H".  If both open and closed purchasing orders are to print, enter "B". 

 

The report will print the following information:

 

Item Number and Description .

 

Order #.  The order number that includes the items requested

 

Date.  This is the booked date or the date the order was entered into the system

 

Open.  This section contains three columns

 

Ordered.  This is the quantity section from Order Entry

 

Received.  This is the order quantity that has been recorded as received

 

Open.  This is calculated as Ordered Received.  Open is the backordered quantity

 

Closed.  This section contains two columns

 

Ordered.  This is the quantity section from Order Entry

 

Received.  This is the order quantity that was recorded as received on this order

 

Control.  This section contains three columns

 

On Order.  This is the total amount of this item on order due to this order

 

B.Q.O.H. Billable Quantity on Hand.  This is the amount of the item available for sale per the General Ledger due to this order.

 

On Hand.  This is the amount of this item on hand due this order.  Once an item is received, the On Order is decreased and the On Hand is increased.  Once the order is vouched, the BQOH is increased.