| # 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 is determined by its current inventory-valuation method. 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 Using currency exchange rate types Flat File Format Select this check box to print the report in a format that can be easily loaded in a spreadsheet application. If this check box is selected, LN prints one line with header data for the columns, and other lines that include inventory quantity, inventory amount, and an indicator of the type of inventory. Separator in Flat File The character used to separate the columns in the flat file. This separator is required for loading the flat file in a spreadsheet application. Default value "|" (vertical bar) Effective Date The date and time at which the value of the inventory must be determined. Allowed values Effective Date Difference Compare Inventory Value With Compare Inventory Value With If this check box is selected, you can choose one of the following options: Allowed values Inventory Valuation Basis 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 Standard Cost | 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 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. 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, items with mixed ownership are included in the inventory valuation. Items with mixed ownership are manufactured from both company owned and customer owned materials. Logistically, such items are registered as customer owned. Financially, the company owned part of these items is represented as inventory WIP. 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. 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. Print Lot Details (Lot Pricing) If this check box is selected, detailed lot information is printed. Print Serial Details (Serial Pricing) If this check box is selected, detailed serial information is printed. Print Inventory Details If this check box is selected, detailed inventory 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 Project Peg Details If this check box is selected, detailed project peg information is printed. This option is available if the Project Pegging is selected in the Implemented Software Components (tccom0100s000) is selected. 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. Regular 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. Quarantine (not finished products or not payable inventory) If this check box is selected, items in quarantine are printed and displayed separately on the report. These items are not processed in quarantine. Quarantine inventory is excluded from inventory valuations. The quarantined items are rejected and sent to quarantine during production or inbound or outbound inspection. Production Manufactured items. Typically, these are unfinished end items. Inspection Purchased items. The Payable to Supplier check box in the Inventory Handling Parameters (whinh0100m000) session is selected. Quarantine inventory represents a lower inventory value than inventory outside quarantine. Therefore, to avoid the impact of quarantined items on the inventory value, these items are excluded from inventory valuations such as MAUC, FIFO, or LIFO. Related topics Quarantine inventory Quarantine inventory payable to supplier Include Inventory in Transit To Warehouse (without invoice relation) If this check box is selected, inventory meeting specific conditions is taken into account. Inventory is taken into account: For which no invoices exist Which is currently being shipped to a warehouse Which is not yet received To Warehouse (with invoice relation; not invoiced) If this check box is selected, inventory meeting specific conditions is taken into account. Inventory is taken into account: For which invoices exist Which is currently being shipped to a warehouse Which is not yet received For which the internal invoice is not yet posted To Warehouse (with invoice relation; invoiced) If this check box is selected, inventory meeting specific conditions is taken into account. Inventory is taken into account: For which invoices exist Which is currently being shipped to a warehouse For which the internal invoice is already posted 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 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. |