If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#10
|
|||
|
|||
Dance Classes
Having separate deposit tables makes determining the total of all deposits
as well as tracking deposits of class payments and deposits of non-class income separately very easy. TblBankAccount is necessary to link the two deposit systems. Steve "BruceM via AccessMonster.com" u54429@uwe wrote in message news:a41ca48e96636@uwe... Steve, I was thinking that a Deposit record is a single deposit event, or the filling out of a single deposit ticket, or however you want to look at it. That being the case, deposit type (cash or check) would be more appropriate to the deposit detail. I assume you would still have that table as described earlier, although you did not mention it in your latest post. The way I see it, payment information is recorded in the ClassPayment table, which also includes the payment type (check or cash). I think your idea of opening a recordset and appending check payments from ClassPayment to DepositDetail table is a good idea. It would be possible also to append other information such as FamilyID if necessary, but I wonder if there is a reason for recording that level of detail. In a paper-based system a person would make a payment, which would be recorded in the appropriate ledger. The payments would be entered onto a deposit slip, but I expect in most small business cases the deposit amount only is noted, not the source of the specific deposit line item. I don't know what business need would be served by going beyond that in an electronic system. My thinking was that to do most of the work of filling out the deposit ticket you could append to the DepositDetail table records of check payments as you suggested, then add all cash as a single detail line item, and any other checks would be input manually. A non-class deposit table may be more slicing and dicing than is necessary, but the OP may weigh in on that. Please don't think of this as a challenge to your entire idea. Rather, I am suggesting further considerations, including these points: A payment is made by the Family person, but may be for more than one student. Therefore, the payment record would be associated with the FamilyID, but each individual Student record would show that the payment was made. Payment for two students at once would presumably be a single check, and would be deposited as such, so any link with the Deposit record needs to be to the Family record. The Bank Account table may be a valid consideration, but if there is a single bank account it may add an unnecessary layer. A single deposit ticket for a single bank account should be able to accomodate deposits from all sources, unless there is a specific business need to separate class and non-class payments. Again, appending records to do most of the work, then inputting additional records manually, could be a good solution. Steve wrote: Nancy, Bruce keeps mentioning that deposits other than class payments are not handled by my proposed tables. He is correct but that was an intentional ommission. TblDeposit and TblDepositDetail are meant to only record deposits of class payments so you will always be able to just track class payments. If you want to include deposits from other sources, I suggest you need to revise TblDeposit and add more tables: TblBankAccount BankAccountID BankName BankAccountNumber Bank address fields TblDeposit DepositID BankAccountID DepositDate DepositType Check or Cash DepositCheckNum TblNonClassDeposit NonClassDepositID BankAccountID NonClassDepositDate NonClassDepositType Check or Cash NonClassDepositCheckNum TblNonClassDepositDetail NonClassDepositDetailID NonClassDepositID NonClassDepositDescription NonClassDepositAmount If you make these changes, you will be able to determine the total of all deposits as well as track deposit of class payments and deposit of non-class income separately. Steve, thank you for you detailed response. [quoted text clipped - 124 lines] Thank you in advanch so much. Nancy -- Message posted via http://www.accessmonster.com |
Thread Tools | |
Display Modes | |
|
|