Item Inventory Range Report

Inventory>Reports>Item Inventory Range Report

PRINTS ON LEGAL SIZE PAPER (8 1/2 x 14)

This report prints item inventory, based upon selected framing parameters.

Sort Order

The sort order offers a variety of options.  Depending upon the need, the sort can be an important part of printing this report:

Print the report to reconcile the value of inventory received during a period with the value of inventory entered into Accounts Payable for the same period.  You will do this by selecting Product Code, Supplier, and Inv. # as the SORT value and by specifying "I"nitial value along with the appropriate limiting invoice dates.

Print the report by Location and for the "Current Value" will provide you with value reports by location.

Value

Initial value reflects the original inventory value when received.  Current value reflects the gross cost multiplied by the current amount available.

Include On-Order Inventory 

Select to include all inventory on a purchase order that in "On Order".

Include Runlot 

Select this option in order to print Runlot information on this report.

Show Dollar Amounts 

Select to print the unit gross cost and total value.

Include Reserves

Select to include reserves in your available amount, soft reserves are included in the available number unless the next box is checked.

Exclude Soft Reserves

Select to exclude soft reserves in your available amount. If soft reserves are excluded this will show on the report.

Uncosted Inventory

Select to have Uncosted Only or include Uncosted in the with the Costed.  If uncosted does not need to be listed, do not check either box.

Product Codes 

Can print a single product code, all product codes or a combination of many.  Click the Tag All button to select all, or single click individual product codes.

Stores 

Can print report for one store or all stores.  Combined will total all inventory together.

Manufacturer, Supplier, Private Supplier, Name, and Description 

Can print a report for one particular group of these fields.  Leave blank for all.

From and To Fields 

To print within a range, specify the beginning and ending criteria.  For example, to print a report of everything that was received yesterday, enter yesterday's date in both the Date Received From and Date Received To fields.

PO# from and to must include the line number with no dash or spaces. For example, this #ST058070027 not #ST05807 or #ST05807-0027.

Printer

Select the printer to use.

Print Preview 

Select to view the report on the screen before printing.

Copies

Enter the number of copies to be printed, enter zero to preview the report only.

Shade Alternate Rows 

Select to shade every other row on the report for easier reading.

Page Break After 

Select this option to insert a page break after the following fields:  Manufacturer, Supplier, Private Label Company, Product Code, Name and Collection.  The Sort Order that you choose will determine these options.  

Output CSV To: 

Select where the csv file will be stored.

List of fields in the csv file. 

Output Notes to CSV

Select to export all line notes to text file for use in other applications.

Some Additional Fields on .CSV output- Collection, Price Code, Fiber, Construction, and Country of Origin.

Transferred records are not reported in the Item Inventory Range Report.  This report comes from the Original Record.  Suggest report to view transferred records is the Inventory Adjustment Report.