On Monday, May 1 at the beginning of class you need to hand in the answer to the Excercise that we did part of in class on 4/26.
Receipt Table
| Receipt# | Batch# | Date | Customer# | Invoice# | Check# | Amount | PostDt | GL Post Dt |
General Ledger
| Receipt# | General_Ledger_Account# | Amount |
Comments: (a) The Customer#
in the Cash_Receipt Table is necessary if the Invoice# was not indicated
on the remittance advice. (b) Since the debit will always be to cash, instead
of creating a General_Ledger_Distribution Table, the account number of
the account to credit could be included in the Cash_Receipts Table.
However, this would make it difficult to record two credits (e.g.,
to accounts receivable and sales discounts).