To run the Inventory Valuation Report:Use the Inventory Valuation Report to generate a report, either summary or detailed, that displays the value of the products in a price line, a series of price lines, or all price lines within one or more branches.
For auditing purposes, run the Inventory Valuation Report twice. First, to include those items with a negative on-hand quantity and allow for immediate correction. A negative on-hand quantity typically occurs because users are allowed to over-commit stock. It may be a case where product A was substituted for product B and product A has been driven into a negative quantity level. Second, to include all items by excluding those items with an on-hand quantity of zero, or to include only those items whose extended on-hand value exceeds a certain amount.
This report also looks at the REP-COST when the AVG-COST of an item is $0.00. In addition, it historically monitors moving average cost. You can indicate if you want to display items with a zero dollar average cost for moving average cost to display as $0.00. Products with a status of LotItem are not included in the report.
Note: After you run the report once, the system saves the selections you made and associates them with your user ID. When you run this report again, the system displays the selections you made the last time. A "Saved Settings" message at the top of the screen indicates that your previous selections are being used. If there is no default or saved setting, the field is blank. For more information, see How the System Saves Settings on Reports.
If you use the dynamic kit functionality, this report will exclude dynamic kit quantities when the items are picked at the component locations. The system will calculate the kits when picked as a kit.
To run the Inventory Valuation Report:From the Purch > Reports menu, select Inventory Valuation, to display the Inventory Valuation criteria screen.
In the Br/Tr/All field, enter the branch or territory for which you want to run the report. Type ALL to run the report for all branches and territories.
Note: This report normally runs for a single branch. If run for more than one branch, we recommend running it in summary format only due to processing time.
In the As of Date field, enter the date by which you want to run the report. By default the system populates this field with the current date.
In the Select by field, press F10 and select one of the following. Use the Multi hot key to select more than one line, group, or product for the report.
Buy Line
Buy Group
Price Line
Sell Group
Product
Note: Selection in this field determines the title and purpose of the next field to display. For example, the line under the Select by field is blank. If you select Buy Line in the Select by field, the Buy Line field displays on the next line. This field lets you select for which buy line you want to run the report.
In the Cost Basis field, press F10 to select from a list of Global Basis names and system maintained cost. This field is user-defined.
If you select FIFO-COST, a hot key activates that lets you select the number of years history to use when retrieving the report data.
In the Cost As of Date field, enter the beginning date to reference for the valuation. Enter a calendar date or a system variable date. Press F10 to display a calendar from which to select a date.
Note: If you use a branch cost basis as your Cost of Good Sold (COGS), then the system returns the COGS value in this field. The system returns what is in the branch cost fields because the information is not stored in dated buckets. If cost information is stored in the Basis field in Product File Maintenance, the system uses that value.
In the Detail/Summary field, indicate whether to run the report in summary or detail format. Press F10 to select one of the following:
Detail – Lists information on a line item basis with a summary followed by a break at the end of each line or group. Consignment purchase orders do not display in detail mode.
Summary – Lists information by individual price line with a break after each line or group.
Summary by Product – Lists the total on-hand quantity for each type: Stock, Tag, Review, Defective, Over Shipment, and Display and the extended value for each product on the report.
In the Display PN (Y/N) field, indicate whether you want to display each product ID on the report.
In the Sort by field, indicate how to sort the report. This selection determines the column that displays after the Product Description column. Press F10 and select from the following:
Price Line
Buy Line
Sell Group
Buy Group
Product GL Code – To sort by product types that are represented by the General Ledger Codes. This column always displays at the end of the report even if selected in this field.
In the Group by Product Ranks field, indicate whether you want to group the items by Product Ranks on the report. Type Y or N.
Use the Product Rank hot key to select product ranks by which to sort the items on the report.
In the Subtotal on Sort by field, indicate whether you want a subtotal displayed for each Sort by selection. Type Y or N.
In the Nonstocks (Inc/Exc/Only) field, indicate whether to include non-stock products on the selected lines. Press F10 and select one of the following:
Include – Prints non-stock products.
Exclude – Does not print non-stock products.
Only – Prints only non-stock products.
In the Only Detail for Extended Values field, enter the value to restrict the items on the report to those whose extended value is greater than the designated amount.
Note: This amount is typically a large number that would alert you to those items whose on-hand value is significant. This field is used when the Detail/Summary field is set to Detail.
In the Neg On-Hand Qtys (Inc/Exc/Only) field, indicate whether to include the inventory valuation report for only items with a negative on-hand quantity. Click here for typical use for this field.
In the Quantity Types (Null=All) field, indicate whether to run the report for one or more types of products. If left blank, the report includes all product types. To select more than one, separate each entry with a comma, such as S, F, O. Press F10 and select one of the following:
S = Stock
F = Defective
O = Over Shipment
R = Review
L = Display
T = Tagged
In the Zero On-Hand Qtys (Inc/Exc) field, indicate whether to include or exclude from the report all items whose on-hand quantities are zero. Press F10 and select one of the following:
Include – Prints products with zero on-hand quantities.
Exclude – Does not print products with zero on-hand quantities.
In the Show Serial Number field, indicate whether to include serial numbers for the on-hand quantities of a product. This field is used when the Detail/Summary field is set to Detail. For more information, see Serial Tracking.
In the Show $0 Average Cost field, indicate if you want to display items with a zero dollar average cost for moving average cost to display as $0.00.
This setting behaves differently based on the Cost As of Date:
When the Cost As of Date is in the past, the system relies on historical data only, and does not check current average cost.
Note: If the Show $0 Average Cost field is set to Yes and there is no pricing information as of the date requested, the system uses the current cost.
In the Use P/O Cost for Tagged Items field, enter one of the following:
Y – Tagged inventory is valued using the associated purchase order costs. If the tag is broken, then the system determines the tagged inventory value using associated with the cost-basis entered. This prompt is not activated with FIFO-COST.
N – The system uses the average cost associated with the item.
Note: If tagged items are listed on the report, the unit of measure and quantity for those items display.
In the Inventory Accounts to Include field, select the inventory accounts for products to display. The default account is the primary inventory account. Use the Multi hot key to select multiple accounts.
If running the report for consignments, use the Consignment hot key.
Press Esc to return to the main menu.
See Also: