What is the example of an even distribution

If you change the annual amount for the service contract or service contract quote, you may need to distribute the difference between the new and the calculated annual amount across the contract lines. Even distribution is one of the automatic distribution methods that can help you to evenly distribute the difference between the new and the calculated annual amount across the line amounts of the contract lines. This method is described below:

The steps are repeated for each line of the contract.

The field Not balanced Re. allow is not activated in the service contract if it contains three contract lines with the following data.

items Line cost price Line value Line discount% Line discount amount Line amount DB

article 1

30,00

40,00

0.00

0.00

40,00

10,00

Article 2

40,00

50.00

10,00

5.00

45.00

5.00

Article 3

50.00

70.00

10,00

7.00

63.00

13.00

The field To be billed (year) corresponds to the value of the field Calc. to be billed (year), which always corresponds to the sum of the line amounts. In this case it is equal to 40 + 45 + 63 = 148.

If you have the Amount to be billed (year) change to 139, the amount is calculated that goes to each field Line amount should be added. This amount is calculated by taking the difference from the new value To be billed (year) and the value Calc. to be billed (year) divided by the number of contract lines in the service contract. In this case it corresponds to (139 - 148) / 3 = -3. Then the last calculated number becomes the field Line amount added, and the fields Line discount%, Line discount amount and DB are updated using the formulas in the procedure above.

Finally, the contract lines will contain the following data.

items Line cost price Line value Line discount% Line discount amount Line amount DB

article 1

30,00

40,00

7.50

3.00

37.00

7.00

Article 2

40,00

50.00

16.00

8.00

42.00

2.00

Article 3

50.00

70.00

14.29

10,00

60.00

10,00

See also