Page 1 of 1

Receivables Database Questions and Comments Needed

Posted: Wed Jun 02, 2004 8:42 pm
by recsx
Hi, All

I have been working on a client system for the past 3 weeks now and i'm neer completion except for one thing, the RECEIVABLES.

Does anyone have suggestions on how it should be constructed i.e. laydout.

MORE:
I have about 100 and will expect neer the thousands of clients once i'm done
and all of these clients need to pay for the service every month.

I have my database already made with test clients in it now i can enter them edit them and delete them, but i am now up to the receivables and have no clue on an efficient way of going in every month and posting who has paid? who has not and if paid how much of what ammount?

whats a good account methode?

Thanks in advanced.

Posted: Wed Jun 02, 2004 8:57 pm
by McGruff
It might help if you explian what "receivables" are.

Posted: Wed Jun 02, 2004 9:01 pm
by recsx
McGruff wrote:It might help if you explian what "receivables" are.
LOL hmm.

Receivables! money owing to you, people owe you money gatta collect.

Posted: Wed Jun 02, 2004 9:08 pm
by tim
store a timestamp of the payment, run a comparsion to the stored timestamp to an interval (30 days or whatever u want them to pay)

hmm?

Posted: Wed Jun 02, 2004 9:27 pm
by litebearer
It often helps to consider how you would handle it if you were in the 'pre-computer' days. Generally a T account where you would post debits and credits. So you would need as a minimum the following fields

client_id
Invoice_id
Date
debit_amount
credit_amount

since AR is an asset, the debits would be the money owed you and the credits would be the money received.

there is a myriad of info you could glean for those fields

Posted: Thu Jun 03, 2004 5:35 am
by recsx
Ok ok

Looking good, good ideas.

Now what about having to do this to about 600 clients every month.

What type of a layout on the php side do you think would work good?