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 :
Small and medium business | Business Central, N...
Suggested Answer

Closing an entry with a Remaining Amount of 0.00

(0) ShareShare
ReportReport
Posted on by 15

Thank you for reading my questions.

I have entries in my Customer Ledger which have a remaining amount of $0.00 but they are still open.

pastedimage1656637299279v1.png

I filtered on this value and I found that the 'amount' is actual -0.002

pastedimage1656637418427v2.png

I would like to close this entry so that it doesn't appear as an open entry in my ledger. 

I tried Payment Registration, Apply Entries, Cash Receipting but the problem I kept facing is that only 2 decimal places were allowed or couldn't post a 0.00 entry.

Please help!

Is there a way I can force close an entry? (ie change Open from Yes to No)

I have the same question (0)
  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,105 Moderator on at
    RE: Closing an entry with a Remaining Amount of 0.00

    Is this a transaction involving currency? If that is the case then you can have  a remaining amount in LCY even though your remaining amount in currency is zero. So that is the first thing you should check.

  • Elinna Profile Picture
    15 on at
    RE: Closing an entry with a Remaining Amount of 0.00

    Thanks for your response. Do you mean as a foreign currency? Then, no... there's nothing else involved.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    1,105 Moderator on at
    RE: Closing an entry with a Remaining Amount of 0.00

    Then you will have to post a transaction that you can apply it against.

    But you are unable to post a transaction of 0,002 to apply it against?

    There is no way you can force it to be closed with out potentially damage the integrity of the system.

  • Suggested answer
    YUN ZHU Profile Picture
    95,305 Super User 2025 Season 2 on at
    RE: Closing an entry with a Remaining Amount of 0.00

    Hi, will using Reverse also report an error?

    pastedimage1656891769973v1.png

    pastedimage1656891779102v2.png

    pastedimage1656891792415v3.png

    And with a small customization, it can be force closed, but this will destroy data integrity.

    Hope this helps.

    Thanks.

    ZHU

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 > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,377

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,696 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,512 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans