Skip to content

Retail Inventory Short Format Listing Report

Action: RP_INVLISTS

This report shows you your entire retail inventory, using only one line per item.

Note: The cost column is the inventory style's reorder cost.

Criteria

Limit to vendor...You can limit the report to a specific vendor, if you like. Leave blank for all vendors.

Limit to category...You can limit the report to a specific category, if you like. Leave blank for all categories.

Last received between xxx and yyy...Only show items received between the dates specified. You must enter a date range.

Limit to QOH more than zero?...Only show items with at least QOH of 1.This option checked will not include sales of size/colors with a QOH of zero and thus omit any sales figures that these items may have. This may result in seeing less MTD, YTD or Life Total numbers than you expect on the report.

However, this setting does not affect the OTHER size/color for each style being reported. The report will include OTHER sales totals for each style in the report. Each Style by default has a OTHER SCW created. This accumulates sales statistics for the style being sold when size, colors, widths are sold for the style that does not exist in the inventory. OTHER cannot contain a quantity on hand and is always zero.

Discontinued status... Select ALL to disregard discontinued status and to see all styles. Select Discontinued to list only discontinued styles and select Not Discontinued to see only not discontinued styles.

Limit to store(s)...This option is available with the optional multi-store module. It will limit the listing to inventory items for the entered stores. Multiple store IDs may be entered separated by a comma.

Include rental styles?...Normally, the report will not include rental styles (styles with an item type.) If this is checked then rental styles are included with the retail styles.