|
The monthly bills we send are broken into 4 sections and the money the customers pay are applied to the sections in a certain order. The money isalso applied to the oldest month first then progresses to the current month.
The way I've done this in the past is to read the charges by date/bill cycle, and apply the payments in that order. No arrays at all, just read the outstanding charges and create corresponding payments.
You need to remember that this might create partial payments. Also consider the situation where the payment rules might insist that you pay all of one class of charge for each bill cycle before applying payments to other classes. An example of this is telephone bills, where payments are applied to regulated service first (for the oldest month, then the next oldest month, etc.), then non-regulated services (for the oldest month, then the next oldest month, etc.)
--buck
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.