Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Rounding Figure for Am...
Microsoft Dynamics GP (Archived)

Rounding Figure for Amount in Total.

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi,

I am currently encounter this issue where the user has an Sales Tax Invoice with Functional Currency (RM), Originating Currency (USD), and the calculation sum up (Subtotal) RM922.88 + (GST) RM775.37 = (Total) RM1698.26. By right it should be showing RM1698.25. Obviously this is because of rounding amount and I will want to put RM0.01 in the Discount field, unfortunately I couldn't because there is an exchange rate between them (Exchange Rate: 4.000), if I were to put amount of $0.01 cent it will turns up to become RM 0.04 instead RM0.01. Is there anyone can help me with this ? Has anyone experience this before?

Thank you in advanced.

Vince

*This post is locked for comments

  • Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Rounding Figure for Amount in Total.

    Vince, be sure to post your findings, as I am sure that others will be interested in what you learn.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Rounding Figure for Amount in Total.

    Hi Bill,

    Thank for your replied, it is not possible to change it in the Tax Detail Window as in the user has restricted not to do any changes on the field, therefore I try it in the Discount line.  

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Rounding Figure for Amount in Total.

    Vince, is it possible to make the change in the TAX detail window?

    I have encountered a similar problem in our sales transactions - and we are not even doing MC transactions.  We are doing Canadian dollar only and we still have the rounding errors.

    We have found the follow

    The Tax is not calculated off the SUB total, but from each line item.

    We had a situation where the subtotal ( for example ) totalled 1,000.00 and the GST should be 50.00 and it appears at 50.20 and that is due the difference in the rounding of the tax at the item level.

    Sorry not to rant on your question.  

    I would try to make the change in the Tax Detail line and not in the Discount line.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans