Introduction: Inventory Valuation Report (03-63)

Overview

This selection is used to view the total dollar value of onhand inventory for the entire company, a specific region, or a specific store.

You can view inventory for regular stock items, floor/damaged models, special order items, trade in items, out on loan items, service parts, and/or negative on hand items. A company summary for all items is also included.

For more information, please see the ‘Reconciling Inventory to G/L‘ section of the Tyler documentation.

Special Notes

• The value of inventory is calculated by multiplying the amount in the ‘Vendor Cost’ field (Field 13) of Inventory Master File Inq/Maint (03-01) by the current quantity on hand of the item. Represented as a formula:

  Inventory Value = (Vendor Cost) x (Quantity Hand)

  • If preference #2 or #4 is selected on the third screen of Purchase Order Preferences (04-90), Vendor cost is calculated using the weighted average method.
  • The vendor cost calculation might also include other variables such as discounts, rebates, freight, etc. that are flagged on the second screen of PO Preferences. If freight is included in the cost, it is calculated using the ‘Freight Percent’ field from A/P Vendor Master (11-30) or the ‘Freight’ field (Field 23) of Inventory Master File Inq/Maint (03-01).
• This report can be viewed on the screen, printed to a laser printer, opened in Excel, or saved to a PDF file. You cannot print it to a spooler.
• You can sort a report column by clicking on the column heading.
• You can move a report column by clicking on the column heading and dragging it to the desired location.