Rounding Issue with Calculate Withholding for AP
Have an issue with rounding when using Calculate Withholding (R04580).
The Calculate Withholding process calculates withholding for each pay item on each voucher.
Example:
- Amount Subject to Withholding Line 1 = 3364.50
- Amount Subject to Withholding Line 2 = 1409.11
- Amount Withheld Calculated at 5% for Line 1 = 168.23
- Amount Withheld Calculated at 5% for Line 2 = 70.46
- So, the total Amount Subject to Withholding for the voucher is 3364.50+1409.11 = 4773.61
- And the total Amount Withheld Calculated for the voucher is 168.23 + 70.46 = 238.69
- However, when you do the math at the total level (4773.61 * 5%), you get 238.68
We need to print a document to support the payment, showing the Total Amount Subject to Withholding and the Total Amount Withheld, but the math