Special Report (General)
I am trying to write a report, that when printed will look very much like our bank statement. Right now I have the bank rec function, but this is not overly helpful when there is an issue with balancing. For example, on a given day there would be one bank deposit of say $123,456.78. When I look at SQL-Ledger there is no such transaction. Instead I have several 100 transactions for the monthly payments from clients on outstanding invoices. This makes doing the bank rec very hard. To compound the issue, if a debit memo is applied at the time several invoices are being paid, everything works great until the bank rec, where SQL-Ledger has put in a deposit to the chequing account for the amount of the debit memo. Unfortunately, there is no corresponding deposit into the bank. And again if two debit memos are closed off in paying several invoices the issue gets even more complex.
So what I want to do is get all the AP / AR / GL transactions bundled together with the dollar mounts, debit or credit, any source information, and of course the date.
Question is, what tables would I best start looking at, and has anyone ever done anything like this before?
Gregory A. West
DB&W Systems Limited