Microsoft Dynamics AX (Archived)

How to check history of production order

(0) Share

Report

Posted on by Community Member

I want to check the complete history of a production order. How it be possible? I want to check that:

>Created Date / Time and who creates the order.

>Estimated Date / Time and who estimate the order

>Released Date / Time and who release the order

and so on to the end status.

I want to check the history at all levels/status of production orders.

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (0)

lally 8 on at

Like (0)

Report

You need to customize to achieve the above requirements.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Adnan Shahid,

In the production order form you will find a Log field in the process area that includes the time information you are looking for.

The user is not recorded there but you can probably use this form for an adjustment.

An alternative standard functionality would be using the database log that can provide you with all of those data.

The database log has, however, the disadvantage that it might influence the performance of your system especially if you track transactional data.

Yet, the same performance issue will possibly apply if you make an adjustment.

I would thus suggest that you test the database log feature to see if this works out for you.

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (2)

Report

You do not really need another table to track this information. If all you wanted was the date/time these events happened, you would have it already, but if you want who you'll have to enable a system field on a small handful of tables.

The table ProdParmRelease logs all release operations. If you enable the CreatedBy field in that table, then in combination with the ExecutedDateTime, you will be able to track every release for a given production order. And the table ProdParmCostEstimation will give you the same for all estimate operations. And since the CreatedBy property is Yes for table ProdTable by default, you already have what you need for the production order itself.

So, it is technically a "modification", but it's just as simple as setting a couple of properties to Yes on a small set of tables. Of course, you should test that first in an isolated environment before considering any such changes to your production environment.

Was this reply helpful? Yes No
Suggested answer

Brandon Wiese 17,788 on at

Like (0)

Report

Or, if you wanted to make the solution even simpler, just enable the CreatedBy field on table ProdParmUpdate, and I think you're done. Every ProdParmRelease and ProdParmCostEstimation will have an associated ProdParmUpdate record, so that one new field services all of the operations for a production order.

You could use database logging to record the information, and its performance impact aside, it's quite a bit more difficult to get that information back out again because of how it's stored. It would be more difficult to show that data in a grid of records, for example, unlike a regular field.

Was this reply helpful? Yes No