web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

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

I have the same question (0)
  • Community Member Profile Picture
    on at

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

  • Community Member Profile Picture
    on at

    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?

  • Verified answer
    Ram Peru Profile Picture
    2,830 on at

    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.

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans