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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Sales Cube Customer Co...
Finance | Project Operations, Human Resources, ...
Suggested answer

Sales Cube Customer Contribution Margin vs Gross profit margin

(0) ShareShare
ReportReport
Posted on by Sjoe 135

I'm running a query against the Sales Cube to extract the sales order margin information.

I see that in the cube there are two different calculated measures:

Contribution Margin

Gross profit margin

What is the difference between the two measures?

I see that for some articles the contribution margin is equal to invoiced-COGS

while for other articles it is the gross profit margin that is equal to invoiced-COGS.

I'm a bit confused

I have the same question (0)
  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Cube Customer Contribution Margin vs Gross profit margin

    Hi Sjoe,

    You can find the definition here:

    docs.microsoft.com/.../sales-cube-salescube-for-microsoft-dynamics-ax-2012-r2-and-r3

    Contribution margin (absolute):

    The amount remaining after unit variable costs has been deducted from the unit revenue.

    Contribution margin (percentage):

    The contribution margin divided by total revenue, expressed as a percentage

    Gross profit margin (absolute):

    The amount remaining after the cost of goods sold (COGS) has been deducted from the total sales for an item or a given quantity of inventory

    Gross profit margin (percentage):

    The gross profit margin divided by the total sales revenue, expressed as a percentage. The gross profit margin represents the percent of total sales revenue that a retailer retains after incurring the direct costs associated with producing the goods and services sold. The higher the percentage, the more the retailer retains on each dollar of sales to service its other costs and obligations.

    Best regards,

    Ludwig

  • Sjoe Profile Picture
    Sjoe 135 on at
    RE: Sales Cube Customer Contribution Margin vs Gross profit margin

    Hello Ludwig,

    I had already the definition, though it is not clear to me what exactly goes into the contribution margin and what goes into the gross profit.

    In fact I have a company A that sells primarily intercompany where the two values are exactly the same, while company  B that purchases from A and sells to customers where the contribution margin is not always the same as the gross profit margin. I need to know why

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Sales Cube Customer Contribution Margin vs Gross profit margin

    Hi Sjoe,

    If both differ then there must be a difference in your COGS and your variable costs associated with the product.

    Do you have e.g. an intercompany charge that you put on top of your cost price for intercompany invoicing or do you have a freight that is allocated, etc.?

    Can you have a look at your item master and the cost prices and their history and compare them with the costs that are taken for your IC transactions?

    Best regards,

    Ludwig

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,964

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 823 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 564 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans