Answered

Clear Customer's balance.

(0) Share

Report

Posted on by Simon P.

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,

Categories:

Financial Management

Other

All responses (7)

Answers (1)

Verified answer

Simon P. 125 on at

Like (1)

Report

RE: Clear Customer's balance.

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

Thank you,
Dallefeld 11,423 User Group Leader on at

Like (0)

Report

RE: Clear Customer's balance.

Seems like you got an error again. Are you trying to clear credit memos only?
Simon P. 125 on at

Like (0)

Report

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

Cash Receipt Journal

Thank you,
Suggested answer

Dallefeld 11,423 User Group Leader on at

Like (0)

Report

RE: Clear Customer's balance.

Payments to customers must be negative, simply change you amount to negative.
Simon P. 125 on at

Like (0)

Report

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.

Cash Receipt Journals,

Regards,
Suggested answer

YUN ZHU 69,612 Super User 2024 Season 2 on at

Like (1)

Report

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.

Hope this will help.

Thanks.

ZHU
Suggested answer

Dallefeld 11,423 User Group Leader on at

Like (1)

Report

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:

Use the select more feature

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

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.