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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Bank Transaction does ...
Microsoft Dynamics GP (Archived)

Bank Transaction does not post to general ledger due to currency rounding results in zero values

(0) ShareShare
ReportReport
Posted on by Mahmoud Shafiey 805

Dear All,

Wish you are all fine.

I have a strange case when posting bank transactions in very small amounts in EGP currency and the functional is US dollar it results in zero values in dollar.

As shown in the following example the transaction amount is 0.02 EGP , the exchange rate is 8.88 so it results in 0.00 in functional currency (US Dollar) and it posts nothing to the general ledger.
The transaction is to record the bank admin fees.
What can I do regarding this issue

BankTrx.png 

Waiting for your recommendations and thank you very much.

*This post is locked for comments

I have the same question (0)
  • L Vail Profile Picture
    L Vail 65,271 on at

    What amount do you think it ought to be posting? If you increase the number of decimal places in your currency, does that make any difference?

  • Mahmoud Shafiey Profile Picture
    Mahmoud Shafiey 805 on at

    @leslie Thank you very much for your reply.

    In the mentioned example it should post 0.00225 or at least post an entry with zero amounts.

    I have tried larger amounts and it is working fine.

    As for increasing the number of decimal places I did not try this solution, I will try Increasing the decimals and get back to you but does it affect any other thing in the system?

    Thank you.

  • L Vail Profile Picture
    L Vail 65,271 on at

    Yes,

    Changing the decimal places will impact many, many areas. If you increase the number of decimals, your dollar fields for that currency will increase. If you are going to try this, please DO NOT try it on your production installation. If you decide to go this way, be sure to back up everything before the change.

  • Mahmoud Shafiey Profile Picture
    Mahmoud Shafiey 805 on at

    Thank you very much , of course I will try it on a test environment and I will back up my live environment in case I will apply this solution in it.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
talty09 Profile Picture

talty09 2

#1
Anthony Beatty Profile Picture

Anthony Beatty 2

#3
CP04-islander Profile Picture

CP04-islander 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans