Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics SL (Archived)

Report to show outstanding transactions

(0) ShareShare
ReportReport
Posted on by

Is there a column in the gltran table specifically for cleared/outstanding that I can use to run a report?

*This post is locked for comments

  • Verified answer
    Ram Peru Profile Picture
    2,830 on at
    RE: Report to show outstanding transactions

    Hello jbrizbee21,

    Yes. You’re correct. You can use the Bank Reconciliation screen (20.210.00). Also you can use the Bank Reconciliation (20.630.00) report which lists the transactions for a specific accounting period the statement balances, outstanding checks, electronic payments, and deposits, and adjusted statement balances of cash accounts. It also provides a comparison of the adjusted statement balances to the account balances maintained by the Cash Manager module.

    This reports displays the information which is similar to the Bank Reconciliation Screen. You can generate this report in both summary and detail report for specific period using start Date & End Date and specific Bank account & sub account.

    BR_5F00_Report2.png

    BR_5F00_Report2.png

    Hope this helps.

  • Community Member Profile Picture
    on at
    RE: Report to show outstanding transactions

    Looking for outstanding payroll and AP checks as of a certain period. I can go into the Bank Reconciliation Module (20.210.00) and load detail by outstanding or cleared and export to excel, but I'm wondering if I can just run a report to get these, instead of having to copy and paste out. Does that makes sense?

  • Community Member Profile Picture
    on at
    RE: Report to show outstanding transactions

    Hi! do you mean posted it or is from cash trans to be clear at bank ? Thanks

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,907 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,777 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans