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

All responses (4)

Answers (0)

CU27060428-0 2 on at

Like (0)

Report

sales price based on the total Sales order quantity

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
CU13050204-0 4 on at

Like (0)

Report

sales price based on the total Sales order quantity

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.
CU13050204-0 4 on at

Like (0)

Report

sales price based on the total Sales order quantity

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

Martin Dráb 229,275 Most Valuable Professional on at

Like (0)

Report

sales price based on the total Sales order quantity

Trade agreements have From and To fields for this purpose.