Inventory Stock Status Report

 

Window Details

 

How Do I...

Navigation

 

Create a Report Setting

Overview

 

Print a Report, Listing, or Form

Fields

 

E-mail, Fax, or Print a Report as a PDF

Report Sample

 

Enter Multiple Values Using Separators

 

Related Topics

 

 

Inventory Management Options

Item Maintenance

Sales Order Options

 

 

 

Navigation

Select Inventory Management Reports menu > Inventory Stock Status Report.

Overview

Use Inventory Stock Status Report to display the quantity on hand, on back order, on purchase orders, on sales orders, on work tickets, reorder point, average cost, warehouse detail, and required for work tickets for each item listed. In addition, the quantity available for sale (calculated by subtracting the quantity on sales orders and quantity on back order from the quantity on hand) is shown as of the current date.

You can enter a selection of item codes, product lines, primary vendor numbers, item descriptions, inventory cycles, warehouses, bin locations, user-defined categories (if descriptions have been entered in Inventory Management Options), and user-defined fields (UDFs) to include in the report.  

The quantity available can include or exclude the quantity on purchase orders, the quantity on work tickets, and the quantity required for work tickets, depending on the setup in Inventory Management Options. Work ticket information is available if the Production Management module is activated.

The sales order lot and serial distribution can be printed on the report if the Enable Lot/Serial Distribution check box is selected in Sales Order Options, and the line items have been distributed in Sales Order Entry.

Note This report prints the item's primary vendor information and does not include other vendors associated with the item.

Fields

 

Report Setting

Print Warehouse Detail

Description

Print Lot/Serial Distributions

Type

Product Types to Print

Default Report

Procurement Types to Print

Print Report Settings

Print Inactive Items

Three Hole Punch

Operand

Number of Copies

Value

Collated

Printer/Output

Sort Report By

Keep Window Open After Print

Print Zero Balances

Keep Window Open After Preview