The present code is here [url removed, login to view] and the demo is here [url removed, login to view]
The addition of a Ledger sheet for the [url removed, login to view] showing Summary of Payments (if any), Invoices, and the running balance. Also a "drill down" function in which clicking on the "ID" of the transaction will show the detailed invoice or Payment transaction- (The payment would automatically be posted in the case of paypal or a credit card, and manually posted from admin in the case of a check or a payment received against an open account). I believe you have the drill down (printable) in the admin using "View old order"
The addition of an A/R accounts receivable "module" to the admin side. These modules usually contain the following, This would allow Manual posting of payments, automatic posting of paypal and credit card statements payments in addition to the invoicing you already have at present. Followup Invoicing and statements/past due notices by email and printable for fax/mail. A ledger and AR report for current and past due invoices. Parameters to set for Global and/or each customer. Grace period if any, The % interest automatically added to the customer ledger on over due accounts. 3 or 4 Dunning notices for different time periods of delinquency The due date (Example # of days OR a set date of the month like the 10th) The preceding parameters would allow an automatic cron job to automatically send out the appropriate statements/notices by email. Recap/summary reports of these activities.
Also approval of a pending order such as a "check" or "open account" would have no bearing on the ledger showing any payment, just the decision to allow the customer proceed with the purchase without upfront payment.
There are some other wording changes that need to be made and it will need to be integrated into my PERL job script and fit into my same style Templates that I am using on my job board
Perhaps it would be easier to hook into another GNU script such as sql-ledger
[url removed, login to view]