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

Lowest price

(7) Share

Report

Posted on by DebbieG

544

Hi All,

Can someone advise if I am missing something. Client is using the new pricing feature, and has a price list linked to a price group, and then another price linked directly to the customer with an item that has a lower price than what is on the customer price group pricing.

When I do a sales order, I would expect it to bring up the lowest price?

Am I missing a setting? In the prices calc method, and have the lowest price setting

Thanks Debbie

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (11)

Answers (0)

Sumit Singh 11,757 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!
🔍 Price Calculation Method
The "Price Calculation Method" (e.g., Lowest Price) is not directly visible on the Sales & Receivables Setup page by default. Here's how it works:
✅ 1. Price Calculation Setup Table

The actual logic for determining how prices are calculated is stored in the Price Calculation Setup table.

This table includes fields like:

Method: e.g., Lowest Price

Type: Sale or Purchase

Product Type: Item, Resource, etc.

Implementation: e.g., Business Central (Version 16.0)

The default method (usually Lowest Price) is inherited from this setup and cannot be edited directly on the sales document lines [1].

🛠️ How to View or Change the Method
If you're not seeing the field:

The "Price Calculation Method" field is hidden by default on the Sales & Receivables Setup page.

You can enable it using Personalization:

Go to Sales & Receivables Setup

Click Personalize (gear icon > Personalize)

Add the "Price Calculation Method" field to the page

Set it to "Lowest Price" if not already

This setting defines the default method for all customers unless overridden at the Customer or Customer Price Group level[2].

🧠 How the Lowest Price Is Applied

Business Central evaluates all applicable prices (from customer-specific, price group, campaign, etc.).

If "Lowest Price" is the active method, it will automatically pick the lowest valid price based on:

Validity dates

Quantity

Unit of measure

Currency

Status (must be Active)

You can inspect which price was selected using the "Price Details" action on the sales line.

✅ Checklist to Ensure Lowest Price Works

Enable "Lowest Price" in the Price Calculation Setup (via personalization if needed)

Ensure price lists are Active

Check validity dates and quantities

Use "Price Details" to verify which price was picked and why

Recalculate lines if changes were made

Microsoft Link:- Extending Price Calculations - Business Central | Microsoft Learn
Note: This response was created in collaboration with Microsoft Copilot to ensure clarity and completeness. I hope it helps to some extent.
Mark the Answer as Verified if this is Helpful.

Was this reply helpful? Yes No
DebbieG 544 on at

Like (5)

Report
Copy link

Link copied!

Thanks Sumit,

Ok, I think the issue here is that the price that is used is that linked to the Bill to account and not what is linked to the order customer.

Would we need to extend this to read pricing on the customer file??

I think this is the issue.

Was this reply helpful? Yes No
Suggested answer

Mansi Soni 8,951 Super User 2026 Season 1 on at

Like (6)

Report
Copy link

Link copied!

Hello,

May this can help you as well!

https://community.dynamics.com/forums/thread/details/?threadid=e31a8522-8620-f011-9989-6045bddb894e
https://learn.microsoft.com/en-us/dynamics365/business-central/sales-how-record-sales-price-discount-payment-agreements?
https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-best-price-calculations

Regards,
Mansi Soni

Was this reply helpful? Yes No
Suggested answer

Ramesh Kumar 7,547 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Hi Debbie,

Customer price group is discount pricing for specific group of customer and if I am not wrong Business Central uses the Lowest Price method by default (controlled in Sales & Receivables Setup, and can be overridden per customer or price group)

https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/devenv-extending-best-price-calculations?utm

https://docs.bricklead.eu/en-us/apps/apm/apm-understanding-price-calculation/?utm

Thanks

Ramesh

If this was helpful, please check the "Does this answer your question?" box and mark it as verified.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,959 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

There are other important columns as well which you should focus like how it's picking. There's a date filter as well.

https://www.youtube.com/watch?v=XzFWOsYY-2E

Blog - rockwithnav.wordpress.com/
Twitter - https://twitter.com/RockwithNav
Facebook - https://facebook.com/rockwithnav/

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,086 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

Hi, have you tried changing the following settings?

More details: https://community.dynamics.com/forums/thread/details/?threadid=69f669df-9d9f-ef11-8a69-7c1e525799fb

Hope this can give you some hints.

Thanks.

ZHU

Was this reply helpful? Yes No
DebbieG 544 on at

Like (4)

Report
Copy link

Link copied!

Thanks All - but I think my issue is that it is ignoring the prices linked as per the order customer and is automatically defaulting to the lowest price as per the price lists linked to the Bill to account.

Debbie

Was this reply helpful? Yes No
Suggested answer

Sohail Ahmed 11,169 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

@DebbieG
Ah, that makes sense now. In Business Central, if the Bill-to Customer has a price list assigned, it can override the pricing set directly on the Sell-to Customer. So even if your order is for the Sell-to Customer, BC may pull prices from the Bill-to Customer's price list if it's active.

Try removing the price list from the Bill-to Customer or make sure the Sell-to Customer has a more specific price entry BC always prioritizes the most specific match.

✅ Mark this answer as verified if it helps you.

Was this reply helpful? Yes No
DebbieG 544 on at

Like (3)

Report
Copy link

Link copied!

Hi Sohail

Wish it was so easy, the Bill to customer can be sold to directly as well :( - and if you remove the price group from the HO account it just defaults either the special price or the item price, thinking there i no price defined.

I think I would have to extend it probably to use price on order customer on insert of a line on an order.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 9,112 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
Hi Debbie,

You’re absolutely right to expect the system to pick the lowest price — that’s the intended behavior when the Price Calculation Method is set to Lowest Price. But there are a few nuances that can block it from working as expected.

Here’s what to check:

Make sure the price list linked to the customer is marked as Active and has valid dates, quantities, and unit of measure. Even if the price is lower, it won’t be considered unless all conditions match the sales line.

Confirm that the Price Calculation Method is set to Lowest Price in the Sales & Receivables Setup. This field is hidden by default, so you may need to personalize the page to expose it.

Use the Price Details action on the sales line to inspect which price was selected and why. It will show all applicable price sources and explain the selection logic.

If the price is linked to the Bill-to Customer instead of the Sell-to Customer, BC may prioritize the wrong price list. You can override this by adjusting the price list assignment or customizing the selection logic.

Recalculate the sales line after making changes to ensure the pricing engine re-evaluates all conditions.

Helpful Reference
Set up prices and discounts – Microsoft Learn
Extending Best Price Calculations – Microsoft Learn
Price Calculation Behavior – Bricklead Docs

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey

Was this reply helpful? Yes No