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