Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Production: Line item cost change rollup to BOM item automatically?

  • 1.  Production: Line item cost change rollup to BOM item automatically?

    Posted 23 days ago
    Hello all,

    I am new to the group and was tasked on finding out a process on our production line for the following scenario:

    Using AX 2012 CU6

    We purchased a part used in a BOM and found that the manufacturer increased/decreased pricing on our PO, compared to past pricing.  We update the released products information to the updated cost for the item.  We then change the BOM manually.

    Are we able to get that new pricing to automatically update the cost of the BOM that the part is currently apart of, instead of manually changing the BOM?  We are doing this as individual basis, not annual.  We would like to have an accurate account of cost within the BOM monthly.

    Hopefully this makes sense.

    I appreciate any assistance.

    ------------------------------
    Miranda Heine
    NMC, Inc.
    Omaha NE
    ------------------------------


  • 2.  RE: Production: Line item cost change rollup to BOM item automatically?

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Here at Dynamics Resources we specialize in Dynamics 365, all versions of AX, and CRM. I ran your question by one of my experts.

    Please to automate price, try to use BOM Calculation Job, selecting the item with the path [CompanyName]/Product information management/Common/Released products/Engineer/BOM/Lines and then click the Calculation Button, you can configure the periodicity you need


    ------------------------------
    Michael Gonzalez
    Account Executive
    Dynamics Resources
    Venon Hills IL
    ------------------------------



  • 3.  RE: Production: Line item cost change rollup to BOM item automatically?

    Posted 23 days ago
    Thank you Michael!
    I will further into this suggestion. I appreciate your help!

    ------------------------------
    Miranda Heine
    ERP Business Analyst (Parts)
    NMC, Inc.
    Omaha NE
    ------------------------------



  • 4.  RE: Production: Line item cost change rollup to BOM item automatically?

    SILVER CONTRIBUTOR
    Posted 23 days ago
    Glad I could help, feel free to reach out anytime.

    ------------------------------
    Michael Gonzalez
    Account Executive
    Dynamics Resources
    Venon Hills IL
    ------------------------------



  • 5.  RE: Production: Line item cost change rollup to BOM item automatically?

    Posted 22 days ago
    What cost basis are you on: FIFO, Standard, LIFO, Average.  This will have a lot to do with material cost picked up on a BOM.  Also,

    ------------------------------
    Michael Mills
    AX D365 Enterprise Consultant Operations
    Blue Horseshoe Solutions
    Carmel, IN
    ------------------------------



  • 6.  RE: Production: Line item cost change rollup to BOM item automatically?

    Posted 22 days ago
    Valid point Michael!

    We are using Standard Cost basis and I know that the system limits us to only single level explosion.

    Do you have any additional ideas that would assist us in the updating of pricing?

    I appreciate all the suggestions!

    ------------------------------
    Miranda Heine
    ERP Business Analyst (Parts)
    NMC, Inc.
    Omaha NE
    ------------------------------



  • 7.  RE: Production: Line item cost change rollup to BOM item automatically?

    GOLD CONTRIBUTOR
    Posted 22 days ago
    ​When you are ready to re-calculate the cost of the item, make sure it is the only item in the pending costs of the cost version.  Then run the cost calculation from the cost version instead of from the price list.  You will have a check box available that is labeled, "Where used update".  You will notice when you check it that your "Selection" button disappears.  After you run the calculation, the pending cost list will include all of the items that have the original item in the cost list in their extended bill of materials.  It will have re-calculated all of those items.

    ------------------------------
    Kevin McLean
    Strategic Solutions NW, LLC
    Beaverton OR
    ------------------------------



  • 8.  RE: Production: Line item cost change rollup to BOM item automatically?

    Posted 22 days ago
    This also helps!

    We were not going through the cost version, just the price.

    Thank you to everyone for sharing your knowledge!


    ------------------------------
    Miranda Heine
    ERP Business Analyst (Parts)
    NMC, Inc.
    Omaha NE
    ------------------------------



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