SQL-Ledger Homepage

SQL-Ledger User Forum

Forum index page

Log in | Register

Back to the forum
Board view  Mix view

Special Report (General)

posted by DavidJ(R), 16.08.2016, 08:03

Hi Gregory
We overcame most of these issues many years ago by learning to use SQL-L better.
Eg SQL-L bank reconciliation will "gather up" all transactions on same date with identical reference field, including identical nulls. Its a feature, not a bug. Makes it possible to pay multiple invoices for multiple customers all tallied up into a single deposit.
Most banks do that if you deposit a bundle of cheques in a single batch.
Same for payments to suppliers.
So use the reference field cleverly to distinguish your different transactions.
We have very lightly modified the code to make it look like a "Bank Statement" in our region, eg changed headings for "Withdrawal" and "Deposit".
Just cosmetic, not logic changes.
It works for us for many years.


Complete thread:

Back to the forum
Board view  Mix view
1024 Postings in 338 Threads, 377 registered users, 118 users online (0 registered, 118 guests)
SQL-Ledger User Forum | Admin contact
powered by my little forum