Accounts Receivable

[Glenda Cox via AccessMonster.com]

I'm a newcomer to VBA but not Access. I need to set up accounts receivable and post payments to it and decrease the patient balances. Can anyone give me help?

 

[Ken Snell [MVP]]

Your request goes far beyond what you can expect to get from a newsgroup
exchange.

Posting fairly specific questions will get fairly specific answers.

Requests for broad help on designing an entire database process will at best
get you solicitations for how you can pay someone to help you, or at worst
get no reply at all.

If you can narrow down the question, I'm sure we can help you ....

--

Ken Snell
<MS ACCESS MVP>

I'm a newcomer to VBA but not Access. I need to set up accounts

receivable and post payments to it and decrease the patient balances. Can
anyone give me help?

 

[Eric Schittlipz]

I'm a newcomer to VBA but not Access. I need to set up accounts
receivable and post payments to it and decrease the patient balances. Can
anyone give me help?

If your situation is simple where you do not need to worry about
part-payment of bills, then this would not need any coding. You just have a
table of patients and a table of bills (invoices) with a PaidDate column.
You can then find out any balance by summing the un-paid invoices. However,
typically patients might issue part-payment so that there is no single paid
date and also a single payment could be made to cover multiple bills for
multiple patients. Furthermore, incoming payments may need to be
crossed-refernced to cheque numbers and invoice numbers - so pretty soon it
can get ugly.
Why not simply buy an off-the-shelf accounts package - it's all been done
before and they're pretty cheap compared to starting from scratch.

 

[Glenda Cox via AccessMonster.com]

Thanks for the input -