| # Perform Inventory Valuation (whina1210m000) Use this session to perform an inventory valuation for a range of items. You can perform the inventory valuation by: Item type Item valuation group Warehouse valuation group Warehouse Note The value of the inventory will always be determined according to its current inventory-valuation method. In addition, you can choose to compare the inventory value with the fixed transfer price, moving-average unit cost, market price, or average purchase price. Related topics Inventory valuation Lower cost or market value Selection Range Settings Inventory Valuation Date The date and time at which the value of the inventory must be determined. Currency The currency in which the inventory value is expressed on the report. From the Tools menu, choose Rotate Currency to switch home currencies. Note You can only rotate currencies if you use the independent currency system. Related topics Currency systems Exchange Rate Type The exchange-rate type that is used to "convert" the local currency of the warehouse into the currency that is used for the report. Related topics To use currency exchange rate types Difference Compare Inventory Value With Compare Inventory Value With If this check box is selected, you can choose one of the following options. Select one of the following: MAUC FTP Market Price (including surcharges) Market Price (excluding surcharges) Average Purchase Price (incl surcharges) Average Purchase Price (excl surcharges) Print Difference only if Inventory Value exceeds Compared Value If this check box is selected, the difference between the inventory value and the compared value will be printed if the latter value is greater than the inventory value. Example
Inventory Value | Value based on FTP | Difference printed if this check box is...
...selected | ...cleared
1000 | 1200 | N/A | - 200
Price Used if Purchase Receipts exist after last Market Price Date Price Used if Purchase Receipts exist after last Market Price Date The price that must be used if the last invoice is not yet approved. Market Price Level Market Price Level The level that defines the lowest approved purchase price or last order price. Inventory Include Inventory on Hand If this check box is selected, inventory on hand is also taken into account. The lines with on-hand quantities will be printed with separate columns for amounts per ownership and for the inventory WIP amount. To perform a valuation of inventory in transit only, leave this check box cleared. Include Inventory in Transit To Warehouse (without invoice relation) If this check box is selected, inventory for which no invoices exist and that is currently being shipped to a warehouse, is also taken into account. To Warehouse (with invoice relation, not invoiced) If this check box is selected, inventory is taken into account: For which invoices exist Which is currently being shipped to a warehouse For which the internal invoice is not yet posted To Warehouse (with invoice relation, invoiced, not received) If this check box is selected, inventory is taken into account: For which invoices exist Which is currently being shipped to a warehouse Which is not yet received To Project If this check box is selected, and the Project WIP posting is not done yet, inventory that has been allocated to a project and that is currently being shipped, is also taken into account. Maintenance Sales Part Loan Lines If this check box is selected, inventory that is currently being shipped and that is not yet received from the customer, and for which maintenance sales order lines of type Part Loan exist, is also taken into account. Sales Order Lines (not approved) If this check box is selected, inventory for which unapproved sales order lines exist and that is currently being shipped, is also taken into account. Sales Order Lines (rejected; not received) If this check box is selected, inventory for which rejected or not-received sales order lines exist and that is currently being shipped, is also taken into account. Include Inventory Ownership Company Owned If this check box is selected, the value of company-owned inventory is printed in a separate column. If this check box is cleared, the related column remains empty and company-owned inventory is not included in the totals. Consigned If this check box is selected, the value of consigned inventory is printed in a separate column. If this check box is cleared, the related column remains empty and consigned inventory is not included in the totals. Customer Owned If this check box is selected, the value of customer-owned inventory is printed in a separate column. If this check box is cleared, the related column remains empty and customer-owned inventory is not included in the totals. Include Value Inventory If this check box is selected, the value of company-owned inventory, consigned and customer owned inventory is determined. By default, this check box is selected. To print inventory WIP only, clear this check box. Inventory WIP If this check box is selected, the value of company-owned inventory is determined for the Inventory WIP column. Options Options Print Error Report If this check box is selected, LN prints an error report. Include Antedated Transactions If this check box is selected, transactions with transaction dates before the actual log dates are taken into account. Include Service Reject Warehouses If this check box is selected, the inventory valuation is also performed for service reject warehouses. Include Financial Warehouses If this check box is selected, the inventory valuation is also performed for financial warehouses. Related topics Using warehouses Print Item Details If this check box is selected, detailed item information is printed. Print Owner Details If this check box is selected, consigned and customer-owned inventory is printed on separate lines for the owner. Print Buy-from BP Details If this check box is selected, consigned and customer-owned inventory is printed on separate lines for the buy-from business partner. Suppress Zero Inventory If this check box is selected, zero inventories are not taken into account. Print Warehouse Details If this check box is selected, detailed warehouse information is printed. Print Cost Details If this check box is selected, the cost components with the accompanying amounts are also printed. Suppress Zero Amounts (and Related Cost Components) If this check box is selected, the cost components with zero amounts are not printed. Note You can only select this check box if the Print Cost Details check box is selected. Print Inventory Details If this check box is selected, the inventory value is printed on separate lines for on-hand inventory and for the various lines of in-transit inventory. If this check box is cleared, only headers and total lines are printed, which means that the inventory on hand and the inventory in transit are aggregated. |