Perform Inventory Valuation (whina1210m000)
Use this session to perform an inventory valuation for a range of items.
- The value of the inventory is determined by its current inventory-valuation method.
- You can compare the inventory value with the fixed transfer price, moving-average unit cost, market value, or average purchase price.
Field Information
- 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.
- 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.
- 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
- Current Date
-
The date for which the valuation is calculated and/or actualized is the current date.
- Last Date of Previous Period
-
The date for which the valuation is calculated and actualized is the last date of the previous financial period of the financial company linked to the warehouse for which the valuation is performed.
The warehouse for which the valuation is performed and the linked financial company can be located in different time zones. Select this option to ensure that the inventory transactions included in the valuation fall within the previous financial period of the financial company.
For example, an inventory transaction created at 8/31/2014 11:45 PM falls in financial period August if the warehouse where the transaction is performed and the financial company are located in the same time zone. If the financial company is located in a time zone where the time is one hour ahead, the inventory transaction is posted in financial period September.
- Specific Date
-
The date for which the valuation is calculated and actualized is a date in the past, which you can enter in the Specific Date field.
- 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
- MAUC (by Warehouse)
-
moving-average unit cost (MAUC)
- Standard Cost
- Market Value (including surcharges)
- Market Value (excluding surcharges)
- Average Purchase Price (incl surcharges)
- Average Purchase Price (excl surcharges)
- Current Inventory Value
- 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 Value Date
-
- Price Used if Purchase Receipts exist after last Market Value Date
-
The price that must be used if the last invoice is not yet approved.
- Market Value Level
-
- Market Value Level
-
The level that defines the lowest approved purchase price or last order price.
- 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.
- Print Enterprise Unit Details
-
If this check box is selected, detailed enterprise unit information is printed, including total inventory values per enterprise unit.
Note:If standard costs are determined per enterprise unit, both the Print Item Details check box and the Print Enterprise Unit Details check box must be selected to print cost details. This is because items present in different enterprise units can have different cost component structures per enterprise unit.
Standard costs are determined by enterprise unit if:
- On the Enterprise Structures tab of the Implemented Software Components (tccom0100s000) session, the Standard Cost by Enterprise Unit field is set to Active. See Overview of the multisite concepts.
- In the Items (tcibd0501m000) session, the Standard Costs at Level field is set to Enterprise Unit, except for archive companies.
- Print Item Details
-
If this check box is selected, detailed item information is printed.
Note:If standard costs are determined per enterprise unit, both the Print Item Details check box and the Print Enterprise Unit Details check box must be selected to print cost details. This is because items present in different enterprise units can have different cost component structures per enterprise unit.
Standard costs are determined by enterprise unit if:
- On the Enterprise Structures tab of the Implemented Software Components (tccom0100s000) session, the Standard Cost by Enterprise Unit field is set to Active. See Overview of the multisite concepts.
- In the Items (tcibd0501m000) session, the Standard Costs at Level field is set to Enterprise Unit, except for archive companies.
- 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 check box is selected in the Implemented Software Components (tccom0100s000) session.
- Print Cost Details
-
If this check box is selected, the cost components with the accompanying amounts are also printed.
Note:If standard costs are determined per enterprise unit, both the Print Item Details check box and the Print Enterprise Unit Details check box must be selected to print cost details. This is because items present in different enterprise units can have different cost component structures per enterprise unit.
Standard costs are determined by enterprise unit if:
- On the Enterprise Structures tab of the Implemented Software Components (tccom0100s000) session, the Standard Cost by Enterprise Unit field is set to Active. See Overview of the multisite concepts.
- In the Items (tcibd0501m000) session, the Standard Costs at Level field is set to Enterprise Unit, except for archive companies.
- Suppress Zero Amounts and Hours (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.
-
- Include Inventory in Transit
-
- Without Intercompany Trade
-
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
- With Intercompany Trade; COS not posted
-
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
- With Intercompany Trade; COS posted
-
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.