Thank you AvriLaanemets. The transactions table looks neater than mine. I will try using your tables by adding data. I hope you could make the report easier also. The report (CHDJ-GF 101) is a required format by the Commission on Audit. My problem in the making of the report is that I must define the account code in the sundry account column first in order to return the corresponding amounts of that account code from the transactions. Check number 623827 contains the ff accounting entry
Account Code
1-03-05-030-P11,000.00(Debit)
1-01-02-010-P11,000.00(Credit)
1-01-01-010-P2,307.61(Debit)
5-02-16-010-P2,779.06(Debit)
5-02-16-030-P5,913.33(Debit)
1-03-05-030-P11,000.00(Credit)
When I enter check number 623827 in the report, the amount of 1-01-02-010 (E7) automatically appears through the sumifs formula. What is the formula that returns all the other accounts not found in Row 7 under the debit sundry and credit sundry columns. The rule is all accounts used that are not found in Row 7 should go under the sundry columns. Take note that the sundry columns have separate debit and credit account code and amounts. I hope I am making sense.
I like your idea of just entering a data into the report header resulting in a report formatted in a Check Disbursement Journal.