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

Variable Pricing on Products - Multiple Variables

(5) Share

Report

Posted on by Tris15

400

Hi Everyone

We want top use Sales Pricing within Business Central, however our requirement don't fit the standard functionality of BC.

We want to set up pricing based on a combination of Customer Location, Customer Business Type, Product type, Forex Rates, and Freight types

Is there a way to compile your Sales Prices based on this combination matrix in standard BC (probably not) or should this rather be a development on our end?

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Jainam M. Kothari 15,639 Super User 2025 Season 2 on at

Like (1)

Report

Hello,

In Standard Functionality, Business Central allows you to set up sales prices and discounts based on various criteria such as customer groups, item categories, and currencies.

However, it doesn't natively support a combination matrix involving Customer Location, Customer Business Type, Product Type, Forex Rates, and Freight Types all together.

So, You need to do customization for your specific requirement.

Was this reply helpful? Yes No
Ramesh Kumar 7,527 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

You have both Customer pricing and Customer group pricing available. However, if you need to add more options, customization would be required. That said, I know the Sales Price table is being updated in the BC26 version, so it’s worth checking that out—it might address some of your requirements

https://learn.microsoft.com/en-ca/dynamics365/business-central/across-prices-and-discounts?tabs=current-experience

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

YUN ZHU 95,720 Super User 2025 Season 2 on at

Like (0)

Report

Yes, as far as I know this can only be done by customization.

Or submit this idea to Microsoft.

Missing a feature? Post or vote for ideas on: aka.ms/BCIdeas

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 20,441 Super User 2025 Season 2 on at

Like (1)

Report

It will required customization.

Was this reply helpful? Yes No