Update Weighted Average unit cost

hi @Mohsen ,

You can try if the Calculate and Cascade Weighted Average Actual Cost function is giving you the expected results. 

Regards,
Dinudu Kankanamge. 

Hi @Dinidu Udana ,

I tried the function that you have replied but it didn’t work for my case and I read the help and and I realized that this function is only for Shop Orders.

It would be very helpful if you have any other solution for this situation, Thank you.

Hi @Mohsen ,

It seems for Cascade Update of Cost on Inventory Transactions, If the valuation method on receiving site allows cascade updates, a new cascade will be triggered for the received part from the receipt transaction and onwards.

You can read more about the current capabilities of  Cascade Update of Cost on Inventory Transactions on IFS Clod documentation: IFS Cloud Documentation

Hope this helps. 

Regards,
Dinudu. 

Hello;

If you are going to update a specific period, exceed in PL SQL. You can do it with script.

update trcost_unit_cost a set a.UNIT_COST= ...

where a.COMPANY= ...

and a.CONTRACT = ...

and a.YEAR = ...

and a.PERIOD = ....

and a.PART_NO = ....

NOTE:

Write appropriate parameters instead of ...

In order to update the value of the transaction performed on 6/16 to use the Weighted Average value that existed on the 6/13, there would need to be at a minimum a place (table) in which all previous WA values by date are stored, which there is not.