Create a family member table with the billing id and an individual
member id. to change who gets billed all you have to do is change the
billing id via another billed location or by adding a new bill location.
or
list all patients in 1 table with a location id and a bill id which
would refer to an address table.
Gilbert Keller
On 5/29/2012 7:44 PM, William Stacy wrote:
I'm restructuring my billing system to become more flexible and
correct and would appreciate any suggestions/pointers from those more
skilled than I. My restructure is mostly due to two things. One,
I've always billed by family accounts, where one family member is
assigned as the account holder. The problem arises now and then that
a family member leaves the nest and either then has their own account,
or joins another family which has its own account.
The problem is with the old transactions of prior family members not
showing up in account lookbacks.
I know one popular way is to have everyone have their own accounts and
just split family payments into their individual parts. It's not
pretty, and requires more computing and more complex statements, but
it would solve the problem.
I've also been toying with handling it at the transaction line item
level, assigning a permanent bill-to person/entity at that level which
can also be used to handle 3rd party issues. Which is the other part
of this restructure.
TIA
Bill
--
William Stacy, O.D.
Please visit my website by clicking on :
http://www.folsomeye.net
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
