Microsoft Dynamics AX (Archived)

Clean way of reversing transactions of a closed Production order

(0) Share

Report

Posted on by raff

1,236

hi Guys

does any one have a tip for me on how best to reverse transactions of a job that has been completely closed?

The bom was set-up incorrectly, hence 1 component cost in production was 995,000 euro, which should of been 5000 e. The finished item is set-up as moving average, hence this will now also have skewed costs.

i know i cant reverse a job status once closed, but im sure we are not the first to make this mistake?

what do you think?

mal

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (4)

Verified answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi raff,

I would suggest that you document the whole issue for your auditors and do a manual adjustment posting in GL on separate ledger accounts that are different from those that are setup for your automatic inventory/production postings.

You can certainly try fixing the issue in the subledgers. Not sure how this is possible in your case - you might have to test e.g. adjusting the moving average price, correcting the component cost, etc.

Yet, I saw many customers who tried to fix similar issues in their subledgers and ended in a big mess in regards to their inventory values. For that reason I would suggest fixing only the things that are necessary to post future production orders correctly. Everything else should be fixed in GL on ledger account in my opinion.

Please let's wait a while and see if other community members have probably alternative / better solutions.

All the best for you,

Ludwig

Was this reply helpful? Yes No
raff 1,236 on at

Like (0)

Report

Thanks For your advise again Ludwig, and i am pretty sure this is the advise we will have to settle with. But as you say lets wait and see if someone has a miraculous fix for me :)

Was this reply helpful? Yes No
Verified answer

Weaveriski 23,620 Moderator on at

Like (0)

Report

Revalue the used component from 995,000 to 5000 through the adjustment in the inventory close process, run the calculation and it should still cascade up and adjust the cost of the parent and sale if made. It should also impact on the moving average but you would need to check that.

Was this reply helpful? Yes No
Verified answer

Guy Terry 28,924 Moderator on at

Like (1)

Report

Hi raff,

If the finished item is costed using Moving average and it is already sold, then it will not be possible to update the cost of the sale. Its just not possible with the Moving average method.

If it's still in stock, I think you can update the cost (if you can get the cost of the production order corrected).

Was this reply helpful? Yes No
Verified answer

Richard Wehmeyer 1,004 on at

Like (0)

Report

Always check cost calculation prior to ending production. It has saved many headaches.

Do this in TEST environment first:

You could adjust out the prodution item,

Adjust in the wrong part

Mark both to production prior to post.

Adjust out the erroneous part

Run an inventory recalc.

Adjust in the production part at the price difference.

It is possible the marking will exempt those transactions from moving average. Those more familiar with marking and moving average will have to weigh in but a run in TEST environment will let you know.

Was this reply helpful? Yes No
raff 1,236 on at

Like (0)

Report

apols for lack of feedback on this one guys, will update hopefully on Thursday when i get a chance to sit down with my finance guy and test a few options out

Was this reply helpful? Yes No
raff 1,236 on at

Like (0)

Report

it seems we had already sold all the product, hence was to late to re calculate.

but we know have a process in place to check and action these going forward, thanks for some useful advise below guys

Was this reply helpful? Yes No