ACCESS FEED: Re: [MS_AccessPros] Table Design:Receivables for Homeowners' Association

Sabtu, 26 Desember 2015

Re: [MS_AccessPros] Table Design:Receivables for Homeowners' Association

Thanks Crystal.

I think what I want is to use the UNITID and the OWNERID in the UNITS table to post to the TRANSACTIONS table. I could also put the HOA dues in a field in the UNITS table Since we have so few billable items (dues, late fees, services, fines) and dues are really the only standard, I don't think I need a separate table. Hmm.

---In MS_Access_Professionals@yahoogroups.com, <strive4peace2008@...> wrote :

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@... [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:
OwnerID
UnitID (If applicable)
Transaction Date
Transaction Description
Transaction Amount
Not particularly complex but have I missed anything?
How would you generate the annual dues charge?

Thanks