Receivables Database Questions and Comments Needed

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
recsx
Forum Newbie
Posts: 9
Joined: Mon May 31, 2004 8:44 pm

Receivables Database Questions and Comments Needed

Post 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.
McGruff
DevNet Master
Posts: 2893
Joined: Thu Jan 30, 2003 8:26 pm
Location: Glasgow, Scotland

Post by McGruff »

It might help if you explian what "receivables" are.
recsx
Forum Newbie
Posts: 9
Joined: Mon May 31, 2004 8:44 pm

Post 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.
User avatar
tim
DevNet Resident
Posts: 1165
Joined: Thu Feb 12, 2004 7:19 pm
Location: ohio

Post 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?
litebearer
Forum Contributor
Posts: 194
Joined: Sat Mar 27, 2004 5:54 am

Post 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
recsx
Forum Newbie
Posts: 9
Joined: Mon May 31, 2004 8:44 pm

Post 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?
Post Reply