If you change the annual amount of the service contract or contract quote, you may need 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 line amount percentage contribution is calculated as follows: the contents of the Line Amount field is divided by the Calcd. Annual Amount field values on all contract lines.
The Line Amount field value is updated by adding to it the difference between the new and calculated annual amounts, which is multiplied by the line amount percentage contribution.
The contents in the Line Discount Amount, Line Discount % and
Profit fields are updated in relation to the new value in the Line
Discount Amount field in the following way:
Line Discount Amount = Line Value - Line Amount.
Line Discount % = Line Discount Amount / Line Value * 100.
Profit = Line Amount - Line Cost.
The steps 1 to 3 are repeated for each contract line.
There is no check mark in the Allow Unbalanced Amounts field in the service contract that contains three contract lines with such information:
|
|
Line Cost |
Line Value |
Line Discount % |
Line Discount Amount |
Line Amount |
Profit |
|
Item 1 |
15,00 |
17,00 |
3,00 |
0,51 |
16,49 |
1,49 |
|
Item 2 |
20,00 |
23,00 |
|
0,00 |
23,00 |
3,00 |
|
Item 3 |
24,00 |
27,00 |
3,00 |
0,81 |
26,19 |
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 16,49+23,00 + 26,19 = 65,68.
If you change the Annual Amount to 60, the following will happen: the program will calculate the profit percentage contributions for each contract line: for Item 1 - 16,49/(16,49+23+26,19) = 0,2510, for Item 2 - 23/(16,49+23+26,19) = 0,3502, Item 3 - 26,19/(16,49+23+26,19) = 0,3988. Then the Line Amount field value is updated on each contract line using the 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:
|
|
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 |
Automatic Distribution of the Annual Amount Difference
Changing the Annual Amount of the Service Contract
Manual Distribution of the Annual Amount Difference