Reporting
My customer (finance manager) and I are looking for a query/report/method that would provide the following info:Supplier Name
Check #
Amount of Check
Invoice date
GL Account # that check was charged to
"We have to do a spreadsheet at the end of the Fiscal Year that contains all checks written from October 1st-30th of the new Fiscal Year. This is so we can do Journal Entries for all invoices that came in past the October 1st date, but should be moved back into the previous year's budget.
Right now, I am having to take all of the checks, go in and search by check number, and drill down until I get to the GL account charged. Then, all of this information has to be transferred to an Excel spreadsheet. This is very time-consuming and I am hoping there is some report out there that contains all of the needed information, but I have been unable to find it. "
Check #
Amount of Check
Invoice date
GL Account # that check was charged to
"We have to do a spreadsheet at the end of the Fiscal Year that contains all checks written from October 1st-30th of the new Fiscal Year. This is so we can do Journal Entries for all invoices that came in past the October 1st date, but should be moved back into the previous year's budget.
Right now, I am having to take all of the checks, go in and search by check number, and drill down until I get to the GL account charged. Then, all of this information has to be transferred to an Excel spreadsheet. This is very time-consuming and I am hoping there is some report out there that contains all of the needed information, but I have been unable to find it. "
0