web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Costing for Items containing formula and co-product items

(0) ShareShare
ReportReport
Posted on by 135

Hello,

I have a formula item (SFSDPG01-59) that has a co-product (SFFDPG01-59). From a costing perspective the co-product item is 25% of the total cost.

Both of them are part of the BOM for SFMADPG01-59.

This is the BOM screen shot for SFMADPG01-59

pastedimage1587548133381v1.png

When I calculate the costing for item SFMADPG01-59, AX is exploding the DBA for SFSDPG01-59 (the formula item) and costing it fully (100%) instead

of costing it at 75% as it should be, then is costing SFFDPG01-59 (the formula item) correctly at 25%. This result as an overstated costing.

Why is that?

  • Guy Terry Profile Picture
    29,028 Moderator on at

    Hi Sjoe,

    Can we get a screenshot of the Formula for item SFSDPG01-59, and a screenshot of the Co-products form for that Formula?

  • Sjoe Profile Picture
    135 on at

    Hello,

    I'm attaching what requested. In the meantime I found a way to overcome the problem reported. When I cost a product (Released product - Manage Cost - Item Price - Pending Price - New - Calculation) there is a pull-down window called Explosion mode that contains 4 possible selection (Multilevel, Make to order, Single level, According to BOM Type). When I use Multilevel the costing behave like explained in this chat. If I use According to BOM type I have the expected behaviour. Where can I find the explanation of the 4 possible selection?

    Here the screen shot of Formula

    pastedimage1587633875804v1.png

    and the one for the co-product

    pastedimage1587633932450v2.png

  • Sjoe Profile Picture
    135 on at

    Hello,

    can someone point me to the documentation that explains of the 4 possible options I listed in my previous reply?

    Thanks

  • Verified answer
    Dolores Young Profile Picture
    Microsoft Employee on at

    Hi Sjoe,

    This is all the documentation I can find.  It is old, but the functionality has not changed.

    pastedimage1591894156695v1.png

    Regards

    Dolores

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 536 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 363 Super User 2026 Season 2

#3
CU-1234529-002 Profile Picture

CU-1234529-002 188

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans