Dynamics Community Forum Thread Details

How to round the tax total ..... system sum of tax of all line items not round

Hi,

Please find below screen-shots, Total tax is not rounding properly. Kindly check and provide a solution. We are using to nearest currency decimal, disable allow summary level tax edit option in company setup -> option window. to avoid for any user editing by mistake. but how to enable rounding option in tax total in GP. As mentioned in excel file total tax is 7226.328 so when round it should be 7226.33 but GP calculate 7226.32 - not rounding properly.

System sum all the tax of line items not round of the total tax. for example, line item price is 72263.28 and tax is 5%, so 72263.28 * 5 /100 = 3613.164 since we are using To nearest currency decimal digit in tax details maintenance window, system calculate line item tax 3613.16 and one more item with same price so total of tax is 3613.16 + 3613.16 = 7226.32 but if you calculate 3613.164 + 3613.164 = 7226.328 when round it should be 7226.33

Is there any option or setup for this or need to do any customization. Please let me know.