Show TOC

Object documentationInventory Revaluation Window

 

Use this window to define which items you want to revaluate and how. To access the window, choose Start of the navigation path Inventory Next navigation step Inventory Transactions Next navigation step Inventory Revaluation End of the navigation path.

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.

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

Displays the total quantity of items in the batch.

Note Note

The column displays the total quantity of items in the batch in each bin location if the following conditions exist:

  • You have enabled bin locations for the warehouse in the Rows from Documents table.

  • The item is issued primarily by bin locations.

End of the note.
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