You can change the annual amount of the service contract or contract quote to correct the amount that will be invoiced annually.
If you change the annual amount of a service contract or contract quote, you may want to distribute the difference between its new and calculated ammual amounts on the contract lines. There are three ways to distribute amounts:
If you change the annual amount of the service contract or contract quote, you may want to distribute the difference between its new and calculated annual amounts on the contract lines. Even distribution is one of the automatic distribution methods that can help you spread equally the new and calculated annual amounts difference between line amounts on the contract lines. The following list of distribution procedure steps describe the main idea of this method:
The contents in the Line Discount Amount, Line Discount %, and Profit fields are updated with regard to the new value in the Line Amount field in the following way:
The steps are repeated for each contract line.
The Allow Unbalanced Amounts check box is not selected in the service contract that contains three contract lines with such information.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 30.00 | 40.00 | 0.00 | 0.00 | 40.00 | 10.00 |
Item 2 | 40.00 | 50.00 | 10.00 | 5.00 | 45.00 | 5.00 |
Item 3 | 50.00 | 70.00 | 10.00 | 7.00 | 63.00 | 13.00 |
The Annual Amount field value is equal to the contents of the Calcd. Annual Amount field, which is always set to the sum of the line amounts. In this case, it is equal to the following: 40 + 45 + 63 = 148.
If you change the Annual Amount to 139, the amount is calculated that should be added to each Line Amount field value. This amount is calculated by subtracting the Calcd. Annual Amount from the new Annual Amount field value and dividing the result by the number of the contract lines in the service contract. In this case, it will be equal to the following: (139 - 148) / 3 = -3. Then, the last calculated figure is added to each Line Amount field value and the Line Discount %, Line Discount Amount, and Profit field values are updated using the formulas in the procedure described above.
Finally, the contract lines will contain this data.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 30.00 | 40.00 | 7.50 | 3.00 | 37.00 | 7.00 |
Item 2 | 40.00 | 50.00 | 16.00 | 8.00 | 42.00 | 2.00 |
Item 3 | 50.00 | 70.00 | 14.29 | 10.00 | 60.00 | 10.00 |
If you change the annual amount of the service contract or contract quote, you may want to distribute the difference between its new and calculated annual amounts on the contract lines. Distribution Based on Line Amount is an automatic method that can help you spread the new and calculated annual amounts difference between the line amounts on the contract lines. This distribution will be performed proportionally to their line amount shares in the calculated annual amount. The following list of distribution procedure steps for each contract line describe the main idea of this method:
The contents in the Line Discount Amount, Line Discount %, and Profit fields are updated with regard to the new value in the Line Discount Amount field in the following way:
If you change the annual amount of the service contract or contract quote, you may want to distribute the difference between its new and calculated annual amounts on the contract lines. Distribution Based on Line Amount is an automatic method that can help you spread the new and calculated annual amounts difference between the line amounts on the contract lines. This distribution will be performed proportionally to their line amount shares in the calculated annual amount. The following list of distribution procedure steps for each contract line describe the main idea of this method:
The contents in the Line Discount Amount, Line Discount %, and Profit fields are updated with regard to the new value in the Line Discount Amount field in the following way:
The steps are repeated for each contract line.
The Allow Unbalanced Amounts check box is not selected in the service contract that contains three contract lines with such information.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 15.00 | 17.00 | 3.00 | 0.51 | 25.00 | 1.49 |
Item 2 | 20.00 | 23.00 | None | 0.00 | 55.10 | 3.00 |
Item 3 | 24.00 | 27.00 | 3.00 | 0.81 | 112.70 | 2.19 |
The Annual Amount field value is equal to the contents of the Calcd. Annual Amount field which is always set to the sum of the line amounts. In this case, it is equal to the following: 16.49 + 23.00 + 26.19 = 65.68.
If you change the Annual Amount to 60, the profit percentage contributions for each contract line is calculated:
The Line Amount field value is updated on each contract line using the following formula: Line Amount = Line Amount + difference between the new and calculated annual amounts * Percentage Contribution. After that, the Line Discount Amount, Line Discount %, and Profit field values are updated using the formulas described in the procedure above.
Finally, the contract lines will contain this data.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 15.00 | 17.00 | 11.41 | 1.94 | 15.06 | 0.06 |
Item 2 | 20.00 | 23.00 | 8.65 | 1.99 | 21.01 | 1.01 |
Item 3 | 24.00 | 27.00 | 11.37 | 3.07 | 23.93 | -0.07 |
The Allow Unbalanced Amounts check box is not selected in the service contract that contains three contract lines with such information.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 15.00 | 17.00 | 3.00 | 0.51 | 25.00 | 1.49 |
Item 2 | 20.00 | 23.00 | None | 0.00 | 55.10 | 3.00 |
Item 3 | 24.00 | 27.00 | 3.00 | 0.81 | 112.70 | 2.19 |
The Annual Amount field value is equal to the contents of the Calcd. Annual Amount field which is always set to the sum of the line amounts. In this case, it is equal to the following: 16.49 + 23.00 + 26.19 = 65.68.
If you change the Annual Amount to 60, the profit percentage contributions for each contract line is calculated:
The Line Amount field value is updated on each contract line using the following formula: Line Amount = Line Amount + difference between the new and calculated annual amounts * Percentage Contribution. After that, the Line Discount Amount, Line Discount %, and Profit field values are updated using the formulas described in the procedure above.
Finally, the contract lines will contain this data.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 15.00 | 17.00 | 11.41 | 1.94 | 15.06 | 0.06 |
Item 2 | 20.00 | 23.00 | 8.65 | 1.99 | 21.01 | 1.01 |
Item 3 | 24.00 | 27.00 | 11.37 | 3.07 | 23.93 | -0.07 |
If you change the annual amount of the service contract or contract quote, you may want to distribute the difference between its new and calculated annual amounts on the contract lines. Distribution Based on Profit is one of the automatic methods that can help you spread the new and calculated annual amounts difference between the line amounts on the contract lines. This distribution will be performed proportionally to their profit shares in the total contract or contract quote profit. The following list of distribution procedure steps for each contract line describe the main idea of this method:
The contents in the Line Discount Amount, Line Discount %, and Profit fields are updated with regard to the new value in the Line Amount field in the following way:
The Allow Unbalanced Amounts check box is not selected in the service contract that contains three contract lines with such information.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 20.00 | 25.00 | 0.00 | 0.00 | 25.00 | 5.00 |
Item 2 | 50.00 | 58.00 | 5.00 | 2.90 | 55.10 | 5.10 |
Item 3 | 100.00 | 115.00 | 2.00 | 2.30 | 112.70 | 12.70 |
The Annual Amount field value is equal to the contents of the Calcd. Annual Amount field, which is always set to the sum of the line amounts. In this case, it is equal to the following: 25.00 + 55.10 + 112.70 = 192.80.
If you change the Annual Amount to 180, the profit percentage contributions for each contract line are calculated:
The Line Amount field value is updated on each contract line using the following formula: Line Amount = Line Amount + difference between the new and calculated annual amounts * Percentage Contribution. After that, the Line Discount Amount, Line Discount %, and Profit field values are updated using the formulas in the step 3 of the procedure described above.
Finally, the contract lines will contain this data.
Item | Line Cost | Line Value | Line Discount % | Line Discount Amount | Line Amount | Profit |
---|---|---|---|---|---|---|
Item 1 | 20.00 | 25.00 | 11.24 | 2.81 | 22.19 | 2.19 |
Item 2 | 50.00 | 58.00 | 9.93 | 5.76 | 52.24 | 2.24 |
Item 3 | 100.00 | 115.00 | 8.20 | 9.43 | 105.57 | 5.57 |
How to: Create Service Contracts and Service Contract Quotes
Setting Up Service Management
© 2017 Microsoft. All rights reserved.