Show TOC

Object documentationInventory Revaluation Window Locate this document in the navigation structure

 

Use this window to define which items you want to revaluate and how. To access the window, choose   Inventory   Inventory Transactions   Inventory Revaluation  .

Inventory Revaluation Fields – General Area
Series

Select the required numbering series for the document.

Revaluation Type

Select the required revaluation type from the list:

  • Price Change – select to change the cost of the item and calculate the value of the whole inventory according to the new price.

  • Inventory Debit/Credit – select to revaluate by changing the inventory value, which will cause the item cost to change accordingly.

Ref. 2

Enter a reference for the journal entry, if required

Journal Remarks

Displays by default Inventory Revaluation. This text is copied to the journal entry.

Country-Specific Fields: India
Seq .Name

Specify a sequence from the drop-down list. The system generates the sequence automatically.

Note Note

This field appears only for documents that are assigned a sequence.

End of the note.
Country-Specific Fields: Chile
Inflation-Based Revaluation

Use this checkbox as follows:

Note Note

To...

Do this...

Create a revaluation document, recording inflation as the reason for the revaluation.

You can then filter out inflation-based revaluations in the inventory valuation simulation report. It is a requirement of IFRS not to include inflation-based revaluations in inventory valuation.

In the menu bar, choose   Data   Add  , select this checkbox, and choose the Add button.

Create a revaluation document for reasons other than inflation

In the menu bar, choose   Data   Add  , leave this checkbox unselected, and choose the Add button.

Find only inflation-based revaluation documents

In the menu bar, choose   Data   Find  , select this checkbox, and choose the Find button.

Find only revaluation documents that are not inflation-based

In the menu bar, choose   Data   Find  , select and then unselect this checkbox, and choose the Find button.

Find all revaluation documents

In the menu bar, choose   Data   Find  , leave this checkbox unselected, and choose the Find button.

End of the note.

Following an upgrade, the checkbox is unselected in all revaluation documents and you must select the checkbox in any inflation-based revaluation documents, either manually or using a purpose-built partner add-on.

Inventory Revaluation Fields – Table Area
Current Cost

Displays the current cost of the FIFO inventory item from one particular layer.

This field appears only if the selected revaluation type is Price Change.

New Cost

Enter the new cost you wish to assign to the item.

Appears only when the selected revaluation type is Price Change.

For FIFO inventory items the field is blank.

Debit/Credit

Enter the amount you wish to credit or debit from the current inventory value of the item. Enter credit as a negative value.

Appears only if the selected revaluation type is Inventory Credit/Debit.

In Stock

The total quantity in stock.

Issued Layers

Select to display all layers (including empty layers) for the item in the FIFO Layers table.

The column is disabled for Moving Average and Standard inventory items.

G/L Increase Acct, G/L Decrease Acct

Define the G/L accounts to be used as the balancing account in the transaction created by the revaluation. The G/L Increase Account is used when the inventory value is increased due to the revaluation. The G/L Decrease Account is used when the inventory value is decreased. The accounts appear as default in these fields and are taken from the item master data, item group or warehouse level.

Val. Method

Displays the valuation method. If the method is FIFO, additional information is displayed in the FIFO Layers table.

Distr. Rule

Enter the distribution rule to define the way that the revenue resulting from the revaluation is allocated.

Project

If required, specify the project to which the changed inventory value of the item is allocated.

Inventory Revaluation Fields – FIFO Layers
Current Cost

Displays the current cost of the FIFO inventory item from one particular layer.

This field appears only if the selected revaluation type is Price Change.

New Price

Price of the layer.

This field appears only if the selected valuation type is Price Change.

Open Qty

Available quantity for the layer.

Quantity

Quantity of inventory item's layer subject to debit/credit.

Debit/Credit

Enter the amount you wish to credit or debit from the current inventory value of the item's layer. Enter credit as a negative value.

This field appears only if the selected valuation type is Debit/Credit.

More Information

Inventory Revaluation