Dynamics Community Forum Thread Details

Hello John,

You've hit upon a known limitation and a common point of frustration when using Field Service Agreement Invoice Products with volume discounts.

The Issue: Agreement Invoice Products and Volume Discounts

Agreement Invoice Products Do Not Directly Support Volume Discounts:
- You are correct. The Agreement Invoice Product entity in Dynamics 365 Field Service does not inherently support the application of volume discounts in the same way that Opportunity Products or Quote Products do.
- The design of Agreement Invoice Products focuses on recurring billing based on predefined prices, rather than dynamic discounts based on quantity.

Invoice Generation:
- When Field Service Agreement Invoices are generated, the prices are typically pulled directly from the Agreement Invoice Product records.
- Volume discounts, which are calculated based on quantity, are not factored into this process.

Backend Tables:
- As you've observed, the underlying data model for Agreement Invoice Products doesn't include the necessary fields or relationships to support volume discount calculations.

Expected Behavior:

Yes, this is generally expected behavior. The standard functionality of Agreement Invoice Products does not include volume discount application.

Workarounds and Solutions:

Manual Discount Application (Less Ideal):
- After the invoice is generated, you could manually adjust the line item prices to reflect the volume discount.
- However, this is not ideal for automation and can lead to errors.
- Also, as you have stated, you cannot override the prices on the invoice.

Custom Development (Recommended):
- Custom Plugin or Workflow:
  - Develop a custom plugin or workflow that triggers when an invoice is generated from an agreement.
  - The plugin/workflow would:
  - - Retrieve the quantity from the Agreement Invoice Product.
    - Retrieve the relevant volume discount from the product's price list or a custom entity.
    - Calculate the discounted price.
    - Update the invoice line item with the discounted price.
- Custom Entity for Agreement Invoice Prices:
  - Create a custom entity that stores agreement invoice prices, and includes a lookup to the agreement invoice product.
  - Within this custom entity, add fields to store the discounted price, based on the quantity.
  - Then create a plugin, or flow, that when the invoice is generated, it pulls the price from the custom entity.
- Advantages:
  - Provides a fully automated and accurate solution.
  - Allows you to display the correct discounted prices on the invoice.
- Considerations:
  - Requires development skills.
  - Adds complexity to your solution.

Adjust Agreement Invoice Product Prices (If Feasible):
- If the volume discounts are relatively consistent, you could calculate the discounted prices in advance and enter them directly into the Agreement Invoice Product records.
- This is not a good solution if the discounts change often.
- Disadvantages:
  - Not dynamic.
  - Requires manual calculations.
  - Not ideal for various discount structures.

Reporting:
- If changing the invoice itself is not an option, create a report that shows the agreement invoice products, the quantities, the discounts that should have been applied, and the final price.
- This will allow you to show the correct discount information, without changing the invoice.

Key Recommendation:

Custom development (plugin or workflow) is the most robust and scalable solution. It allows you to automate the volume discount calculation and ensure accurate invoice pricing.

By implementing a custom solution, you can overcome the limitations of Agreement Invoice Products and accurately reflect volume discounts on your Field Service Agreement Invoices.

If my answer was helpful, please click Like, and if it solved your problem, please mark it as verified to help other community members find more. If you have further questions, please feel free to contact me.

My response was crafted with AI assistance and tailored to provide detailed and actionable guidance for your Microsoft Dynamics 365 query.

Regards,

Daivat Vartak

Community site session details

Can volume discounts be applied to Field Service Agreement Invoice Setup Products?

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

Featured topics

Product updates