This is not what I am looking for. I think I can view transaction by simply applying filter. I want to automatically fetch all transactions of particular scheme with all details such as invoice amount, date, taxes etc in relevant columns upon selecting account #. I must use given format (on ContractLedger sheet) for calculation of remaining balance.
|