Skip to main content
Business Central forum
Suggested answer

Closing an entry with a Remaining Amount of 0.00

editSubscribe (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)

Categories:
  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 59,766 Super User 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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,714 Super User 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.

  • Elinna Profile Picture
    Elinna 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
    Inge M. Bruvik 32,714 Super User 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.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Sundar…

Industry experts answer burning questions directly from our amazing Community…

Enabling Copilot Case and Conversation…

Agents can easily recap an ongoing chat, transcribe a voice conversation…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 282,978 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,562 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans