OVERVIEW
Inventory revaluation is the process of adjusting inventory costs to account for changes in recorded costs. Exchange rate fluctuations, supply chain disruptions, damage, or spoilage may be the cause of these modifications. Revaluing inventory involves comparing the item's recorded value to its market worth. Businesses can make sure that their financial accounts appropriately reflect the worth of their inventory by revaluing their stock, which is essential for making wise business decisions.
1.1 WHY WE NEED INVENTORY REVALUATION
Revaluation is necessary to ensure that the recorded inventory value on the balance sheet reflects its true value. There are various circumstances when Inventory revaluation is necessary are mentioned below:
Obsolescence: If the inventory has become obsolete or its demand has decreased, then the value of inventory should be revalued to reflect the reduced value.
Market changes: if there are changes in the market related to demand or supply then it will affect the value of inventory. So that the value of inventory should be revalued to reflect the current market value.
Inaccurate book value: If in the accounting books inventory has been recorded at an inaccurate value due to accounting errors then a revaluation is necessary to correct the error.
Damage or spoilage: if the inventory has been damaged or spoiled then the value of inventory should be revalued to reflect the reduced value.
Regularly scheduled revaluation: Most of the companies do the inventory revaluations on a regular basis such as annually or quarterly so that it must be necessary to record the value of inventory is accurate.
When inventory revaluation is done business can ensure that their financial statements accurately reflect the value of their inventory, which is very important for making informed business decisions.
2.INVENTORY REVALUATION
Navigate to Menu ->Financial Management -> Posting Set up -> Inventory Revaluation or search for Inventory Revaluation in search utility available in Menu itself.
2.1 INVENTORY REVALUATION HEADER
When the Inventory revaluation screen is opened, the system shows the Inventory revaluation screen as given in the below screenshot:
Tenant and Organization are auto-populated based on user login.
The Document number will be auto-generated by the system based on the Document type selection.
Enter the Document Date, on which the transaction of revaluation is processing.
Account Date would be auto-populated based on the document date, but user can change it according to the impact of account consequences.
Document Date and Account Date should be same and it should be equal to the system date, when Revaluation Type= On Available Quantity. Otherwise, system will not allow to save the record and throw an error message.
User needs to select Revaluation Type among two values, either ‘On Available Quantity’ or ‘On Sold/Consumed Quantity’.
‘On Available Quantity’ is used to do the revaluation of the cost of the product as per the current quantity of the product.
‘On Sold/Consumed Quantity’ is used to do the revaluation of the cost of the product as per the sales and inventory use transactions.
If Revaluation Type=On Sold/Consumed Quantity, then system will display Revaluation Period field. This field will display period of previous month to revaluate the cost of the product. Also, Costing methods related to Purchase order will not be visible in Case of Sold/Consumed quantity Revaluation type. Such as, Average PO, Last PO and Weighted Average PO.
User has to select the Accounting Schema from the dropdown, which defines the rules used in accounting such as costing method, currency and calendar. All the active accounting schemas will be visible in the dropdown as per the selected organization.
Needs to select the Currency Rate Type, which helps to convert the price to other currency if there are multiple accounting schemas during posting of the transaction. For e.g. Spot, Average, Company & Period End etc.
User has to select the Costing Level and Costing Method, which helps to filter the product categories to revaluate the cost of the assigned products.
User has the option to select the value in Product Category and Product field, to revaluate the cost for particular category or product.
Warehouse is mandatory to select, so that system will generate the Revaluation lines for the product category and products to the respective warehouse and locator.
Cost Type field will display, when Costing Method=Standard Costing. User has to select the particular cost type value against which the cost of the product available on costing info screen.
Generate Revaluation Lines button helps to generate Revaluation lines only, after inserting values in all the required fields. Field value combinations should be correct to generate the lines.
Total Difference will get updated from revaluation lines only in case of "On Available quantity" Revaluation type.
Document Status is a system maintained field and will be updated by the system automatically based on some events done by the users on the Inventory Revaluation record.
2.2 REVALUATION LINE
The user would be able to generate the Inventory Revaluation lines by click on Generate Revaluation Lines. All lines would be generated according to the selecting values in the fields on the header, such as Costing Level, Costing Method, Product Category, Product and Warehouse.
2.2.1 REVALUATION TYPE – ON AVAILABLE QUANTITY
User can perform Revaluation in case of all costing methods and all costing levels. Once the header fields are filled correctly, System will generate Revaluation lines with respect to the products as per filled values. It must be ensured that user cannot enter or edit any details on the line except Revaluated Cost, because all other fields would show in read only mode. Revaluation Line would show in the system as given in the below screenshot:
All Fields such as product, product category, Costing method, Costing level, UOM and Attribute set instance will be auto filled on the basis of selected values in the fields on the header tab by clicking on Generate Revaluations Lines.
On hand Quantity of the Product in the selected warehouse would get updated in Available Stock field.
Current Cost Price indicates the current cost of the product available on costing info. Current cost will be calculated on the basis of average of all the lines on Cost queue tab of costing info with the same warehouse as selected on Revaluation screen header.
User has to enter new cost for the product in Revaluated cost field, which will help to do the calculations for the fields as per defined formulas.
Revaluated Total cost will be updated by multiplying Available stock with Revaluated cost.
Difference between Revaluated cost and Current Cost Price will appear in Per unit Difference field. (Revaluated cost – Current cost price)
By multiplying Available Stock Qty and Per unit Difference, system will calculate Total Difference value.
For Example, Enter the 112 in Revaluated cost field, then the Per unit Difference & Total Difference will be updated by the system in the below screenshot:
On the header, total difference will also be updated from the revaluation line which would come in Total Difference field as given below screenshot:
If there are multiple revaluation lines, then system will add all the total difference values of each line and show its total on the header as per the above screenshot.
After completing the Document, system will update the current cost on cost queue tab of costing info screen . The cost will be changed only in the Selected warehouse line as selected on Header of Revaluation screen .
System will also update the M_Transaction ID on the Product transaction tab after completing the Revaluation document.
2.2.2 REVALUATION TYPE – ON SOLD/CONSUMED QUANTITY
All Fields such as product, product category, costing method, costing level, UOM and Attribute set instance will be auto filled on the basis of selected values on the header tab by clicking on Generate Revaluations Lines. Also, user has to fill another field ‘Revaluation Period’, which is used to define the period for revaluation as shown in given below screenshot.
In case of Sold/Consumed, period field always show previous month from current date of the server.
All Fields such as product, product category, costing method, costing level, UOM and Attribute set instance will be auto filled on the basis of selection parameters on the header tab by clicking on Generate Revaluations Lines.
Quantity of the Product, which is Sold or Consumed in the selected period would get updated on Revaluation line tab. The lines on the revaluation line will be created according on how many times the product is consumed. Consumption qty is calculated with sum of Internal use qty, sale qty and production qty.
Difference Per Unit Cost would pick the value by multiplying Value in 'Price Difference (AP-PO)' field with 'Consumed Quantity' on Matched Invoice screen and result would get divided with 'Total Consumed/Sold Quantity' on Revaluation line for respective product as explained below:
For example: Difference Per Unit Cost is calculated as below: Price Difference (AP-PO) * Consumed qty on Matched Invoice / Total Consumed/Sold Quantity of product on Revaluation line tab.
In case below:
PO price is 100 and AP price is 110.
Price Difference (AP-PO) is 10.
Total Consumed Qty is 20 as per Matched Invoice.
Total Consumed/Sold qty as per revaluation line tab is 50.
10 * 20 / 50 = 4
Transaction Details section shows all the consumed Transactions such as Internal use, Sales, Production related to the product with their M_Transaction ID.
Consumed/Sold qty shows the qty that is consumed for the particular Transaction.
Difference per unit cost is updated on the basis of calculation explained in point 5.
Consumed/Sold value is calculated after multiplying Consumed/Sold qty with Consumed/Sold cost. (I.e. 20 * 100 = 200) as per above screenshot.
After adding consumed/Sold cost with the difference cost, new sold cost will be calculated and Value after revaluation is calculated on basis of new sold cost.
(I.e. (100 + 4) = 104 * 20 = 2080 as per the above screenshot.
Cost after Revaluation is the new sold cost.
Move to the Inventory Revaluation record and click on the Complete button and the system will open the pop-up as shown below in the print shot:
Click on the “OK” button to execute the workflow that will Job(process) the Inventory Revaluation document.
No M-Transaction ID will be updated in case of sold/consumed qty Revaluation type.
The user can’t make any changes in the Inventory Revaluation record once processed.