web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

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

(0) ShareShare
ReportReport
Posted on by 1,821

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.

tax123.png

tax124.png

tax125.png

*This post is locked for comments

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Dan Liebl Profile Picture

Dan Liebl 2

#2
Shravan Attelli Profile Picture

Shravan Attelli 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans