web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Implementing a dynamic fee for opportunities/quotes/orders

(0) ShareShare
ReportReport
Posted on by 7
Scenario: for all opportunities/quotes/orders, I need to add a couple of line items that are calculated based on subtotals from the Opportunity Line/Quote Line/Order Line fields.
 
1) I need to add percentage-based fee that's based on the Extended Total (pre-tax) for the entire opportunity/quote/order, then have that added before calculating total tax for the order
2) I need to add a rate-based transportation fee that's calculated using the combined extended amount for opportunity/quote/product lines with the subject set as /Transportation/
 
I'm using the /Subject/ field in products to group items on the generated documents for a table containing line items and autocalculated subtotals,  but I'd like to implement something in the Quote to Order process that adds in these mandatory fees automatically and auto calculates them.
 
What can you recommend to implement these?
I have the same question (0)
  • Suggested answer
    Dengliang Li Profile Picture
    Microsoft Employee on at
    Hi,
     
    There is no OOB feature that will achieve your goals, this needs to be achieved through customization.
    Do you mean the Extended Amount as the sum of the /Pre-Freight Amount/ field and the /Freight Amount/ field values?
     
    Do you want to add two fields to calculate the percentage-based fee and rate-based transportation fee?
    Then, ultimately, the value of the two additional fields will be added to the value of the /Total Amount/ field?
     
    Best Regards,
    Dengliang Li
     
  • SescoDev Profile Picture
    7 on at
    Dengliang Li,
     
    Thanks for replying; for one of the fees, I'd be using the pre-freight amount. My initial instinct is to add that as a calculated field based off the "detail amount" value. The trouble is, I'm unsure how to make sure that value gets passed to the "Total Value" or which tables I should customize to make that happen.

    For the second fee, it's essentially a freight charge based on the grouped extended price total for products sharing the "Transportation" value in the Subject field. Since the rate charged varies based on national fuel prices, ideally I'd need the rate calculated based on a lookup to a custom connector/virtual table. But I'm unsure what the best way in Dataverse is to add columns that can capture these calculated values then pass them to the "Total Price" fields.
     
    The 2nd example you posted looks exactly like how I'd want the front-end to look. Where would you recommend I start to make a similar customization to my forms?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 43 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans