Invoice & Account Payment Allocations

[discostudio]

This is one for the accountant and expert programers out there.

I have two tables:

Invoices
Payments

I need to allocate the payments to the invoices.

Sounds easy right? - Not!

Scinario: I have an invoice for £100 and someone pays me £150, I have an overpayment; therefore I need to be able to pay £100 against the invoice and leave £50 "on account". and visa-versa for underpayments, then I will also need to allocate the remainder to another invoice.

Has anyone written a customer account system that I can pinch for a programming favour debt? - Or some advice from someone who has done this before. I really need some help on this one.

[rkolbe]

Well, I can't say I have the code off hand for you, but I have written up something very similar in Java for a small project. It actually isn't hard at all, unless there is more to the situation than you provided...just take the payment amount, match it against their balance, do the subtraction with a routine for that, and then take the left over and move it into another account...etc...

Wait, sorry, I'm not helping am I? Seeing how you already know the solution to this you should be able to code it eh? Sorry I don't have any code on hand but it doesnt sound difficult at all.