Field Definitions: Inventory Valuation Report (03-63)

This tab is included on the report if the ‘Regular Stock’ box is checked.

Inventory items available for sale display on this tab.

This tab is included on the report if the ‘Floor/Damaged’ box is checked and the ‘Regular Stock’ box is unchecked. Inventory items with floor and/or damaged quantities display on this tab.

If the ‘Floor/Damaged’ box is checked and the ‘Regular Stock’ box is checked, the Floor/Damaged quantities display in their own columns on the ‘Stock’ and ‘SpecialOrder’ tabs.

This tab is included on the report if the ‘Special Order’ box is checked.

Special Order items are products that you normally do not stock, and are ordered for a customer on a one-time basis.

This tab is included on the report if the ‘Trade In’ box is checked.

Trade Ins are items that your company purchases from a customer. Most of the time these are used items, which you may or may not decide to resell. Please see the ‘Accepting a Trade In’ tutorial for more information.

This tab is included on the report if the ‘Out On Loan’ box is checked.

Items are loaned to a customer using Loaner Processing.

This tab is included on the report if the ‘Regular Stock’ box is checked.

It displays all items that are on shipped, but not updated orders in Order Processing (orders with a status of ‘2,’ ‘4,’ or ‘5’). For these items, quantity onhand has been reduced, but the customer has not received them.

NOTE: Loaners are not included on the ‘InShipping’ tab. Instead, they display on the ‘OutOnLoan’ tab (if selected for the report).

This tab is included on the report if the ‘Service Parts’ box is checked.

Installed Service parts display on this tab.

This tab is included on the report if the ‘Service Parts’ box is checked.

Onhand parts inventory, set up in Parts Inventory (07-45), display on this tab.

This tab is included on the report if the ‘Service Parts’ box is checked.

Unreturned cores that are not included in installed parts, display on this tab.

This tab is always included on the report and provides a summary of the inventory valuation.

It contains three totals:

• Inventory Value
• Transfer Value
• Installed Serv Value

‘Inventory Value’ is the sum of the totals on the tabs that were selected for the report.

For example, if you selected all tabs to be included on the report (Regular Stock, Floor/Damaged, Special Order, Trade In, Out on Loan, Service Parts, Neg on Hand Report), the totals on the following tabs are summed to calculate the Inventory Value:

• Stock
• SpecialOrder
• TradeIn
• OutOnLoan
• ServiceParts (Service Inventory Value)
• Cores

The following are not included in the Inventory Value:

• Installed Part Value (ServiceParts tab)
• Installed Item Value (Installed tab)
• Installed Service Value (Summary tab)

‘Transfer Value’ is the dollar value of transfers that have been shipped from the Outbound Branch or Received at the Inbound Branch.

• Shipping Confirmation (03-11-11) adds to the Transfer Value amount and reduces the Inventory Value amount.
• Receiving Confirmation (03-11-13) reduces the Transfer Value amount and adds to the Inventory Value amount.
• To get the Total Inventory Value, you must add the Transfer Value amount to the Inventory Value amount.

‘Installed Serv Value’ is the sum of the totals on the following tabs:

• Installed (Installed Item Value)
• ServiceParts (Installed Part Value)