Skip to main content

Notifications

Supply chain | Supply Chain Management, Commerce
Suggested answer

Sales Margin Calculation

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
    Hitesh21 Patel 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
    MATTGUO 22,306 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
    Andy_T 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
    Rahul Mohta 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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans