The following series of SQL statement retrieve a record set for producing the receipts side of cash book for ModeII.
1. To find the total amount by which the cash account is debited. In order to ascertain the total amount by which every transaction cash account has been debited, the following SQL statement is formed.
This SQL statement gives the code and amount from which cash is received. This SQL statement is saved as Query Cl.
2. To generate the total of Receipt side. The following SQL Statement is formed.
This SQL statement is save as Query C2.
3. To find the record set which consist of account code, Name of account, credit amount and date. The following SQL statement is formed.
