header5

Inventory

Inventory Sales Audit Report

 

Inventory Sales Audit Report provides a listing of all orders for the program ID and the item(s) entered.  The report lists open orders, closed orders, or both.  NOTE:  This report is for selling orders only.

 

 

Report Setup

 

Program ID.  This report will only print for one program at a time.  Enter the program ID for the program to print.  If the program ID is unknown, enter "?" to display the Active Programs window.  Select the program by entering the sequence number to the left of the program ID.

 

Item Number.  Enter the item number to print.  To print all items in the program entered above, press Spacebar.  If the item number is not known, enter "?" to display the Program Items window.  Select the item to print by entering the sequence number to the left of the item number.

 

Order Loc.  Order location.  This report may be set up to print orders that are open, been sent to history, or a combination of the two.  For open orders only, enter "O".  For history orders only, enter "H".  For both open and history orders, enter "B". 

 

The report will print the following information:

 

Item Number and Description.  The page is subdivided by the items that print

 

Order #.  The orders that contain the item

 

Date.  Date the order was entered into the system

 

Open.  This section contains three columns:

 

Ordered.  The quantity field from Order Entry

 

Shipped.  This is the quantity recorded on the order as being shipped out to the customer

 

Open.  This is a calculated figure of Ordered Shipped

 

Closed.  This section contains two columns:

 

Ordered.  This is the quantity field from the order

 

Shipped.  This is the quantity recorded on the order as being shipped out to the

customer

 

Control.  This section contains three columns.  The only line printed for this section appears on the totals line for each item:

 

On Order.  This is the total amount of this item shown as been shipped from the vendor to your warehouse.  This is the open items on purchasing orders.

 

B.Q.O.H.  Billable Quantity On Hand.  This is the amount of the item that has been vouched and billed in the system.  The total amount vouched less the total amount billed equals the BQOH.

 

On Hand.  This is the total amount of the item on the shelves.  This is obviously a pre-shipment number.  Shipping the item reduces the On Hand quantity