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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Ledger settlements - penny difference

(0) ShareShare
ReportReport
Posted on by 47

Hello,

Is there a way to use ledger settlements with the penny-difference amount automatically being posted to a separate account like with AP and AR, instead of having to match debit and credit amounts exactly down to the cent? There is a "Maximum penny difference" parameter in the GL parameters but this doesn't seem to have any effect on ledger settlements.

My parameter Maximum penny difference is set to 1 USD, and I have the setup under Accounts for automatic transactions for Penny difference in accounting currency but when I try to settle transactions with a 0,05 USD difference, I get the following message: The transactions marked for settlement do not balance. The balance amount is -0,05.

pastedimage1670855507872v1.png

We are on version 10.0.30.

Thank you,

Irma

I have the same question (0)
  • BillurSamdancioglu Profile Picture
    19,036 Most Valuable Professional on at
    RE: Ledger settlements - penny difference

    Actually this is a very common need and I did create an idea via idea portal as far as ı remember.

    Or voted one of them :)

  • WeepingAngel Profile Picture
    47 on at
    RE: Ledger settlements - penny difference

    Thanks to both of you. Not the answer I was hoping for  but an answer nonetheless.

  • Verified answer
    André Arnaud de Calavon Profile Picture
    298,815 Super User 2025 Season 2 on at
    RE: Ledger settlements - penny difference

    Hi WeepingAngel,

    Like Billur mentioned, this is not supported in this way. The ledger settlements do expect transactions that are fully balanced. You can manually post the difference in a journal. Then you can settle three transactions (debit, credit and the penny difference).

    You can also consider a customization to automate this process.

  • Verified answer
    BillurSamdancioglu Profile Picture
    19,036 Most Valuable Professional on at
    RE: Ledger settlements - penny difference

    Hi,

    As OOB functionality, there isn't a way to manage this process.

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…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,351

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 874 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 638 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans