Take Home Exercise #7

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.

Answer to E.8.3.1

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).