D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Finished Good Life Cycle

  • 1.  Finished Good Life Cycle

    Posted May 14, 2019 08:13 AM
    ​Does anyone have a good way to see the date when a finished good was first made available for sale, and then a date to see when it was obsolete and no longer available for sale?


    Katherine Dyke
    Whip Mix Corporation
    Louisville KY

  • 2.  RE: Finished Good Life Cycle

    Posted May 15, 2019 03:35 AM
    Hi Katherine,

    we had to do customization for that in AX 2012 R3. We introduced special lifecycle state on products which is linked to tracking the times when certain statuses change and to blockages of various processes in system. It was quite extensive to integrate it everywhere since we have fairly complex SCM and production processes. The topic itself is big since it is linked to product availability, support of remanufacturing of products in later return/rework processes, stock inventory level optimization and more.

    Vjekoslav Levacic
    XAL Holding GmbH

  • 3.  RE: Finished Good Life Cycle

    Posted May 15, 2019 09:00 AM
    In AX2012 and in D365 there is now on the released product a start sale date and an end sale date. These will prevent sales before the start sale date, and after the end sale date. using this field you can know exactly what dates were the start and the end.

    Paul Martin
    Production Program Manager
    Elite Comfort Solutions, LLC
    Rutherfordton NC

  • 4.  RE: Finished Good Life Cycle

    Posted May 15, 2019 09:14 AM
    If you have the Retail Headquarters config key enabled, you will have a "Retail" fast tab on your released products.  There are fields related to this that are used by POS, but no other functionality in the client uses them.  So you should be fine to populate them with your data and make sure you stop the items in DOS at the same time.

    If you dont have that enabled, you could just add a Product Attribute for Start / Stop sales date.  Once you assign the product attribute to a category hierarchy node, then assign the product to that Category Hierachy node, you'll be able to assign attribute values on the Released product ->  If you want to see them in mass, there is an AOT query EcoResProductAttributeValue that will show you all items and the product attribute values if you expose it to Excel Add-In via Org Admin -> Setup -> Document Mgmt -> Document Data sources.  Once you get it down to Excel, when in design mode, right mouse click on the top level table EcoResProductAttributeValue in the field chooser -> Properties -> tick the "show calculated fields".   The display methods that exist on the tables in the query will get added to the field list in ().

    Assigning the Attribute value to a product:

    Enabling the AOT query to show up in the Excel Add-In:

    Enable Computed columns / calculated fields on the query in excel:

    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