BOM Journal issue

xyh_self_mail

I am from ESG China, Now I faced a issue about Bom Journal. the detail infromation as follows:

Cost methods: average A = B +C
before we run ACIE, the cost of A = the cost of B + the cost of C. the result is correct. but after we run ACIE, system will adjust the cost of A and B, but it will not adjust the cost of A, so the cost of A does not equal to the total cost of A and B.

Have anybody ever faced this situation? need your help, any suggestions?

thanks in advance!

ara3n

which version are you using?

xyh_self_mail

System version is 3.7B. thanks

Shenpen

It's an old problem... some friends here report that it's solved in 4.0 although I did not check it.

The solution is 3.7 is a bit tricky. I have did the following:

- in BOM Ledger an output is always followed by the consumptions. So you can write a report that reads this, for every consumption line, reads the cost from item ledger / resource ledger, and calculates the actual total cost of the output

- I am generating revaluation journal lines based on this data, which users can post

so every month they run adjust costs - run this report - post the journal - run adjust costs again to forwards costs to COGS - post to the g/l

you could try this, or simply go with Standard Costing, if that's acceptable... I think there is a function on the Item Card that calculates standard costs for BOM items, these costs won't be 100% correct of course as the price of the materials might fluctuate, but generally should be more correct than what you have now...

Shenpen

... actually, I think if you adjust costs on every Friday f.e. and then recalculate the standard cost of BOM items, I think you should get approximately quite correct costs ...

xyh_self_mail

Many thanks for your kind suggestion.

I also tested it in version 4.0, the result is the same. could you tell where i can find the patch on this?