Annulé

OSCOM billing and receivbles functionality

Need system to track payments made against orders. Flow would be my accountant receives a payment. He logs in to OScom and sees a screen.. and selects

the client. Inputs the amount, check number, bank name and date on the check and date received. (and probably hits refresh) For this master record

(client payment) a detail below shows this client's invoices which are less than 100% paid. and shows order number, order date, order amount and paid to

date... and an empty field "amount to apply to this invoice from this payment" he inputs an amount here and can move down the list of pending invoices

applying amounts paid. There would also be a field checking that he does not apply amounts that sum to more than the payment received. If the check

amount was greater than the sum of the balances due of the invoices... there would have to be a way to handle the over payment. My thought would be to

have a record for everyclient that always shows up in the details section of this form (sort of like a dummy invoice) that is called overpayment_holding.

So if I have an over payment... I apply it to this dummy invoice and then when I have a new invoice I apply a negeative amount to the dummy invoice and

that positive amount to the new real invoice.

Now on the invoice we need to add some fields to show these payments. below the grand total on the invoice show the payments made . Date check number

check amount amount applied to the invoice. and below a calculated field of Amount Pending (gand total minus payments applied)

These fields will be added to the client side and admin sides invoice and also to a PDF invoice that we have added to our oscom install. (that may be 4

seperate spots)

Then create a client statement report accesible from the admin - Adding two buttons one that brings up a date range prompt and filters the report on the

date range. One that reports all outstanding. This client statemnt report would have all the header info from the invoice and in the detail it would

have

Invoicenum:invdate:invTotal:totalpaid:TotalPending with detail records below each invoice showing show the payments made . Date check number check

amount amount applied to the invoice. Sum the detail records at the bottom Total invoices, Total payments , total pending

I anticipate a round of questions and answere before we begin and will provide lots of communication as we progress should you have any questions along

the way.

Compétences : PHP

Voir plus : you like hits, we need a accountant, total bank, should you have any questions, round name, payments accountant, payment not received from bank, new accountant, name flow, list of accountant, flow section, applied bank, amount received, accountant name, accountant it, which bank, calculated fields form, need a new accountant, it accountant, php pdf invoice, pending, invoice and billing, i need a accountant, HITS, billing system

Concernant l'employeur :
( 16 commentaires ) houston, United States

N° du projet : #27482

5 freelance ont fait une offre moyenne de 97 $ pour ce travail

TriggerMan

Would like to discuss your project in more detail. Am well rated at another freelance site: [url removed, login to view] Looking forward to your PM. Please disr Plus

100 $ USD en 1 jour
(60 Commentaires)
6.4
eenavin

check pmb.

100 $ USD en 15 jours
(2 Commentaires)
4.5
isource

it can be done

100 $ USD en 7 jours
(1 Commentaire)
3.0
ninadbe

Hello Sir, I am ninad from saitech ,INDIA. We are a group of software engineers and freelancers. We have sound experience in developing websites in PHP,JSP & [url removed, login to view] have experience in software [url removed, login to view] can d Plus

100 $ USD en 7 jours
(1 Commentaire)
0.0
jitinjain

We are from Modulus. We worked on such type of sites for ur reference u can check our following website. [url removed, login to view] [url removed, login to view] [url removed, login to view]

85 $ USD en 15 jours
(1 Commentaire)
1.8