Running 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. Run it once, 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. Run it a second time, 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 monitorsmoving 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

Note:If you run this report frequently, you can save your selections and associate those settings with your user ID. Use the File > Save Settings option to use this feature. When you run the report again, the system displays the selections you made the last time. 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 excludes dynamic kit quantities when the items are picked at the component locations. The system calculates the kits when picked as a kit.

The Inventory Valuation Report requires that you select a column layout before completing the other fields. If the FIFO-COST column is included in the layout, the prompts for completing the report change. For more information about defining column layouts, see Modifying Column Layouts for Reports.

Select the product information for which you want to run the report on the Product Selection tab.

Field / Area	Description
Branch	Enter the branch for which you want to run the report. Type ALL to run the report for all branches. 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, however, you can enter multiple branches separated by commas to run it for more than one branch, such as 1,2,3.
As of Date	Enter the date by which you want to run the report. By default the system populates this field with the current date. Note: If this field is set to the current date, the Show $0 Average Costs check box is selected and there is no pricing information in the product file, then the system displays a $0.00 cost on the report and uses any current average cost data available. If this field is set to a date in the past, the Show $0 Average Costs check box is selected, and there is no pricing information found in the product file, then average cost information does not apply and the system uses $0.00.
Select by	Select one of the following: Price Line, Buy Line, Buy Group, Sell Group, Product or Product Lifecycle. Note: Any tildes (~) in product descriptions are removed from the description in the report output so your report sorts properly.
Select by	The selection field activates after you populate the Select By field, enter a specific entity. Use the Multi button to choose more than one selection for the report, such as two buy lines, or three price lines. Leave the field blank to include all values. For example, if you selected Price Line in the Select By field, leave this field blank to include all price lines in the report. Note: If you select Buy Line or Sell Group, the system does not respect multiple groups, but only checks the first group in the multiple list.
Cost As of Date	Enter the beginning date to reference for the valuation. Enter a calendar date or a system variable date. The system populates this field by default with the current date.
Cost As of Date	Use the File > Report Column Selection to add any additional cost basis fields, such as DFLT-COST or COMM-COSTS. By default, the system adds COGS-COST and Ext COGS-COST.
Quantity Types (Blank = All)	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, use the Multi button.
Inventory Accounts to Include	Select the inventory accounts for products to display. The default account is the primary inventory account. Use the Multi button to select multiple accounts.
Nonstocks	Indicate whether to include non-stock products on the selected lines.
Negative Onhands	Indicate whether to run the inventory valuation report for only items with a negative on-hand quantity.
Zero Onhands	Indicate whether to include or exclude from the report all items whose on-hand quantities are zero. If you are running the report for customer or vendor consignments, select to include products whose on-hand quantities are zero to get an accurate view of consignment inventory. When you select to exclude products, the system is checking only regular stock that is on hand. Items that have no regular stock on hand, but have customer consignment stock are only included in the report when select Include in this field.

Choose the display settings you want to use for running the report on the Display Settings tab.

