While converting a system for a client, I'm running into problems with the way they approach things. One is simply the age-old "we've always done it that way" problem. Something more specific is their desire to have an overpayment on an invoice make the invoice balance go negative, effectively making it an open credit that can later be applied against another invoice. So you have a situation where it's an invoice one day, a credit the next. One day you're getting a payment against it and the next you're using it as a payment to pay something else. To me, this is the wrong way to go about it. I have the system never letting a balance fall below zero and generating a credit invoice for the overpayment amount. Then the credit invoice can be used later to apply against another invoice. This causes some issues for them, though I'm going to address them. Anyone have any thoughts on these two appoaches?

Russell Campbell