Calculation Logic Examples 
Example 1: One document line certified to a financing source
In this example, we certify one expenditure line of one document:
Item |
Account |
D/C |
Amount |
Tax Code |
1 |
Exp1 |
D |
100 |
Tax1 |
2 |
Tax1 |
D |
16 |
|
3 |
Vendor1 |
C |
116 |
|
The expenditure line in the document is selected for certification if its account assignment derives an operation that is selected for the certification.
The next step is to calculate the net, gross, and eligible amounts for the line (in the certification currency):
Doc. Item |
Net Amount |
Gross Amount |
1 |
100 |
116 |
The eligible amount depends on the eligibility or non-eligibility of the tax:
● If the tax code has been included (in Customizing) in the list of eligible tax codes:
Doc. Item |
Net Amount |
Gross Amount |
Eligible |
1 |
100 |
116 |
116 |
● If the tax code has not been included (in Customizing) in the list of eligible tax codes:
Doc. Item |
Net Amount |
Gross Amount |
Eligible |
1 |
100 |
116 |
100 |
Now the document line is assigned to a financing source (to assign a document line to a financing source, it must also be assigned to all the financing sources with budget and a higher priority than it) that has an apportionment amount of 100%:
Doc. Item |
Eligible |
App. Amount |
Financing Source |
1 |
100 |
100 |
FS1 |
The previous certifications for the document line are read and previous certified amount and contribution is calculated:
Doc. Item |
Eligible |
App. Amount |
Financing Source |
Prev. Cert. |
Prev. Contr. |
1 |
100 |
100 |
FS1 |
60 |
48 |
The system also proposes a certified amount and contribution (certified amount times the contribution rate of the financing source) for the current certification:
Doc. Item |
Elig. |
App. Amt. |
F.S. |
Prev. Cert. |
Prev. Contr. |
Certif. |
Contr. |
1 |
100 |
100 |
FS1 |
60 |
48 |
40 |
32 |
Example 2 (One document line certified to two financing sources)
In this example, the calculation of the eligible amount is the same as in the previous example. However, the document line is assigned here to two financing sources, one of which has an apportionment amount of 20%:
Doc. Item |
Eligible |
App. Amount |
Financing Source |
1 |
100 |
100 |
FS1 |
1 |
100 |
20 |
FS2 |
The previous certifications are calculated (note that previous contributions are the same for all the financing sources in the certification but the previously certified amounts are different, depending on the usage of the financing source):
Doc. Item |
Eligible |
App. Amount |
Financing Source |
Prev. Cert. |
Prev. Contr. |
1 |
100 |
100 |
FS1 |
10 |
8 |
1 |
100 |
20 |
FS2 |
0 |
8 |
The system also proposes a certified amount and contribution for the current certification:
Doc. Item |
Elig. |
App. Amt. |
F.S. |
Prev. Cert. |
Prev. Contr. |
Certif. |
Contr. |
1 |
100 |
100 |
FS1 |
10 |
8 |
90 |
72 |
1 |
100 |
20 |
FS2 |
0 |
8 |
0 |
0 |
Later when maintaining the certification run, the user will be able to modify the certified amount.
Example 3 (Two document lines certified)
Now, we certify two lines of the following document:
Item |
Account |
D/C |
Amount |
Tax Code |
1 |
Exp1 |
D |
100 |
Tax1 |
2 |
Exp2 |
D |
50 |
Tax1 |
3 |
Exp3 |
D |
150 |
Tax2 |
4 |
Exp4 |
D |
150 |
Tax2 |
5 |
Tax1 |
D |
24 |
|
6 |
Tax2 |
D |
48 |
|
3 |
Vendor1 |
C |
522 |
|
We also assume that, out of the 522 to be paid to the vendor, 45 is the amount of withholding tax. The taxes are split among the different expenditure lines in the document:
Tax |
Total |
Line Item |
|||
1 |
2 |
3 |
4 |
||
Tax1 |
24 |
16 |
8 |
|
|
Tax2 |
48 |
|
|
24 |
24 |
W.Tax |
45 |
10 |
5 |
15 |
15 |
The gross and the net of the certified items are:
Doc. Item |
Net Amount |
Sales tax |
Withholding |
Gross Amount |
1 |
100 |
16 |
10 |
116 |
3 |
150 |
24 |
15 |
174 |
The eligible amount depends on the eligibility or non-eligibility of the tax (the sales tax is eligible if the tax code is included in the list of eligible sales taxes, and the withholding tax is eligible if the tax type and code have not been included in the list of excluded withholding taxes):
● If the sales taxes and the withholding tax are eligible:
Item |
Net Amt. |
Sales tax |
Withholding |
Gross Amt. |
Eligible |
1 |
100 |
16 |
10 |
116 |
116 |
3 |
150 |
24 |
15 |
174 |
174 |
● If the sales taxes are eligible and the withholding tax is not:
Item |
Net Amt. |
Sales tax |
Withholding |
Gross Amt. |
Eligible |
1 |
100 |
16 |
10 |
116 |
106 |
3 |
150 |
24 |
15 |
174 |
159 |
● If the sales taxes are not eligible and the withholding tax is eligible:
Item |
Net Amt. |
Sales tax |
Withholding |
Gross Amt. |
Eligible |
1 |
100 |
16 |
10 |
116 |
100 |
3 |
150 |
24 |
15 |
174 |
150 |
● If the sales taxes are not eligible and the withholding tax is not eligible:
Item |
Net Amt. |
Sales tax |
Withholding |
Gross Amt. |
Eligible |
1 |
100 |
16 |
10 |
116 |
90 |
3 |
150 |
24 |
15 |
174 |
135 |
The rest of the certification process is the same as in the previous examples.