web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

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

Item profit as value instead of percentage

(0) ShareShare
ReportReport
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

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,071 Moderator 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

  • GarethRGL Profile Picture
    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
    1,071 Moderator 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
    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
    1,071 Moderator on at
    RE: Item profit as value instead of percentage

    What country / region are you operating in?

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

    We’re in the UK

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,071 Moderator 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
    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
    1,071 Moderator 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

  • Suggested answer
    YUN ZHU Profile Picture
    94,369 Super User 2025 Season 2 on at
    RE: Item profit as value instead of percentage

    Hi, hope the following helps.

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

    Thanks.

    ZHU

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,901

#2
YUN ZHU Profile Picture

YUN ZHU 2,079 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 2,041

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans