Re: Allocating Payments to Charges

Thanks Steve,

I understand. I'm so glad I have somebody to talk to on this. Your
absolutely right, in designing this app I can't let my ability (or lack there
of) or dislikes to interfere with the process. If it has to be it has to be.

I've created many to many relationships before, I know how to add the
intermediate table and create the relationship. My problems arrise later
when I'm fighting with the code and forms.

Maybe I don't have the foresight but I can't think of a time when I would
need to know when which pmnt is associated with which charge, save for the
moment when I'm actually processing the payment. At which point I would use
a txtbox and code to "Apply Amount" to the AmntPaid field. When I print a
ledger I can run a query and organize the pmnts and charges by date, or can I.
..? Goes against what I learned in accounting, but as Rick mentioned
accounting is best left to commercial software available at Walmart.

As far as tblPaymentMethod... A tenant will pay their rent in very strange
ways. Most of the time it is with a check or money order for the exact
amount. I have one tenant who knows he can't save money. He gets paid twice
a month; with his second paycheck he purchases a money order for anywhere
from 50 to 150 bucks. He signs over his first paycheck and may or may not
cover the balance with cash and coin. I have some girls from France that
paid multiple months with travelers checks. I have a few students who pay
with a check from their parents. I have roomates that pay with two checks.
I have one guy who purchases a money order for the maximum amount of $500.00
and pays the rest in cash. If I can add notes about each different method
namely the checks, if they bounce reversing the payment is much simpler.

What do you think? Should I stick with manual labor..?

DM


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-tablesdbdesign/200507/1
.

Relevant Pages

  • Re: Hired friend to do work for client - he wants cash.
    ... works full time to do 16 hours of work for my client at $50/hr CASH. ... Could I pay him ... $600 by check and he would not have to report it? ... It doesn't matter if you deduct the amount paid to him or not, ...
    (misc.taxes)
  • Re: Fairtax: how does this math work out?
    ... > of working Americans will have more cash and the amount ... > they need to pay at the cash register for the NST. ... Keeping the state withholding intact, his net check jump up by $113.55 ...
    (misc.taxes)
  • Re: Cash Back Credit Cards
    ... They even know when your cash back refund is deposited into your ... account, and the amount, so they can be sure to fill their own ... Or do you carry large amounts of cash to pay for your ...
    (misc.consumers)
  • Re: Its time to put astop to The Todal and his lying antics
    ... You offered me a small amount of cash and I ... look I really dont give two flying fucks about the crackpots in this ... of which Im not to bothered to find out...this is about pay back. ...
    (uk.legal)
  • WTB S-Bend extensions for Aerobars alloy or carbon
    ... 22.2mm to fit 3T Ahero. ... Can pay by cash, check, Paypal, money order etc... ...
    (rec.bicycles.marketplace)