DaveBarber
Active Member
We have a long running discrepancy between the VAT calculated on the R42565 Invoice print and sales update R42800. For example, an invoice has 2 lines on it and the tax rules are set up to calculate tax at detail level:
The total invoice amount on the invoice print R42565 is 46.53 as follows:
(Currency is pound sterling)
Line 1 - Net 35.00 VAT @ 17.5% = 6.125
Line 2 - Net 4.60 VAT @ 17.5% = 0.805
Total invoice value = 39.60 + 6.125 + 0.805 = 46.53
The total invoice amount on the sales update and in F0911 and F03B11 is 46.54 as has been calculated as follows:
Line 1 - Net 35.00 VAT @ 17.5% = 6.125 rounded to 6.13
Line 2 - Net 4.60 VAT @ 17.5% = 0.805 rounded to 0.81
Total invoice value = 39.60 + 6.13 + 0.81 = 46.54
Hence we are billing the customer a different amount than is being recorded on the ledger.
I am aware there is an ESU that addressed this problem ESU 23613 but this requires a base line of ESU JD16881 which the business is unprepared to take due to the impact.
Has anyone implemented a fix/knows of a way this can be fixed without applying the ESU?
OW XE SP22 on Oracle
The total invoice amount on the invoice print R42565 is 46.53 as follows:
(Currency is pound sterling)
Line 1 - Net 35.00 VAT @ 17.5% = 6.125
Line 2 - Net 4.60 VAT @ 17.5% = 0.805
Total invoice value = 39.60 + 6.125 + 0.805 = 46.53
The total invoice amount on the sales update and in F0911 and F03B11 is 46.54 as has been calculated as follows:
Line 1 - Net 35.00 VAT @ 17.5% = 6.125 rounded to 6.13
Line 2 - Net 4.60 VAT @ 17.5% = 0.805 rounded to 0.81
Total invoice value = 39.60 + 6.13 + 0.81 = 46.54
Hence we are billing the customer a different amount than is being recorded on the ledger.
I am aware there is an ESU that addressed this problem ESU 23613 but this requires a base line of ESU JD16881 which the business is unprepared to take due to the impact.
Has anyone implemented a fix/knows of a way this can be fixed without applying the ESU?
OW XE SP22 on Oracle