hello everyone!
my question is regarding general ledger i have student fee invoice table and student payment table if i want to make a ledger of invoice and payment transactions do i need a balance column in ledger table? should i use same amount field for invoice and payments? i want to show running totals or instead of this ledger table approach can i achieve this by any other method this is going to be very large database i need to consider speed and reliability as well please guide me to right direction
regards
my question is regarding general ledger i have student fee invoice table and student payment table if i want to make a ledger of invoice and payment transactions do i need a balance column in ledger table? should i use same amount field for invoice and payments? i want to show running totals or instead of this ledger table approach can i achieve this by any other method this is going to be very large database i need to consider speed and reliability as well please guide me to right direction
regards