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

Sales Price Business Central - How to make the price unique to each customer and location code

(0) Share

Report

Posted on by MichaelHersch

Hello,

My company sells one of our products on contract pricing to many of our customers. Each customer has a different sales price. I created a sales price for each customer in Business Central using (Sale Type = Customer, Sales Code = [CUSTOMER NUMBER]).

My issue is the price of our item includes delivery cost. Some of our customers have multiple delivery locations which gives them multiple prices for the same item.

Is there a way in Business Central to set up Sales Prices to use both Customer Number and Ship-To Address Code as parameters?

Thank you,

Michael

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

JAngle 133 on at

Like (0)

Report

It would require modification or a business process change. A courier integration where you gave base prices and then assign a delivery charge based on delivery variables like weight or distance travelled. A new pricing method could be done especially with the new price experience where you swap out the standard for custom logic

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Hi, This looks like it needs to be customized.

There is a workaround, although I don't personally recommend it.

You can use Variant Code to manage your Ship-To Address Code. In this way, in the sales line, if you select different Variant Codes, different prices will be used.

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No
MichaelHersch 17 on at

Like (0)

Report

What are the downsides of doing it this way?

Was this reply helpful? Yes No
Suggested answer

JAngle 133 on at

Like (0)

Report

purchase and inventory mgt. impact is the worst. You need stock of the item variant to sell it. That’s ok if you will hold consignment for specific customers, but I supremely doubt that. For a smooth experience all round go for a modification

Was this reply helpful? Yes No
Suggested answer

MahGah 15,529 on at

Like (0)

Report

I also need to echo what Josh said. Variants add lots of complexity to process. development is the easier method. Just keep in mind new Price experience in mind for future compatibility.

Or check this app to see if it works (it is a paid app) docs.isatech.eu/.../

or vote for this idea if it helps you experience.dynamics.com/.../

or submit your idea

experience.dynamics.com/.../

Was this reply helpful? Yes No
Suggested answer

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

Like (0)

Report

Yes, as mentioned by several experts above, it will make management more complicated.

More details:

https://www.youtube.com/watch?v=f8aaBcXbhro

https://www.youtube.com/watch?v=hhL4CxUliJ8

Hope this helps as well.

Thanks.

ZHU

Was this reply helpful? Yes No