Business Central allows for the creation of multiple Sales Prices for a given Item/Customer combination, including for "Customer," "Customer Price Group," and "All Customers." This implies that BC supports true TABLE to GROUP to ALL pricing like other systems (most notably Dynamics AX, which we have been using for the last 10 years, and Dynamics GP, which we used for the 10 years before that): when entering a sales order, the system first looks for a TABLE (customer-specific) price, and if there is none, it looks for a GROUP (customer group-specific) price, and if there is none, it uses the ALL (base) price. Oddly, BC does not use this logic. Instead, as described in https://docs.microsoft.com/en-us/dynamics365/business-central/sales-how-record-sales-price-discount-payment-agreements#best-price-calculation and supported by our own testing, BC just looks at all the possible prices for an Item/Customer combination and uses the lowest price available. There is no prioritization of the TABLE to GROUP to ALL hierarchy. This would be fine if our TABLE price was always lower than our GROUP price and our GROUP price was always lower than our ALL price, however that is not the case: we are wholesale distributors, so we use ALL to hold our base “wholesale” price, but we also charge full retail to walk-in customers via GROUP “retail” (“retail” prices are of course higher than “wholesale” prices); we also factor freight into the prices for a few specific customers, so their TABLE prices are higher than the ALL prices. We propose that an option be added to BC base code to allow for true TABLE to GROUP to ALL pricing: for a given Item/Customer combination, if a "Customer" price exists, use that price...else if a "Customer Price Group" price exists, use that price...else use the "All Customers" price. Our partner is developing an extension for us to accommodate this functionality deficit, but we are of course concerned that future updates will wreak havoc with the extension. Although the current BC pricing structure surely works for many customers, we’re also sure there are other customers out there who would benefit from this proposal. Thank you for your consideration!
Comments
I do agree that this evolution is really important and most ofour customers would like to have it.
Thanks for your proposition
Nathalie
Category: Sales
Please review the standard help about the "best price calculation"
"When you have recorded special prices and line discounts for sales and purchases, Business Central ensures that your profit on item trade is always optimal by automatically calculating the best price on sales and purchase documents."
It says: "your profit on item trade is always optimal": this is not really true if the price for a group to which the customer belongs is lower than the price for a specific customer.
I think a structure as explained above (first look for specific price and then go to more general), would be a very good idea and would work in all cases.
We have modified this ourselves in quite a lot of cases, and I see price calculation extensions that have 'skip best prices calculation' as a functionality.
Category: Sales
Business Central Team (administrator) on 9/20/2024 12:58:47 AM
Thank you for this suggestion! Currently this is not on our roadmap. We are tracking this idea and if it gathers more votes and comments we will consider it in the future.
Best regards,
Business Central Team