Hi Jan,
Perhaps a table called FeeTypes with autonumber FeeTypeID that correlates to the type of fee. Add Long Integer FeeTypeID with Default Value = null to the transaction table. Then Transaction Description would be extra notes, not the only notes.
Merry Christmas
warm regards,
crystal
~ have an awesome day ~°~ jingle bells, jingle bells ~°~
On 12/25/2015 3:11 AM, jan.hertzsch@gmail.com [MS_Access_Professionals] wrote:
I want to start recording receivables in my database. I have one table for Units (undeveloped lots or houses) and one for owners (Name, mailing address, etc). I only have about 300 units and 250 owners. At the moment, I have an "ownerID" field in the UNITS table. Annual HOA dues are about $400/unit and can be paid in two installments. Owners can also receive fines, late fees, and a variety of services performed fees. I do not need a double entry type bookkeeping system.
This is my first "transaction table" but my thoughts for fields are:
Not particularly complex but have I missed anything?
- OwnerID
- UnitID (If applicable)
- Transaction Date
- Transaction Description
- Transaction Amount
How would you generate the annual dues charge?
Thanks
__._,_.___
Posted by: crystal 8 <strive4peace2008@yahoo.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (2) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar