Skip to main content

Notifications

Announcements

No record found.

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

Check Register by Dimension

Posted on by 761

What is the best way to get a check register that shows what payments were applied to what invoices and the accounts and dimensions those invoices were posted to?  I have tried the G/L Register and Vendor Ledger Details and have also used the API's to join data, but not a really easy task and still not getting exactly what I am looking for.  Any help is greatly appreciated just wondering what everyone else uses?

Thanks,

Tanya

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Check Register by Dimension

    You would need a custom report building for this. If the data can be modelled in raw form Power BI is a possible avenue. Find the pages that expose what you need and have them published as web services so you can pick them up in Power BI.

    If this doesn’t breed the desired results then an AL report is the other option

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans