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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Billing for a second item based on a percentage of the extended price of a first service item

(0) ShareShare
ReportReport
Posted on by 50

I have a requirement for a method of billing for two related items:

The first Item is a service item with a unit price specified in a Trade Agreement as a tiered price.

The second Item is a related fee item which will always be shown as a quantity of 1 with a Unit price of 5% of the extended price of the first item.

Quantity         Item            Description                             Unit Price                Extended Price

10,001           A100      Copying / Fax Service                         20.00                      200,000.00

     1               A100        Admin Fee for Copy / Fax           10,000.00                        10,000.00

The second item can appear only on the Billing Schedule and/or Invoice. It doesn't have to be setup in inventory. The item number must be the same as the first Item which will be setup as a Service Item. The selling price of the second item must be a percentage of the Extended Price of the first Item. 

I am looking for suggestions on how to accomplish this. 

I have the same question (0)
  • Suggested answer
    nunomaia Profile Picture
    25 Moderator on at

    The only way that I see that is possible to get a near result without any customization is using BOM.

    Create a product with a bill of materials : 

    Line 1 - Quantity 1

    Line 2 - Quantity 0.05

    1. Create a Sales Order 

    2. Add BOM item and enter pretended quantity. For example : 100

    3. Explode BOM

  • MichaelPeck Profile Picture
    50 on at

    Using the sample data from my original post:

    Quantity         Item            Description                             Unit Price                Extended Price

    10,001           A100      Copying / Fax Service                         20.00                      200,000.00

        1               A100        Admin Fee for Copy / Fax           10,000.00                        10,000.00

    Follow on question:

    What is the setup required for the A100 Copying / Fax Service? This is currently identified as a Service Item. Will that be selectable in a BOM for a Kit Item?

    The second item must use the same Item ID: A100 but calculate a Unit Price of 5% of the Extended Price from the first line.

    Is there any special setup for the Kit Item?

  • nunomaia Profile Picture
    25 Moderator on at

    You can't control unit price, but you can control quantity 

    2 services with the same code "M0051". The last item is always 1/100 of base quantity.

    When you explode BOM in Sales Order it will maintain quantities.     

    pastedimage1673390240617v1.png

    To get the same result in unit price, I think only by a customization  

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 577 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans