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






__._,_.___

Posted by: jan.hertzsch@gmail.com
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar