Skip to main content

Notifications

Announcements

No record found.

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

Item profit as value instead of percentage

Posted on by 79

Hi,

We are looking to find out if anyone has done this, or can suggest if this can be done.

In BC365 we have changed the items price/profit calculation from “profit = price - cost” to be “price = cost + profit” thus enabling us to set the item price with a markup, however, we only have the option to set the markup as a percentage, we want to set this with a monetary value.

Heres an example;

Item A is a cup, we always want to make £5 on a cup.

Item A costs us £5, so we set the profit as £5 and the unit price is obviously then £10.

The next time we buy in a set of cups they have increased to £6.50, so our unit price will now appear as £11.50, as the profit is still set at £5.

We need to do this on a sales item price list, we will configure an RRP sale price list, a trade price list and wholesale price list.

Unfortunately upon checking the price lists we can only configure a unit price and cannot configure any further.

Any help would be greatly appreciated.

Thanks,
Gareth

Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,647 Super User 2024 Season 2 on at
    RE: Item profit as value instead of percentage

    Hi, hope the following helps.

    https://yzhums.com/28916/#toc4

    Thanks.

    ZHU

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item profit as value instead of percentage

    Here is a starting point if you want to get into AL Development.

    There are tons of resources out there but this is the official Microsoft starting point.

    learn.microsoft.com/.../devenv-get-started

  • GarethRGL Profile Picture
    GarethRGL 79 on at
    RE: Item profit as value instead of percentage

    I’ll reach out on linked in shortly, but can you advise on how we access, in theory, the back end of our BC environment?

    Thanks

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item profit as value instead of percentage

    There are a few options for you in the UK - some are listed here:

    appsource.microsoft.com/.../partner-dir

    You can also reach out to me directly on LinkedIn or e-mail if you want a more specific recommendation.

  • GarethRGL Profile Picture
    GarethRGL 79 on at
    RE: Item profit as value instead of percentage

    We’re in the UK

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item profit as value instead of percentage

    What country / region are you operating in?

  • GarethRGL Profile Picture
    GarethRGL 79 on at
    RE: Item profit as value instead of percentage

    Our MS partner does not offer any support for some reason, we have had multiple conversations about this, despite people in the forum saying they must, they insist they do not.

    Could you point us in the direction of access this please?

    Obviously nothing will be changed until we have someone that can do this, but we need to know how to access this,

    Thanks,
    Gareth

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item profit as value instead of percentage

    If you do not have any experience with doing programming in AL that is the language Business Central use for customizations. Then I will recommend you contact your partner and discuss with them if they can assist you with these customizations.

  • GarethRGL Profile Picture
    GarethRGL 79 on at
    RE: Item profit as value instead of percentage

    Hi,

    Appreciate your response.

    Our business central environment is hosted by Microsoft, as in its not on premises, how can we go about getting access to make these customisations?

    Thanks,
    Gareth

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item profit as value instead of percentage

    There is no out of the box functionality that covers this scenario.

    But with the right customization it can be done.  In the last versions of Business Central it is a lot easier to customize the price calcualtion then it used to be.

    Here are some documentation that will be useful if you want to create a customization around this.

    learn.microsoft.com/.../devenv-extending-best-price-calculations

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 Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans