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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Payment Journal & ...
Microsoft Dynamics NAV (Archived)

Payment Journal & Purchase Journal Amount Rounding

(0) ShareShare
ReportReport
Posted on by Chamu Matumbura 117

We recently did a test upgrade for a customer of ours from NAV 3.7W1 to NAV 2015W1.   When they were testing they discovered that when you put in an amount in either a Purchase Journal or the Payment Journal the system is rounding the decimal part.  Eg, if one put an amount of 453.47 the moment you leave the Amount field the value in there becomes 453.00.  If the amount is say 453.63 the system will round up and the value is changed to 454.00 the moment you leave the Amount field.

I have checked the amount rounding values in the G/L Setup window and the G/L Setup table and the rounding is set to 0.01.

Is there anywhere else I need to look for me to be able to capture the correct amount and not the rounded off one.

Thanks in advance to those who can help.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    RobertasR Profile Picture
    RobertasR 5,004 on at

    Hi Chamu,

    if you've checked the General Ledger Setup table (as the field 'Amount Rounding Precision' is hidden on the page), is there any chance this is foreign currency payment that is rounded? If so, please check the same field 'Amount Rounding Precision' on the Currencies page for the given currency.

    Hope that helps.

    Robertas

  • Verified answer
    Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 3,049 User Group Leader on at

    You may check that the transactions you enter in purchase or payment journal made with foreign currency.

    If so you have to go to the same currency that make in the transaction, and check the "Amount Rounding Precision" on the currency.

    if you find this answer helpful, you can Click Yes to share with other people as Verified Answer.

    Thanks

  • Suggested answer
    Chamu Matumbura Profile Picture
    Chamu Matumbura 117 on at

    Thanks Robertas, this helped a lot.  I am now sorted.

  • Chamu Matumbura Profile Picture
    Chamu Matumbura 117 on at

    Thanks Ahmed.  That did the trick.

  • Ahmed Mohamed Rafik Profile Picture
    Ahmed Mohamed Rafik 3,049 User Group Leader on at

    You are welcome.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans