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

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

(2) 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

All responses (4)

Answers (0)

Suggested answer

Sumit Singh 496 on at

Like (0)

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

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.
Suggested answer

Khushbu Rajvi. 17,719 Super User 2025 Season 2 on at

Like (1)

Report

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

This can be achieved through customization.
Suggested answer

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

Like (0)

Report

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

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?
Mansi Soni 7,736 Super User 2025 Season 2 on at

Like (0)

Report

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

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