D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Batch Manufacturing Date History

  • 1.  Batch Manufacturing Date History

    Posted Jun 21, 2019 04:15 PM

    Occasionally, we will reset the Manufacturing date of a batch (typically for Raw Material).  Is there a way to see the history of 'manufacturing dates' for a specific batch?

    Similar to the Batch Disposition History, but for manufacturing / shelf life dates.



    ------------------------------
    Ken Johnson
    IT Manager
    Pfanstiehl, Inc.
    Waukegan IL
    ------------------------------


  • 2.  RE: Batch Manufacturing Date History

    SILVER CONTRIBUTOR
    Posted Jun 24, 2019 06:17 AM
    Ken;
               If this is something that is a critical need then I would recommend turning on the database log for this table. Unfortunately if you do not already this enabled then any previous data will not be accessible. One thing you left off is what version of AX you are using. If anything previous to 365 then this is the way to go. If 365 I'm unaware of if this would be the same. Also you could look into an auditing add on as well as we're using FastPath. But once again you will only capture data once these are configured.

    Good luck.

    ------------------------------
    Ted Jillett
    Business Systems Analyst, Manufacturing AX
    Insulet Corporation
    Acton MA
    ------------------------------



  • 3.  RE: Batch Manufacturing Date History

    Posted Jun 24, 2019 08:02 AM
    Thanks Ted.  We are running 365.  I suspected the database log would be the only solution.  I'll look into some other auditing add ons also.

    Thanks.

    ------------------------------
    Ken Johnson
    IT Manager
    Pfanstiehl, Inc.
    Waukegan IL
    ------------------------------



  • 4.  RE: Batch Manufacturing Date History

    TOP CONTRIBUTOR
    Posted Jun 24, 2019 11:15 AM
    Hi Ken,

    As Ted said, there's no real option except the db logging. To set it up, make sure "Show all tables" and "Show Table names" are ticked, then Trade -> InventBatch -> ProdDate.

    Alternatively, you could handle it by process and take out a Quality Order of reference type "Inventory", and have only certain QA associates have permissions to edit the mfg date.  You could require them to add notes to the Batch -> Description field, which is just a big blob of text that someone can put notes into regarding why the change was done, who did it etc.  Its not the most elegant solution, but it's worked for a few clients.

    ------------------------------
    Colby Gallagher
    Manufacturing Systems Consultant
    Agility Business Solutions
    Brecksville OH
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role