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,
I was missing the balance account number. It is working now.
Thank you,
Seems like you got an error again. Are you trying to clear credit memos only?
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,
Payments to customers must be negative, simply change you amount to negative.
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,
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148