Small and medium business | Business Central, N...

Cash Applied report - where did it go

(0) Share

Report

Posted on by Liz McQuiston

In previous versions of NAV/BC there was a cash applied report for customer payments. Now in BC SAAS 21.2 I can't find it anywhere, did they do away with that report? Did something replace it? It also seems that you can no longer see "applied" entries when looking at a customer ledger entries, there is only "Apply Entries" and "Unapply Entries", I liked being able to pick one line and seeing what was applied to it.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

Dallefeld 211 User Group Leader on at

Like (0)

Report

There is a report called Cash Application....maybe this is your report.

Was this reply helpful? Yes No
Liz McQuiston 40 on at

Like (0)

Report

Thats for vendor payments, I'm looking for the one for customer payments. If we get $200,000 in payments for multiple customers I used to be able to run that report to see how it was applied to each customer. Or run it for a range of dates for one customer if our balances didn't match so we could see where we applied payments differently.

Was this reply helpful? Yes No
Suggested answer

Dallefeld 211 User Group Leader on at

Like (0)

Report

OMG, Liz, I don't see it anywhere.

You might be able to use the Customer Account Detail report and apply filters based on document type=payment, posting date, document number. Be sure to toggle on the 'terms, applications, etc.' I'm just not sure if you can get the filters you need.

Was this reply helpful? Yes No
Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

I do not think there is a report showing it. But i guess you are aware that you can look it up from the customer ledger entry page:

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 95,329 Super User 2025 Season 2 on at

Like (0)

Report

Hi, All Accounts Receivable Reports and Analytics in Business Central are documented in the following website.

https://learn.microsoft.com/en-gb/dynamics365/business-central/receivables-reports

I think the closest one is probably report 211 - Customer - Payment Receipt.

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Liz McQuiston 40 on at

Like (0)

Report

Thank you yes I did find that eventually buried in the menu - but what I am looking for is a report that can be run after a deposit is made with multiple customer payments so I can see who paid and what they paid on one report, this process would require me to know who paid and go to each individual customer to see how its applied. Thanks, though.

Was this reply helpful? Yes No
Liz McQuiston 40 on at

Like (0)

Report

Thank you Yun that report is great again for one customer at a time. I'm looking for a report that will break down a deposit by customer and listing the application to invoices. Its sounding like I need to either create a custom report or ask MS to bring the original report back.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,105 Moderator on at

Like (0)

Report

Sounds like you will have to submit a product idea here:

experience.dynamics.com/.../

And hope they bring the old report back.

You can also ask your developer to grab the report from and older version and try to convert it.

Was this reply helpful? Yes No
Suggested answer

Austin_Huber 5 on at

Like (1)

Report

Open "Customers" > Go to a customer (just pick one, the report will be the same regardless) > Click "More options" > "Reports" > "Cash Applied".

You will have to add the "Journal Batch Name" Filter, and filter by the posting date. Should be good to go.

Was this reply helpful? Yes No