| # 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 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. Select one of the following: Item Item/Warehouse Item/Warehouse Valuation Group Options Options 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. Print Item Details If this check box is selected, detailed item information is printed. 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 Error Report If this check box is selected, LN prints an error report. 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. 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. |