Field	Description
Report Type	Indicate whether to run the report in summary or detail format. Detail - Lists information on a line item basis with a summary followed by a break at the end of each line or group. Detail by Branch -Lists information on a line item basis followed by a break at the end of each line or group, but groups together information by branch. Summary - Lists information by individual price line with a break after each line or group. Summary by Branch - Total value of inventory by branch. If you select more than one cost basis column the system displays each total by branch in its own column. Use the File > Report Column Selection to add any cost basis fields, such as DFLT-COST or COMM-COSTS. The default in COGS-COST. Summary by Branch (No Totals) - Total value of inventory by branch. If you select more than one cost basis column the system displays each total by branch in its own column, but does not display grand totals for each branch. Use the File > Report Column Selection to add any cost basis fields, such as DFLT-COST or COMM-COSTS. The default in COGS-COST. 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 and groups the results by branch.
Only Detail Extended Values Over	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. Normally, use this field when the Report Type field is set to Detail.
Sort by	Indicate how to sort the report. This selection determines the column that displays after the Product Description column. Note: Select 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.
Group by Ranks	Select whether you want to group the items by Product Ranks on the report. Note: If you select this check box, the Ranking Branch and Subtotal on Sort By fields activate for you to select data to display on the report.
Subtotal on Sort By	Select whether you want to sort data by subtotal. Note: This field activates only if you select the Group by Ranks check box.
Show $0 Average Costs	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: Cost As of Date is Today, and this check box is not selected- The system looks at the historical data as of today, and returns the current average cost if found. If the returned cost is $0, then the system checks the current average cost and returns that. If that is also $0, the system returns the Default Cost. Default Cost uses the Basis set up in Price Line Maintenance for global DFLT-COST. . Cost As of Date is Today, and this check box is selected – The system looks at the historical data as of today, and returns the current average cost if found. If the returned cost is $0, then the system checks the current average cost and returns that. If that is also $0, the system returns the Default Cost. Default Cost uses the Basis set up in Price Line Maintenance for global DFLT-COST. .- The system looks at the historical data as of today, and returns the current average cost. If the returned cost is $0, then the system checks the current average cost and returns that. If that cost is also $0, the system uses $0.00. Cost As of Date is in the past, and this check box is not selected – The system looks at the historical data as of today, and returns the current average cost if found. If the returned cost is $0, then the system checks the current average cost and returns that. If that is also $0, the system returns the Default Cost. Default Cost uses the Basis set up in Price Line Maintenance for global DFLT-COST. .- The system looks at the historical data using the Cost As of Date. If the cost is $0, the system returns the current average cost if it can determine it, if not it returns the Default Cost. Default Cost uses the Basis set up in Price Line Maintenance for global DFLT-COST. Cost As of Date is in the past, and this check box is selected – The system looks at the historical data as of today, and returns the current average cost if found. If the returned cost is $0, then the system checks the current average cost and returns that. If that is also $0, the system returns the Default Cost. Default Cost uses the Basis set up in Price Line Maintenance for global DFLT-COST. .- The system looks at the historical data using the Cost As of Date. If the cost is $0, the system returns $0. 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 theShow $0 Average Costcheck box is selected and there is no pricing information as of the date requested, the system uses the current cost.
Use P/O Cost for Tagged Items	Select to have tagged inventory valued using the associated purchase order costs. If the tag is broken, then the system determines the tagged inventory value using the associated cost with the cost-basis entered. This option is not activated with FIFO-COST. If you leave this deselected, 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.

Indicate any further additional selection criteria you want to use for running the report on the Additional Selection tab.

Field	Description
Vendor Consignment	Indicate whether to include vendor consignment items on the report: Include - Lists products on consignment from vendors. Exclude - Does not list products on consignment from vendors. This is the default. Only - Lists only products on consignment from vendors. Selecting this option also activates the following options: Page Break - Indicate if you want the system to split the report using page breaks for vendor consignment products. We recommend this setting to sort by vendor before sorting by the selected option. Show Price - Indicate if you want to display prices on the report. Consignment Vendor - Enter the vendor name if running the report for a particular kind of consignment.
Customer Consignment	Indicate whether to include customer consignment items on the report. The default is Exclude. If you select Only, the system activates the Consignment Customer field to select the customer name if running the report for a particular kind of consignment. We recommend setting the Page Break field to sort by customer before sorting by the selected option.
Direct Through Stock	Indicate whether to include Direct Through Stock (customer-owned inventory) items on the report. If you select Include or Only, the system activates the Customer field in which you can specify a specific customer. You can also page break by DTS inventory. For more information about DTS orders, see Direct Through Stock Order Overviewin the Sales Management documentation.
Number of Years to Go Back On FIFO	If you select FIFO-COST as a cost basis and add the column to the report, complete the Additional FIFO-COST Selection Criteria area. If you select to add FIFO-COST as a column, the report can take longer to run. Number of Years to Go Back On FIFO-COST - Enter the number of years you want to use when displaying FIFO-COST on the report. Include Adjustments - Indicate if you want to display adjustment information on the report. To include additional information regarding FIFO costs on the report, also add the FIFO P/O Cost and FIFO P/O Cost Ext columns to the report using the File > Report Column Selection option.

Use the Rank Selection> Product Rank Select option to select product ranks by which to sort the items on the report.

From the File menu, select Report Column Selection to include or exclude additional columns of information from the report, such as Branch Cost Center for the branches included in the report.

Set options, if needed, and generate the report.