I need to be able to run a report of any oustanding AP checks and then export that to Excel. Is there a report like that?
This Sage Knowledgebase article has a report design you can download: How do I print an outstanding checks report in Cash Management? (KB 34774)
In the AP-Inquiry-Cash Management menu, there is a Check Register inquiry. You select the bank where the checks were written and then use the Conditions button to add a condition where the Cleared Date is equal to nothing. Then you can use the Export to Excel button on the inquiry menu to send it to Excel.
I've attached a screenshot of everything.
thansk!!!
*Community Hub is the new name for Sage City