Select Options

You can run the Item Status Report (RIS) with any of the following Select Options:

B = Print only items with UPCs.  Prints only items with UPCs entered in UPC Maintenance.  An asterisk (*) will r9int next to items which have more than one UPC.

C = Print only items without UPCs.  Prints only items that do not have UPCs entered in UPC Maintenance.

D = Print only discontinued items.  Prints only items with Y in the Discontinued field in Inventory Maintenance, the Codes tab.

P = Print items with Retail Price = 0.  Print items that do not have a retail price in Inventory Maintenance, the Pricing tab.  Items with Keep Prices = N (in Inventory Maintenance, the Codes tab) will not be included on the report.

R = Print items with Replacement Cost = 0.  Prints items that do not have a replacement cost in Inventory Maintenance, the Pricing tab.   Items with Keep Prices = N (in Inventory Maintenance, the Codes tab) will not be included on the report.

S = Print non 0 To Date field items.  Prints items which have an amount in the To Date field in Inventory Maintenance, the History tab.

U = Update Date of Last Physical Inventory.  Updates the Last Physical Inventory field in the Stocking tab of Inventory Maintenance, with the date the report was run.  This can help you monitor inventory counts to ensure that every item is counted on a regular schedule.

V = Use Order Multiple in overstock calculation.  You can use this option with Report Type B, or with any report that includes the Overstock Cost Value field.  The system will consider an item overstocked if it meets the following condition:

QOH > Order Point (or Maximum Stock Level) - 1 + Order Multiple

For example:

Using the calculation, this item is not overstocked.  The quantity on hand (22) is less than the Order Point (13) - 1 + the Order Multiple (12).

Use Option V for items that you purchase from the primary vendor assigned to the item.

W = Use Standard Package in overstock calculation.  You can use this option with Report Type B, or any report that includes the Overstock Cost Value field.  The system will consider an item overstocked if it meets the following condition:

QOH > Order Point (or Maximum Stock Level) - 1 + Standard Package

For example:

Using the calculation, this item is overstocked.  The quantity on hand (25) is greater than the Order Point (13) - 1 + the Standard Package (12).

Use Option W for items that you purchase from the manufacturer vendor assigned to the item.

X = Print items with QOH < 0.  Available with Report Type C.  Prints items whose quantity on hand is less than zero.  Use this option to help you identify and correct invalid quantities.

Z = Print items with QOH = 0.  Available with Report Type C.  Prints items whose quantity on hand is equal to zero.  Use this option to help you identify out of stock conditions.