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 237,807 Most Valuable Professional on at

Like (0)

Report

Trade agreements have From and To fields for this purpose.

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

Like (0)

Report

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

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

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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November 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

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

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

Featured topics

Product updates