i have an invoice and transaction program i want to make for my company.
i have done the transaction tabel and would like to make report for every transaction based on date and the element such as casher or shop or bank account.
how can i make a report to have the depit and the credit shown and the total which substitute the depit from the credit.
it meens that my accountant needst to know after a day how many money came in the cashir and how many he spends from that money on a daily bases.
the fields in the transaction table is:
thanks for your support.