Skip to main content

Notifications

Announcements

No record found.

Business Central forum
Unanswered

Which table do I look into to see outstanding checks?

Posted on by 12
We do many of our reports in PowerBI. I would like to uncover the table which shows the outstanding checks.
 
Can someone point me to the right direction?
 
 
  • JK-10071551-0 Profile Picture
    JK-10071551-0 12 on at
    Which table do I look into to see outstanding checks?
    Thanks Valentin.
    You pointed me to the right table.
     
    There is a column called statementstatus, just look for open. The bank ledger entry will not tell you if it is a check though. So for that, I had to look it up from the CheckLedger table.
     
    Thank you all!
     
    Jeff
  • Valentin Castravet Profile Picture
    Valentin Castravet 7,399 Super User on at
    Which table do I look into to see outstanding checks?
    If you're looking for outstanding checks you issued from your bank account you can go to your bank account -> ledger entries. This is page 372. You can create a new web service based on this page and use it in power bi. But best practice would be to create a new API to use in your Power BI as APIs are faster than web services.  
     
     
  • JK-10071551-0 Profile Picture
    JK-10071551-0 12 on at
    Which table do I look into to see outstanding checks?
    Sorry, that link does not provide any additional information that I need.
  • YUN ZHU Profile Picture
    YUN ZHU 64,237 Super User on at
    Which table do I look into to see outstanding checks?
    Hi, Hopefully the following discussion can give you some hints.
     
    Thanks.
    ZHU
  • JK-10071551-0 Profile Picture
    JK-10071551-0 12 on at
    Which table do I look into to see outstanding checks?
    I had watched that too. Unfornately not. 
     
    I need the actual table so that I can pull it into PowerBI. 
     
     
  • gdrenteria Profile Picture
    gdrenteria 5,108 Super User on at
    Which table do I look into to see outstanding checks?
    Hi
    I hope this can help you and give you some hints. 
    BR
    GR

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans