WIP-list isn't cleared when production order is ended

(0) Share

Report

Posted on by HenkeNord

465

We have recently upgraded to AX 2012, but we have a problem with ending production orders. Some of the ended production orders still appear in the WIP-list with a value.

*This post is locked for comments

I have the same question (0)

All responses (10)

Answers (0)

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Henrik,

Can you let us a bit more Details about your issue?

Can you identify the amount and cost element that causes the WIP account not to get cleared e.g. indirect cost elements, raw material costs, etc.?

Can you also let us know your system version (AX2012 R2/3 CU...)?

Ludwig

Was this reply helpful? Yes No
HenkeNord 465 on at

Like (0)

Report

No it's in work in process-list. Even though the production order is ended transactions and values are still in the list.

We are using 2012 R3 CU9 (or 10)

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Henrik,

This looks interesting. When you reported the production as finished has somebody activated the "accept error" parameter resp. does this parameter generally default?

Have you tried recalculating your inventory for this specific production item to see if this fixes the problem?

Ludwig

Was this reply helpful? Yes No
HenkeNord 465 on at

Like (0)

Report

Yes the inventory is closed per 2016-06-30.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Henrik,

This might get hard identifying the underlying reason for this outcome but probably let's try running the "potential conflicts - work in process and General ledger" Report available in inventory Management / Reports/Status/Inventory value hoping that this Report provides some additional Information on what might have gone wrong.

Hope this helps,

Ludwig

Was this reply helpful? Yes No
HenkeNord 465 on at

Like (0)

Report

659 pages, where a lot of it is related to our WIP account with error message "A posting with un-authorized posting type relating to another module has occurred on

this main account representing inventory will cause imbalance.". Perhaps there is something wrong here.

Was this reply helpful? Yes No
HenkeNord 465 on at

Like (0)

Report

Does anyone know when the route transactions are cleared from the report? Is it the status "end" of the production order or is it when bookings on wip-account are settled?

Was this reply helpful? Yes No
Fredrik Sætre 12,644 on at

Like (0)

Report

It should be when ending the production order. All items picked and elapsed resource time (+indirect costs) are posted.

Was this reply helpful? Yes No
HenkeNord 465 on at

Like (0)

Report

I found the problem, but not a solution. It's the "Work in process" report that interpret the "per date" parameter wrong. Even though I enter 2016-06-30, the ProdResourcesInProgressController class interprets the date to 2016-06-29 22:00:00. This makes the filter to the report, on table ProdRoutetTrans, look like this:

DateWip = "1901-01-01"..2016-06-29

DateCalc = "2016-06-30"..,""

when it should look like:

DateWip = "1901-01-01"..2016-06-30

DateCalc = "2016-07-01"..,""

This makes the report print all transactions where the ending date of the production order (and therefore the DateCalc on ProdRouteTrans-rows) is 2016-06-30, which is wrong. The report should only print row where the DateCalc-field is greater than 2016-06-30 or Empty.

It cannot just be me who have this problem, or is it me that doesn't understand the "per date"-parameter? In AX2009 we always entered the last date of the month as "per date".

Was this reply helpful? Yes No
Suggested answer

HenkeNord 465 on at

Like (2)

Report

After many emails from our partner to Microsoft the finally admitted this was a bug and released a hotfix:

"KB 3198954 Production order is included into the WIP report when running it as on the date when it's ended"

Was this reply helpful? Yes No