Skip to main content

Notifications

Small and medium business | Business Central, N...
Answered

See Profit % By Line On Sales Order

Posted on by 20

I would like to see the Profit % as a column on sales lines that compare cost to actual price on that specific order to calculate the profit %. 

Similar to post: (+) Profit% on sales orders - Dynamics 365 Business Central Forum Community Forum

Can this be done with Base BC or will it need to me a modification?

Thanks

Categories:
  • Suggested answer
    PioneerMike Profile Picture
    PioneerMike 20 on at
    RE: See Profit % By Line On Sales Order

    KasparsSemjonovs Thank you! I will continue with a small mod to add this function in our environment.

  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: See Profit % By Line On Sales Order

    statistics shows total order profit, but if You look at the right side (Fact Boxes) - if hidden, press on the round "i" button to display.

    pastedimage1683117086414v1.png

    Anyway this field does not update if You change the Unit Price in Sales line - so You have to add a custom field, but You can look how it is done in the fact box and adjust it, to take the Unit price from the Sales line in the calculation and the Standard or Unit cost from the Item card - just like in the FactBox.

  • PioneerMike Profile Picture
    PioneerMike 20 on at
    RE: See Profit % By Line On Sales Order

    KasparsSemjonovs Thanks for this helpful insight. understanding the system always helps. is there a way to see the approximate profit based on last purchase cost on a line level?

  • PioneerMike Profile Picture
    PioneerMike 20 on at
    RE: See Profit % By Line On Sales Order

    Appreciate the input, i am aware of the Statistics function which is only total order profit %. This won't resolve my challange.

  • KasparsSemjonovs Profile Picture
    KasparsSemjonovs 3,924 Super User 2024 Season 2 on at
    RE: See Profit % By Line On Sales Order

    The actual price will only be know to the system once the Sales Shipment is posted, and Outbound Item Ledger Entry is applied to Inbound entry, and the process "Adjust Cost - Item Entries" has been finished (either run manually or if Automatic Cost adjustment is turned on in Inventory setup then at time of posting the shipment).

    So until shipment is posted, system could try to calculate approximate profit based on last purchase cost.

    As Rahul mentioned - in the FactBox there is a field that shows this Profit field from the Item Card - but it works if You have fixed price for item in the Item card.

  • Suggested answer
    NAV_with_Narang Profile Picture
    NAV_with_Narang 2,234 Super User 2024 Season 1 on at
    RE: See Profit % By Line On Sales Order

    Hi Mike - To the best of my understanding if you want such a column on sales lines, you'll have to go for a customization. However, if you open Sales Order there is a page called Statistics which has a field Profit %, see if it helps

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!

Community AMA December 12th

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

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans