This client , has nav 4.0 sp3 .
It seems that the adjust cost item entries batch screwed up the item costs somehow.
I am not certain how but , that is a different question.
The raw material had got its item cost somehow doubled by the batch.
This has been used in product , manufactured using the production bom.
How shall we fix the costs ? Items are having average costing.
Use the revaluation journal, but make sure you get to the bottom of this, the ACIE does not simply double costs, there is something there causing this and I would guess it is a modification - fix it otherwise you will be constantly correcting the costs that are obviously wrong.
Thanks Adam ,
This is what I was suspecting , I guess I need to pick the items that includes the raw material too , am I right?
Revalue the raw material, run ACIE and check the finished product cost, if you then need to revalue this as well
I did the revaluation post but it posted 0 to the value entries ...
On the journal it looks fine but posts nothing ...
Is it because the item costing is average ?
So you have defined a new cost on the journal line, posted it and run ACIE?
If the valuation entry does not alter then the cost of the raw material is correct.
Your next issue is what it did to the finished goods, but this really comes back to identifying the problem rather than fixing it.
Well to clarify,
I expected the raw material's item ledger entry's value entries to be fixed.
in other words the cost amount actual to be adjusted back to original , however the revaluation journal,
posted 0 to the cost amount actual and the value to the cost amount (non invtlbl) field ..
This would leave my item cost on the raw material incorrect. Can I fix this ?
There are two ways to get the entry into the revaluation journal - how did you do it?
Then I presume it told you that the unit cost was $x and you set it to $y. You posted the journal and ran the ACIE routine - yes?
well , I search the item ledger entries that are having incorrect unit cost ( I calculated the unit cost) and for each Item ledger entry I added a revaluation entry with the appropriate date and item no. then in the applies to Item I picked the old (incorrect ) ile no. Then I addjusted the unit cost revalued to the correct cost and posted it..
But not the ACIE?
What do you mean by ACIE ?