Skip to main content

Notifications

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

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

(0) ShareShare
ReportReport
Posted on by 17

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 

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,254 Super User 2025 Season 1 on at
    RE: Sales Price Business Central - How to make the price unique to each customer and location code

    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

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Sales Price Business Central - How to make the price unique to each customer and location code

    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/.../

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: Sales Price Business Central - How to make the price unique to each customer and location code

    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

  • MichaelHersch Profile Picture
    MichaelHersch 17 on at
    RE: Sales Price Business Central - How to make the price unique to each customer and location code

    What are the downsides of doing it this way?

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 77,254 Super User 2025 Season 1 on at
    RE: Sales Price Business Central - How to make the price unique to each customer and location code

    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.

    pastedimage1654652672749v1.png

    Hope this helps as well.

    Thanks.

    ZHU

  • Suggested answer
    JAngle Profile Picture
    JAngle 48 on at
    RE: Sales Price Business Central - How to make the price unique to each customer and location code

    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

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

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,162 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,962 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans