A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Questions On a Payment Ledger



 
 
Thread Tools Display Modes
  #1  
Old October 27th, 2005, 07:47 PM
Joe Cilinceon
external usenet poster
 
Posts: n/a
Default Questions On a Payment Ledger

I'm looking for some suggestions how the best way to layout these tables or
if what I have below is effective.

First thing is each payment will tie to the account by a unique LedgerID and
will have a unique Transaction number (auto number).
This is what I have to have in these tables.
Date of Payment
Payment methods (can be multiple payment methods such as check, cash, credit
card)
What it payment pays such as Rent, Late Fee, Overpayment (credit).
What the Rent span pays for such as 1/1/05 thru 1/31/05.
Also need a method to reverse a payment due to a bad check or credit card
reversal.

What I have now is 3 tables for all this.
Ledger (main table) 1 record per transaction
Transaction
LedgerID
RentRate (amount owed for months rent for this payment)
PaymentDate
PaidFrom
PaidThru
-- From here on what it pays with a field for each. (Here is where I'm
thinking of adding another table to this design).
Rent
AdmFee
Lock
LateFee.......etc

Payment - 1 or more records with same transaction number depending on a
single payment method or several.
Transaction
Amount
Method (1 for cash, 2 for check etc)
Tracking (check number or credit card approval code)

NSFChecks - 1 record per transaction (I'm thinking of possibly adding this
data to the Ledger table listed above with perhaps a Reversal flag for
reversed payments. This flag would be necessary to stop it from adding the
amounts as collected.
Transaction
Amount
Tracking
Rev Date (date reversed payment)
Paid (Yes/No check box)


I was thinking of having a table that would have
Transaction - again can be only 1 or several depending on if it pays a
single item or many.
PaymentID (code such as 1 for rent, 2 for late fee and on)

Any help would be appreciated
--

Joe Cilinceon



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
make one field negative depending on selection in another field dk New Users 4 July 28th, 2004 10:32 PM
FAQ - frequently asked questions - Please read before posting - unofficial - July post Charles Kenyon New Users 1 July 12th, 2004 03:39 PM
FAQ - frequently asked questions - please read before posting - June posting unofficial Charles Kenyon Formatting Long Documents 4 June 28th, 2004 02:57 PM
FAQ - Frequently Asked Questions - unofficial - please read before posting - May Charles Kenyon Mailmerge 3 May 24th, 2004 05:54 PM
FAQ - Frequently Asked Questions - unofficial - please read before posting - April Charles Kenyon Mailmerge 0 April 26th, 2004 03:33 PM


All times are GMT +1. The time now is 02:09 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.