Skip to main content

Notifications

Business Central forum
Answered

Clear Customer's balance.

Posted on by 125

Hi,

Since we are still not using the finance side of Business Central, but do have prices on our items, we accumulated a hefty back logs of Posted Sales invoice not paid over the last year.

I'm looking for a quick way to clear this back log without having to go in each PS-INV individually. We have thousands of these. Any quick guide to achieve this?



The invoicing is currently done in another software, and the prices in Dynamics are for reports and data. 

Thank you, 

  • Verified answer
    Simon P. Profile Picture
    Simon P. 125 on at
    RE: Clear Customer's balance.

    I was missing the balance account number. It is working now.

    Thank you,

  • Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Clear Customer's balance.

    Seems like you got an error again. Are you trying to clear credit memos only?

  • Simon P. Profile Picture
    Simon P. 125 on at
    RE: Clear Customer's balance.

    The reason why is because the selected documents were Credit Memo,


    I did another test with invoices this time.

    Error

    pastedimage1645126883101v1.png

    Cash Receipt Journal
    pastedimage1645126928711v2.png

    Thank you, 

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Clear Customer's balance.

    Payments to customers must be negative, simply change you amount to negative.

  • Simon P. Profile Picture
    Simon P. 125 on at
    RE: Clear Customer's balance.

    Hi,

    Thank you for the solution!

    I think I have made some progress, but I now receive this error when I try to post some entries.

    pastedimage1645120898888v2.png

    Cash Receipt Journals,
    pastedimage1645120884039v1.png

    Regards,

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 69,612 Super User 2024 Season 2 on at
    RE: Clear Customer's balance.

    Hi, you can create a payment first, then go to Customer Ledger Entries, select the payment line, choose Apply Entries.

    In this page, you can apply multiple invoices at the same time.

    pastedimage1645061052995v1.png

    pastedimage1645061089813v2.png

    Hope this will help.

    Thanks.

    ZHU

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Clear Customer's balance.

    I can give you a suggestion for stopping the unpaid issue. Create a payment method that has a general ledger account (I would set to the AR account in your case) and apply that payment method to all customers. When a sales invoice posts, your will credit sales, debit AR, credit AR and Debit AR--the last two entries coming from the payment method....it auto pays the invoices.

    To clear the unpaids, you will need to go to each customer but not each invoice. In a Cash Receipts Journal, create a journal line for your customer, leave amount blank. Use the Process option and Apply Entries, which will give you the following screen:

    pastedimage1645049510743v1.png

    Use the select more feature

    pastedimage1645049562948v2.png

    highlight the radio button just to the right of the applies-to id field, this will select all invoices at one time.

    pastedimage1645049627543v3.png

    When you press ok, the system will return the total of all the invoices to the journal line.

    Repeat for all customers and choose your offsetting general ledger account to balance the journal and then post.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans