Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / sales price based on t...
Finance forum
Suggested answer

sales price based on the total Sales order quantity

Posted on by
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 ?
      
 ItemFrom QtyTo QtyPrice 
 Product A0.00100.00100 $ 
 Product A101.00150.0090   $ 
 Product A160.00 70   $ 
 Product B0.00100.00200 $ 
 Product B101.00200.00180 $ 
 Product B201.00 150 $ 
      
 Sales Order    
 ItemQtyPrice  
 Product A70.0090.00  
 Product B80.00180.00  
      
 
Thanks
Categories:
  • CU13050204-0 Profile Picture
    CU13050204-0 4 on at
    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 Profile Picture
    CU13050204-0 4 on at
    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 Profile Picture
    Martin Dráb 224,750 Super User on at
    sales price based on the total Sales order quantity
    Trade agreements have From and To fields for this purpose.

Helpful resources

Quick Links

Can you answer this forum question?

You could make someone's day!

Community Newsletter - May 2024

Kudos to our community stars!

Community Spotlight of the Month

Kudos to Mohamed Amine Mahmoudi!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 283,663 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 224,750 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,146

Featured topics

Product updates

Dynamics 365 release plans