web
You’re offline. This is a read only version of the page.
close
Skip to main content
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
    23 Moderator on at
    RE: Billing for a second item based on a percentage of the extended price of a first service item

    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
    RE: Billing for a second item based on a percentage of the extended price of a first service item

    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
    23 Moderator on at
    RE: Billing for a second item based on a percentage of the extended price of a first service item

    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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,122

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 918 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 646 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans