Hello, do we have the attached report in manager? If we dont have it how possible is it that we can have it as part of our reports?
you have combined two completely different reports.
one is the transactions and the other is unpaid invoices report.
the transactions report will only show the balance credit or debit of the customer/supplier while the unpaid invoices report will show the age of invoices that are due.
what is the practical use of the example you have shown since there is no guarantee that the customer pays or the supplier is paid on a bill-to-bill value basis? in such a case they would never know which invoices are overdue.
much as i agree with all you have said, our clients prefer statements in that format and i was hoping i could get some help in this regard, i want to assume that i may have to hire an HTML coder?
i do not think that would help as programming has nothing to do with this.
what you need is a custom report which can be generated with SQL queries but unfortunately the custom reports are still under development.
in the meantime why not issue two separate statements? or combine two pdf as one outside Manager?