There’s a table that records all bills from suppliers.
There’s a table that records all payments to those suppliers.
Let’s say, generalizing, one payment is made after 12-13 bills are recorded.
A payment date can not necessarily share a bill date.
What I want is a ledger for bills and payments made out in a pdf.
I have done it up until now by making another table and using actions to send payments and bills as rows to that table. Generating a report is easy after that.
But I don’t want to use an extra table anymore if I can, because its making things slower.
Virtual columns can be a way - that I make VCs within the bills table to pull the payment record for that date. But the problem is there are payments on days where there are no bills. So in the report finally those records will be left out.
Can anybody help? My only aim is to get rid of the third table.