Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Supply chain | Supply Chain Management, Commerce
Suggested answer

Sales Margin Calculation

(0) ShareShare
ReportReport
Posted on by 330

Hi All

I know it is possible to turn on margin alerts on sales orders so you can see the margin % and whether it is in tolerance but is it possible to see somewhere how this margin is worked out?

i.e. if you are using FIFO stock - what price is the average cost price we are consuming the stock at?

Thanks

  • Hitesh21 Patel Profile Picture
    130 on at
    RE: Sales Margin Calculation

    Average Cost Price is a calculated field not possible on sales order screen looks like a customisation

  • MATTGUO Profile Picture
    22,319 Moderator on at
    RE: Sales Margin Calculation

    Hi Miller,

    The average cost price can be seen in on-hand list with the different dimensions by clicking the item number.

  • Andy_T Profile Picture
    330 on at
    RE: Sales Margin Calculation

    Thanks for the reply

    This only show the estimated margin - it doesn't show how it is calculated. I'd like to see the average cost price.

    pastedimage1579866382636v1.png

  • Suggested answer
    Rahul Mohta Profile Picture
    21,014 on at
    RE: Sales Margin Calculation

    on the sales line try using the button to see price details

    you may need to enable it in AR or S&M paramaters

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,261 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,996 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans