Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Profit Price Calculation

(0) ShareShare
ReportReport
Posted on by 125

I have set up unit cost of an item as USD 10,000 and profit/price calculation as price=cost+profit. On the profit percentage field i have put 30%. The system has shown unit price as USD 14,281 yet i was expecting 13,000. Can someone give an insight on this

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,964 Super User 2024 Season 2 on at
    RE: Profit Price Calculation

    (Price - Cost)/(Price) = Margin

    In your example (13000 - 10000) / 13000 = 23%

    (14,281 - 10,000) / 14,281 = 30%

  • JAngle Profile Picture
    JAngle 33,159 on at
    RE: Profit Price Calculation

    The formula for the validation is like below:

    "Price/Profit Calculation"::"Price=Cost+Profit":

                           if "Profit %" < 100 then begin

                               GetGLSetup;

                               "Unit Price" :=

                                 Round(

                                   ("Unit Cost" / (1 - "Profit %" / 100)) *

                                   (1 + CalcVAT),

                                   GLSetup."Unit-Amount Rounding Precision");

    So flesh that out with your values step by step:

    "Unit Cost" = 10,000

    1-30 / 100 = 0.7

    VAT = 0

    Rounding will be whatever. Resulting in this equation:

    (10,000 / 0.7) * 1 = 14285.71429

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!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,445 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans