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

Notifications

Announcements

No record found.

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)
  • Verified answer
    BillurSamdancioglu Profile Picture
    19,854 Most Valuable Professional on at

    Hi,

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

  • Verified answer
    André Arnaud de Calavon Profile Picture
    301,082 Super User 2025 Season 2 on at

    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.

  • WeepingAngel Profile Picture
    47 on at

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

  • BillurSamdancioglu Profile Picture
    19,854 Most Valuable Professional on at

    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 :)

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…

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

#1
Martin Dráb Profile Picture

Martin Dráb 503 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 278 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans