J
Joe Cilinceon
What I have is a Storage Management program I've written over the last year.
It is a single user application on a single computer. It is up and running
with a front end/backend setup.I have a the following tables with the key
fields listed:
Tenant (CustNo) contains address, phones etc
Units (UnitNo) contains space size etc
Leases (LeaseID) is a text field generated by CustNo & UnitNo & Date Rented
(yyyymmdd)
Now every payment made and what it pays gets posted to a Ledger table that
has an Auto number called Transaction. Now there is a child table to this
called payment that list how it was paid. This is linked by the Transaction
# to the Ledger. This table allows for payments using several methods of
payment, such as check, cash, credit card etc. The Ledger table is tied to
the Leases table by the LedgerID.
This is how it works. Say a tenant comes in and pays the Current months rent
with a check. We post the payment which will generate a transaction and
payment record. The payment record contains the amount paid and how. It also
would have a check number or credit card approval code number. It will also
add the Paidthru date to the Ledger at this time.
Now it might be a couple of weeks before we know that a check was returned.
I would now have to go back and change the paid thru date. Remove the credit
from the account as well as add any fees that would have been accumulated in
addition to the NSF fee for the bounced check.
Now this is what I need help with. I would appreciate suggestions on a table
design/modification that would allow me to reverse a transaction. In
addition roll the PaidThru date back, give credit if say they paid with a
split payment such as check and cash.. I hope that is clear and I would be
happy to give more information if needed.
It is a single user application on a single computer. It is up and running
with a front end/backend setup.I have a the following tables with the key
fields listed:
Tenant (CustNo) contains address, phones etc
Units (UnitNo) contains space size etc
Leases (LeaseID) is a text field generated by CustNo & UnitNo & Date Rented
(yyyymmdd)
Now every payment made and what it pays gets posted to a Ledger table that
has an Auto number called Transaction. Now there is a child table to this
called payment that list how it was paid. This is linked by the Transaction
# to the Ledger. This table allows for payments using several methods of
payment, such as check, cash, credit card etc. The Ledger table is tied to
the Leases table by the LedgerID.
This is how it works. Say a tenant comes in and pays the Current months rent
with a check. We post the payment which will generate a transaction and
payment record. The payment record contains the amount paid and how. It also
would have a check number or credit card approval code number. It will also
add the Paidthru date to the Ledger at this time.
Now it might be a couple of weeks before we know that a check was returned.
I would now have to go back and change the paid thru date. Remove the credit
from the account as well as add any fees that would have been accumulated in
addition to the NSF fee for the bounced check.
Now this is what I need help with. I would appreciate suggestions on a table
design/modification that would allow me to reverse a transaction. In
addition roll the PaidThru date back, give credit if say they paid with a
split payment such as check and cash.. I hope that is clear and I would be
happy to give more information if needed.