D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Error on Cost Calculation

  • 1.  Error on Cost Calculation

    TOP CONTRIBUTOR
    Posted 21 days ago
    How do you mass calculate the cost on products when they have the same co-product?

    Scenario:

    We produce multiple items with the same co-product. For instance, we create two different types of cheese, each with the same output of whey cream. Currently, we cannot calculate the cost of all items because it throws the following error:


    I am certain that there are others who face the same scenario. What have you done to alleviate this issue?

    Thanks in advance!

    ------------------------------
    Robin Finnell
    Continuous Improvement Coordinator
    Operations Lead - D365FO/MES Implementation
    Tillamook County Creamery Association
    Tillamook
    ------------------------------


  • 2.  RE: Error on Cost Calculation

    SILVER CONTRIBUTOR
    Posted 21 days ago
    Robin,

    Generally, in a cost roll process, you'd want to start by calculating and activating new costs for your subassembly items and build your way up.

    ------------------------------
    Ian Gorman, PMP, MCSE
    Consultant
    ------------------------------



  • 3.  RE: Error on Cost Calculation

    Posted 21 days ago
    I agree with cost rolls need to start with components, then subassemblies, and finally finished goods.   There might be a second issue and that has to do with the type of co-product vs. by-products for the whey cream.  If I was trouble shooting I would take a look at the different cost impacts based on the selection of co vs. by-products.  If you search on "About co-products and by-products" the article will provided  insight. My suggesting is to create a flat formula for the product that produces whey (no subassemblies in formula), rollup the components in the formula and make active, then try to roll-up finish goods cost (test 1).  In test 2  change the whey product line from co to by-product and try your cost roll at the finish good level again. I am  interested in the results of your testing if you want to share the results.

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



  • 4.  RE: Error on Cost Calculation

    Posted 21 days ago
    One last thought, after looking at the error message one more time.  I looks like you might have a pending cost that has not been made active.
    Navigate to Release items > Manage cost > Item Price and check pending price tab. If there is a pending price delete it.

    Display pending and Active prices

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



  • 5.  RE: Error on Cost Calculation

    SILVER CONTRIBUTOR
    Posted 16 days ago
    Michael,

    You bring up a great point.

    Robin,

    You may want to delete all pending costs that are currently associated to your costing version prior to running the calculation process.

    ------------------------------
    Ian Gorman, PMP, MCSE
    Consultant
    ------------------------------



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