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.
But not the ACIE?
What do you mean by ACIE ?
Neither the ACIE nor the Revaluation had fixed my value entries ...
So you do not know what ACIE is but it has not resolved your problem.
Processing a revaluation and posting it with a changed cost and then running ACIE will update entries. If not then there are three possibilities:
1. You are doing it wrong2. You are not telling me everything3. There is a modification/issue impacting in one of the areas.
Yep exactly ,sometimes you dont know what the hand does, but it still does it ...
Anyways, I tested it in Cronus and it worked fine, but not in this case, so I am puzzled...
Well one thing I realised during the debugging , as per NAV this item is not Inventoriable , because its consumption line , given its been consumed on the manufacturing of item.
Does this ring a bell ?
The end destination does not matter at this stage, we are struggling to revalue the component, so if it cannot be revalued you cannot know if the finished good will be updated, I do not think it will, but it has been a while - if you want short cut it and revalue the production output which is what you want, but I do not believe this problem will go away for you.
Let me know what do you think of this :
This "fixed" the item cost retrospectively . However if my valuation date starts in december the values are not perfect. .
So I suspect sth. caused the R795 ACIE :) to screw the costs, how should I pick this, or should I at all worry about that ?
Once you start going into the tables and adding entries and changing flags then all is lost - this approach maybe the cause of the original problem - there is little advice I can give you from here, you are on your own once you start doing in through the back door.
yup this is fair enough . Question is what standard tools are left for me to tackle this issue ? given that the revaluation journal didnt do the trick , even though it should have.
You need to investigate the reasons why, as you said it works fine in a test environment, also try revaluing the finished good product which you have not done yet. The standard tools do work they just do not in this single instance - work out why. Has your partner been involved?