Finance | Project Operations, Human Resources, ...

sales price based on the total Sales order quantity

(1) Share

Report

Posted on by FaiqaK

Hi,

We have a scenario where we want to select sale price on SO line based on the total order quantity .

We have sales trade agreements in system, but for some customers we want this sale price should select price bracket based on the /Total Sales order Qty/ . In the example , you can see total SO quantity is 150 which means for both item system should consider price bracket which covers 150 quantity.

Is there any way to acheive this in D365 F&O ?


Item	From Qty	To Qty	Price
Product A	0.00	100.00	100 $
Product A	101.00	150.00	90 $
Product A	160.00		70 $
Product B	0.00	100.00	200 $
Product B	101.00	200.00	180 $
Product B	201.00		150 $

Sales Order
Item	Qty	Price
Product A	70.00	90.00
Product B	80.00	180.00

Thanks

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

Martin Dráb 238,769 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Trade agreements have From and To fields for this purpose.

Was this reply helpful? Yes No
CU13050204-0 4 on at

Like (0)

Report
Copy link

Link copied!

Consider using price activation dates on the price discounts or trade agreements to manage price changes over time.
You can test your setup by creating a test sales order and verifying the applied price based on the total order quantity.

Was this reply helpful? Yes No
CU13050204-0 4 on at

Like (0)

Report
Copy link

Link copied!

By implementing one of these methods, you can achieve your desired behavior where the sales price on a SO line is automatically selected based on the total order quantity in D365 F&O.

Was this reply helpful? Yes No
CU27060428-0 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much. This was exactly what I was looking for. I had a range of the number of products sold in a year and I had to calculate a list of how many items of said product were sold in which year. SUMIF was not enough but SUMIFS did the trick

Was this reply helpful? Yes No

Join the conversation

Community site session details

sales price based on the total Sales order quantity

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

sales price based on the total Sales order quantity

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2025 Community Spotlights

Congratulations to the February Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates