Update Tax Reconciliation Repository
When you run the Update Tax Reconciliation Repository program, the system performs for each pay item:
Locates the first record in table F0018 that is not processed (PROCFL field is not 1):
Invoice 11223, RI, 001, G10, V
Locates the corresponding F0911 records based on the key fields (document number, document type, document company, GL date, tax rate/area, tax explanation code, and tax item number).
3.5010 (1,600)
3.5020 (1,400)
3.5040 (1,000)
Sums the amount of the records, and then calculates each percent of the total amount per account for the tax rate/area.
G10
1,600 + 1,400 + 1,000 = 4,000
(1,600 / 4,000) x 100 = 40 percent (1,400 / 4,000) x 100 = 35 percent (1,000 / 4,000) x 100 = 25 percent
Note: The system performs soft rounding for these calculations.Multiplies the percent by the tax amount to determine the tax amount per account.
Pay Item 001 - G10
.40 x 100 = 40.35 x 100 = 35.25 x 100 = 25
Note: The system performs soft rounding for these calculations.Updates the F0018R table.
This table displays the resulting records in the F0018R table:
Doc Number
Doc Type
Pay Item
Account
Journal Entry Line
Amount
Tax Amount
Tax Rate Area
Tax Expl. Code
11223
RI
001
3.5010
1.0
1,600
40
G10
V
11223
RI
001
3.5020
2.0
1,400
35
G10
V
11223
RI
001
3.5040
3.0
1,000
25
G10
V
Updates the Processed Flag field (PROCFL) to P on the F0018 record.
This table displays the resulting records in the F0018 table.
Doc Number
Doc Type
Pay Item
Taxable Amount
Tax Amount
Tax Rate Area
Tax Expl. Code
Processed Flag
11223
RI
001
1,000
100
G10
V
P
11223
RI
002
2,000
400
G20
V
.
11223
RI
003
3,000
300
G10
V
.
Locates the second record in table F0018 that is not processed: Invoice 11223, RI, 002, G20, V.
Locates the corresponding F0911 records:
3.5030 (1,500)
3.5010 (500)
Sums the amount of the records, and then calculates each percent of the total amount per account for the tax rate/area.
G20
1,500 + 500 = 1,500
(1,500 / 2,000) x 100 = 75 percent (500 / 2,000) x 100 = 25 percent
Multiplies the percent by the tax amount to determine the tax amount per account.
Pay Item 002 - G20
.75 x 400 = 300.25 x 400 = 100
Updates table F0018R.
This table displays the resulting records in the F0018R table:
Doc Number
Doc Type
Pay Item
Account
Journal Entry Line
Amount
Tax Amount
Tax Rate Area
Tax Expl. Code
11223
RI
001
3.5010
1.0
1,600
40
G10
V
11223
RI
001
3.5020
2.0
1,400
35
G10
V
11223
RI
001
3.5040
3.0
1,000
25
G10
V
11223
RI
002
3.5030
1.0
1,600
300
G20
V
11223
RI
002
3.5010
2.0
500
100
G20
V
Updates the Processed Flag field (PROCFL) to P on the F0018 record.
This table displays the resulting records in the F0018 table:
Doc Number
Doc Type
Pay Item
Taxable Amount
Tax Amount
Tax Rate Area
Tax Expl. Code
Processed Flag
11223
RI
001
1,000
100
G10
V
P
11223
RI
002
2,000
400
G20
V
P
11223
RI
003
3,000
300
G10
V
.
Locates the third record in table F0018 that is not processed:
Invoice 11223, RI, 003, G10, V.
Locates the corresponding F0911 records:
3.5010 (1,600)
3.5020 (1,400)
3.5040 (1,000)
Because the first and third pay items have the same tax rate/area and tax explanation code, the relative percentages will be the same. For performance purposes the system does not recalculate them.
G10
1,600 + 1,400 + 1,000 = 4,000
(1,600 / 4,000) x 100 = 40 percent (1,400 / 4,000) x 100 = 35 percent (1,000 / 4,000) x 100 = 25 percent
Multiplies the percent by the tax amount to determine the tax amount per account.
Pay Item 003 - G10
.40 x 300 = 120.35 x 300 = 105.25 x 300 = 75
Updates table F0018R.
This table displays the resulting records in the F0018R table:
Doc Number
Doc Type
Pay Item
Account
Journal Entry Line
Amount
Tax Amount
Tax Rate Area
Tax Expl. Code
11223
RI
001
3.5010
1.0
1,600
40
G10
V
11223
RI
001
3.5020
2.0
1,400
35
G10
V
11223
RI
001
3.5040
3.0
1,000
25
G10
V
11223
RI
002
3.5030
4.0
1,500
300
G20
V
11223
RI
002
3.5010
5.0
500
100
G20
V
11223
RI
003
3.5010
6.0
1,600
120
G10
V
11223
RI
003
3.5020
7.0
1,400
105
G10
V
11223
RI
003
3.5040
8.0
1,000
75
G10
V
Updates the Processed Flag field (PROCFL) to P on the F0018 record.
This table displays the resulting records in the F0018 table:
Doc
Number
Doc
Type
Pay
Item
Taxable
Amount
Tax
Amount
Tax
Rate Area
Tax Expl.
Code
Processed
Flag
11223
RI
001
1,000
100
G10
V
P
11223
RI
002
2,000
400
G20
V
P
11223
RI
003
3,000
300
G10
V
P