Skip to main content

Notifications

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

Cash Applied report - where did it go

Posted on by 40

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.

  • Suggested answer
    Austin_Huber Profile Picture
    Austin_Huber 5 on at
    RE: Cash Applied report - where did it go

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Cash Applied report - where did it go

    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.

  • Liz McQuiston Profile Picture
    Liz McQuiston 40 on at
    RE: Cash Applied report - where did it go

    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.

  • Liz McQuiston Profile Picture
    Liz McQuiston 40 on at
    RE: Cash Applied report - where did it go

    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.

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 Season 2 on at
    RE: Cash Applied report - where did it go

    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.

    pastedimage1673568694931v2.png

    pastedimage1673568260911v1.png

    Hope this helps.

    Thanks.

    ZHU

  • Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Cash Applied report - where did it go

    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:

    pastedimage1673561093857v1.png

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Cash Applied report - where did it go

    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.

  • Liz McQuiston Profile Picture
    Liz McQuiston 40 on at
    RE: Cash Applied report - where did it go

    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.

  • Dallefeld Profile Picture
    Dallefeld 11,425 User Group Leader on at
    RE: Cash Applied report - where did it go

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

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans