Configuring Customer-Specific Pricing in Dynamics 365 Business Central (Based on Payment Terms)

(6) Share

Report

Posted on by Laszlo Toth

Hello,

I am writing to request your assistance with a configuration task in Dynamics 365 Business Central. My goal is to set the price of a product based on the payment terms assigned to a customer.

Description of the task:

When a customer purchases with 30-day payment terms, the price of a specific item should be X.
When the same customer purchases with 8-day payment terms, the price for the same item should be Y.
I have attempted to set up these prices on the "Customer Prices" page.
The Payment Terms Code column is not visible in the table, and I could not find an option to add it via the personalization feature. As a result, I am unable to set two different prices for the same item for the same customer.
How to configure the system on the customer card to ensure that different prices are applied for different payment terms when I make a Sales Order.

Thank you for the help

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (7)

Answers (1)

Mansi Soni 8,907 Super User 2025 Season 2 on at

Like (3)

Report

Moved the question from the Dynamics 365 General to the small and medium business forum.

Was this reply helpful? Yes No
Suggested answer

Mohana Yadav 60,993 Super User 2025 Season 2 on at

Like (2)

Report

Payment Terms Code is not available in Pricing tables to setup based on that.

you have to do customization to achieve this.

Are you using old pricing or new pricing model?

Was this reply helpful? Yes No
Suggested answer

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

Like (3)

Report

This can be achieved through customization.

Was this reply helpful? Yes No
Suggested answer

Sumit Singh 10,079 on at

Like (2)

Report
Limitation in Standard Functionality

Payment Terms Code is not available as a condition in the standard Sales Price or Customer Price tables,

You cannot personalize the Customer Prices page to add Payment Terms Code.

The new pricing experience (enabled via Feature Management) still does not support Payment Terms as a pricing condition.

Recommended Solution: Customization
To achieve your goal, you need to customize the pricing logic. Here's how:
Step-by-Step Customization Plan

Create a Custom Table:

Define a new table: Customer Payment Term Prices

Fields:

Customer No.

Item No.

Payment Terms Code

Unit Price

Starting Date / Ending Date (optional)

Modify Sales Line Pricing Logic:

Extend the Sales Line table or use an event subscriber on OnValidate of Unit Price.

Fetch the price from your custom table based on:

Customer No.

Item No.

Payment Terms Code (from the Sales Header)

Fallback Logic:

If no match is found in the custom table, fallback to standard pricing.

Optional UI Enhancements:

Add a FactBox or action on the Customer Card or Item Card to manage these custom prices.

Alternative Workaround (No Customization)
If you want to avoid development:

Create Customer Price Groups like NET30, NET08, etc.

Assign these groups manually based on Payment Terms on Sales order (i.e. transaction level).

Set prices per group.

This is manual and error-prone, especially if payment terms change frequently.
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
Suggested answer

DAnny3211 11,397 on at

Like (2)

Report
Hello,

Thank you for your question.

In Dynamics 365 Business Central, pricing is typically managed through Sales Price or Customer Price Group configurations, but unfortunately, Payment Terms Code is not a standard condition available in the pricing setup.

Suggested Approaches:

Custom Pricing Logic via Extensions
To achieve pricing based on Payment Terms, you may need to implement a custom extension. This would involve modifying the pricing logic to evaluate the customer's payment terms during sales order creation and apply the appropriate price accordingly.

Use Customer Price Groups or Discounts
As an alternative, consider assigning customers to different Price Groups or using Sales Line Discounts based on payment behavior. While this does not directly link to payment terms, it can be used to simulate tiered pricing.

Manual Price Selection
If the number of cases is limited, you could manually select the correct price or item variant during order entry, based on the payment terms.

Workflow or Validation Rule
You may also consider implementing a workflow or validation rule that prompts the user to adjust the price when a specific payment term is selected.

Unfortunately, without customization, Business Central does not support dynamic pricing based on payment terms out of the box.

Please verify if this response was helpful.
Best regards.

Was this reply helpful? Yes No
Verified answer

Sohail Ahmed 11,136 Super User 2025 Season 2 on at

Like (3)

Report

Business Central doesn’t support price differentiation based on Payment Terms out of the box in the standard price setup (e.g., Sales Prices or Sales Line Pricing). The Payment Terms Code field is not a condition in the pricing engine.

To achieve this:

👉 Option 1 – Customization: You'll need to customize the pricing logic to consider the Payment Terms Code when determining the price during Sales Order entry.

👉 Option 2 – Workaround:

Create two Customer Price Groups (e.g., “NET30” and “NET8”).

Assign the appropriate Customer Price Group to each customer depending on their payment term.

Use the Customer Price Group in the pricing setup instead of the actual payment terms.

This requires manual sync between Payment Terms and Price Group, but avoids customization.

✅ Mark this as the verified answer if helpful.

Was this reply helpful? Yes No
Suggested answer

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

Like (1)

Report

As several other experts have mentioned, this requires customization, so please contact your local partner to discuss your specific needs.
Or you can submit this suggestion to Microsoft.

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

Thanks.

ZHU

Was this reply helpful? Yes No