Is it possible to update Average Cost in ALL branch plants of Company ??

[Jawad]

Hi All,
We have a requirement where some of our Items belong to Branch Plants in different Companies.
When we receive a Purchase Order, we want the system to calculate the new Average Cost of the Item, and apply the new cost to all Branch Plants belonging to the same Company.
What I know is that the Average Cost will be calculated only in the receiving BP. Any solution to the requirement ?
p.s. we are having the same Average Cost for all branch Plants in each Company, however, we are keeping the Cost level of the Item as "Item Branch Plant" in the Item Master.
Any suggestion or hint is appreciated.

 

[clmates]

Hi.

I think that in standard functionality this can't be solved, but is easy with a custom report.

We have solved this with a custom report that looks at the stock at a given date then go back from this date looking for receipts in F43121 (by matc), the looks for the invoice of this receipt also in F43121 (by matc) and calculates the cost paid to fill the stock quantity. Then calculates the average and updates a custom cost method (we use 51) then we can copy this cost to 02 or simulate and freeze to 02 or 07

We had to develop this to fulfil an audit requirement.

also if we found 0 stock we update with the last receipt invoice cost from the given date.

we run this also for outside operations *OP items

The main things to consider when developing this is:

1. Different logic for item cost level 1, 2 and 3
2. Run with a given date and get stock with F41112 + F4111 (if not a period end date)
3. Fill quantity up to stock (discard the excess quantity and their matching cost)
4. Implement a process option to run in Proof and Final mode

5. Implement logic to consider strange cases (stock greater than purchase receipts, stock 0, receipt received but not vouchered, etc)
6. We also implemrnted our final output with formscape to get the user summary view like:
- Previous cost, new costs
- Items with branches at different previous cost
7. And we used this report also tu update our purchasing leadtime as the information is in the same tables

Hope this helps