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
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
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.
Hope this helps.
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?
Hi! do you mean posted it or is from cash trans to be clear at bank ? Thanks
André Arnaud de Cal...
292,907
Super User 2025 Season 1
Martin Dráb
231,777
Most Valuable Professional
nmaenpaa
101,156
Moderator