Roll Inventory Range Report

Inventory>Reports>Roll Inventory Range Report

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

This report prints roll inventory, based upon the framing parameters selected on this screen.

Sort Order

The sort order offers a variety of options.  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 Pr. Code, Supplier, and Inv. # as the SORT value and by specifying "I"nitial value along with the appropriate limiting invoice dates.

Printing the report by Location and for the "Current Value" will provide 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".

Show Dollar Amounts 

Select to print the unit gross cost and total value.

Include Reserves

Select to include reserves in available amount

Exclude Soft Reserves

Select to exclude soft reserves in the available amount.

If soft reserves are excluded there will be an asterisk next to the total amount with the soft reserve amount listed in the column next to the available amount.

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 rolls only (01), vinyl only (02) or both.

Roll or Cut 

Can print the report for rolls only, cuts only, or both.

Stores 

Choose one or more store or all stores.  Combined will total all chosen stores together.

Manufacturer, Supplier, Private Supplier, Style, and Color 

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. Physical size- to exclude zero amounts, enter the amounts as from .01 and to 99999.99.

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

Output CSV To: 

Select where the csv file will be stored.

Output Notes to CSV

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

Print Preview 

Select to view the report on the screen before printing.

Shade Rows 

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

Page Break After Style 

Select to begin printing on a new page for each style on the report.