Inventory Costing, Production output.

Mike_Heffner

Hello,

I have a client who is on NAV 4.0 SP3 with the following problem.

They are using average costing and an item that should cost about $512 is showing a unit cost of $2500. The item is a production output. And, we believe the problem was caused by closing the job without posting any consumption.

Of couse now we can't go back and post the consumption, and we can't change the unit cost so we are stuck.

Does anyone have any idea how to correct the cost in this situation?

Thanks,
Mike

leugim

Mike Heffner wrote:

Hello,

I have a client who is on NAV 4.0 SP3 with the following problem.

They are using average costing and an item that should cost about $512 is showing a unit cost of $2500. The item is a production output. And, we believe the problem was caused by closing the job without posting any consumption.

Of couse now we can't go back and post the consumption, and we can't change the unit cost so we are stuck.

Does anyone have any idea how to correct the cost in this situation?

Thanks,
Mike

hi.
surely the problem will be closing the job without consumptions...
you can try to re-create the finished production order as a released production orden and then post the consumptions, using some process or so... maybe it can work, maybe not...

PLEASE test in a COPY or your database first...
if doing so, don't forget to delete manually the released prod. order you re-create...

regards

AdamRoue

If it should have cost $512, and you never posted consumption how on earth did it get to $2500? Surely you over consumed?

If you go to the finished production order and select entries and value entries you will see all the entries making up your cost.

With regards to the cost you can use a revaluation journal to alter the output cost and subsequent cogs. For the consumption you can manually relieve stock using an item journal, but I would seriously check the consumption first, and how you get to $2500!

Mike_Heffner

I forgot to mention in my original post. When we try to run revaluation we get a divide by vero error. I am not sure how to tell what is causing that.

Mike

AdamRoue

You should only get a divide by 0 error with modified code, if it is Microsofts there will be a fix, but I would guess it is a modification. You can run debugger to find out what is causing it, but you will probably need a fix for it.