Enter the options you want to use when running the Inventory Valuation Report (RIV). The following options are available:
B = Compute Annualized Value Using Date Added. Calculate annualized cost and sales for items added to your system after the first day of your current fiscal year. The system uses the date in the Added to File field in Inventory Maintenance, the Stocking tab, to calculate annualized cost and sales as follows:
Year-to-date x 365
cost or sales --------
Number of days between
the Added to File date and
today's date.
If you don't use option B, annualized cost and sales are calculated as follows:
Year-to-date x 365
cost or sales --------
Number of days
in the year so far
For example: Your business operates on a calendar year. Today is April 10th, the 100th day of the year. You added SKU 123 today and sold it for $10.00, with a cost of $5.00. The table that follows shows the annualized cost and sales for this item.
With Option B Without Option B
------------- ---------------
Ann. Cost Ann. Cost
$5.00 x 365 $5.00 x 365
--- ---
1 100
= $1,825.00 = $18.25
Ann. Sales Ann. Sales
$10.00 x 365 $10.00 x 365
--- ---
1 100
= $3,650.00 = $36.50
E = Suppress Printing of Price and Value. Do not print cost, cost value, retail, and retail value.
H = Create Business Advisor Data. Create a file with Inventory information that Is used by the Business Advisor application. Run the report using Print Seq 1, Subtotals Y, Store blank (multistore users only), and Options T.
Note: Never run RIV with option H more than once during the same day for the same items.
I = Update Inventory Value. Use this option to generate a "snapshot" of the total dollar value of the inventory in a particular department, class, or fineline. This value is placed in the "Inventory Value" column of Department Maintenance (MDE), Class Maintenance (MCL), or Fineline Maintenance (MFI). To update MDE, run RIV using this option and Print Sequence 1. To update MCL, run RIV using this option, Print Sequence 1, and subtotals Y. To update MFI, run RIV using this option and Print Sequence 5.
K = Include kit records (items with Y in the Kit Record field in Inventory Maintenance, the Codes tab). Normally kit records are excluded from this report.
M = Multistore (C)onsolidated Spacing (multistore only). This can only be used with consolidated store printing (Store = C). Use this option to print a blank line between SKUs.
U = Include Negative Quantity on Hand. If an item has a negative quantity on hand, use it when calculating the retail value and cost value for that item. If you don't use Option U, the retail value and cost value for an item with a negative quantity on hand is considered to be $0.