Solved: BANK RECONCILIATION: Get data from different table... - Page 2

peterson · 05-22-2024 10:00 AM

Hello guys, I am making an app for a company, and I have the following tables:

1. Payments
2. Receipts
3. Bank wires

An in these tables I have a bank ref column. But I need to create a bank reconcilliation view, where I have the daily credits and debts. However this information is partied in those 3 tables and I need them to be something like:

I am thinking of how I can achieve that result, how I can join different data into one table

Help!

peterson

I found a way to do that.

I created a table with a column called DAY then I added 31 rows with number 1,2,3,4 so forth.
Then I created virtual a virtual column with a SUM(SELECT()) and I summed the entries that the DAY(Date) was equal to this row.day. I also used AND() to add other criteria. I also created a filter table and made it a DASHBOARD view.

I was thinking the whole day how I could achieve that lolol

View solution in original post

BANK RECONCILIATION: Get data from different tables and make a new table