Skip to main content
Solved

Inventory Revaluation - Weighted Average

  • Jan 30, 2023 12:49 PM UTC
  • 6 replies
  • 916 views

Forum|alt.badge.img+6

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.

Best answer by Richard Owen

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.

View original

6 replies

Richard Owen
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Jan 31, 2023 7:58 AM UTC

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.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • Feb 2, 2023 12:55 PM UTC

Hi Richard,

 

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

Thanks,

Sandy


Richard Owen
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Answer
  • Feb 2, 2023 1:19 PM UTC

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.


Forum|alt.badge.img+6
  • Author
  • Do Gooder (Partner)
  • Feb 2, 2023 3:02 PM UTC

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
Superhero (Employee)
Forum|alt.badge.img+16
  • Superhero (Employee)
  • Feb 3, 2023 9:47 AM UTC

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
Sidekick (Customer)
Forum|alt.badge.img+8
  • Sidekick (Customer)
  • Jan 24, 2024 3:46 PM UTC

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?