hi all
how make month balance for any selected month
beginning month balance ----- end month balance
i have data_tb which continue from data for many company with her monthly movements and credit or debit
credit it's meaning ( money deserved to our company )
debit --- payments or any discount to other company
my data more than 9000 record and for 9 months
i want to make query when select any company
like
EXCEL SHEET ATTACHED
company B---- 01/2021
02/2021
Attached example for company b in 01/2021 and 02/2021
regards
how make month balance for any selected month
beginning month balance ----- end month balance
i have data_tb which continue from data for many company with her monthly movements and credit or debit
credit it's meaning ( money deserved to our company )
debit --- payments or any discount to other company
my data more than 9000 record and for 9 months
i want to make query when select any company
like
EXCEL SHEET ATTACHED
company B---- 01/2021
DEBIT | CREDIT | |
beginning BLANCE 01/2021 | 0 | 0 |
ENDING MONTH BLANCE_01/2021 | 2650 | 0 |
TOTAL_INTEREST_01/2021 | 0 | 150 |
TOTAL_Monthly Subscription 01/2021 | 0 | 1200 |
TOTAL PAYMENT01/2021 | 4000 | 0 |
02/2021
DEBIT | CREDIT | |
beginning BLANCE 02/2021 ( IS ENDING MONTH BLANCE 01/2021) | 2650 | 0 |
ENDING MONTH BLANCE_02/2021 | 250 | 0 |
TOTAL_INTEREST_02/2021 | 0 | 150 |
TOTAL_Monthly Subscription02/2021 | 0 | 1500 |
TAOTAL_Tax | 0 | 100 |
TOTAL PAYMENT_02/2021 | 2000 | 0 |
Attached example for company b in 01/2021 and 02/2021
regards