Solved

Inventory Revaluation - Weighted Average

  • 30 January 2023
  • 6 replies
  • 381 views
S
Rank
Userlevel 3
Badge +5
  • Sandy
  • Do Gooder (Partner)
  • 10 replies

How is it possible to revalue the weighted Average costed part?

Imagine a scenario where the inventory part is set up at Weighted average and made several receipts. The part has been in inventory for several years without any recent transactions. Now the business understands the value of the stock has gone down. Is there a way to revalue the inventory so that the previous value will change and the lost value charged against PnL. 

This is possible under standard cost.. but the concern is how to do this under Weighted average method.

icon

Best answer by Richard Owen 2 February 2023, 14:19

View original

6 replies

Richard Owen
Rank
Userlevel 5
Badge +12

Hi,

This can be done using the ‘Modify Level Cost Details’ functionality on the Inventory Part.

The dialog box will display the current (‘Old Cost’) Weighted Average value for the items in stock. 

You can enter a ‘New Cost’ value and then press OK to update it

The Inventory Revaluation Transaction can be seen in the Inventory Transactions History screen.

 

I hope that this helps.

S
Rank
Userlevel 3
Badge +5

Hi Richard,

 

Thank you for this. Isn’t this function available in Cloud?

Thanks,

Sandy

Richard Owen
Rank
Userlevel 5
Badge +12

Hi,

Yes, you should be able to do this in IFS Cloud.

This is the equivalent example that I just created

 

 

 

I hope that this helps.

S
Rank
Userlevel 3
Badge +5

Richard,

Thank you very much. I looked at a part with an incorrect inventory valuation method. BTW I didn’t see a revaluation possibility for the FIFO part. Does that mean FIFO parts should not be revalued?

Thanks a lot for your help.

Richard Owen
Rank
Userlevel 5
Badge +12

Hi Sandy,

My understanding is that the quantities and costs associated with FIFO parts are stored in a FIFO ‘pipe’ and the system will use these values for any transactions which take place.

This can be seen in the FIFO/LIFO Analysis screen

 

 

There doesn’t appear to be any option to revalue these items. 

Perhaps other IFS Community members have some experiences to share on this topic?

Best Regards,

Richard.

 

ashenfdo
Rank
Userlevel 2
Badge +7

Thanks in advance for the options you have provided here. is there a possibility to do this re valuation for a multiple no of parts? Using a percentage?

Reply


Terms & ConditionsCookie settings