Hi Alfred I too would be very interested if there is a solution for this. This is the only serious problem I have found with both Sql-Ledger and LedgerSMB as the packages automatically allocate the payments to the invoices which is not wrong but, when running month end statements, The customer wants to know what he paid on a certain date, not which invoice the payment got allocated to.
I threw some money at this to see if someone could write me a PHP script (I didn't want to mess with the Perl architecture especially with upgrade issues) that interrogated the database but we could not find where the payment was made and on what date, on the database and so we have landed up doing our monthly statements on a specially prepared spreadsheet seperately. We copy the invoices details from Sql-Ledger AR reports across using a simple copy and paste and then manually put in the payments. We Then do a cross check with the aging analysis before sending them out to the customers. Fortunately I am dealing with 10 - 20 customers only who are on 30 day monthly accounts, so it is not too much of a problem for me but it would be fantastic if there was a button I could press, insert the dates required, select the customer / s and hit print. Tim Wade Penguin Products On Wed, Aug 11, 2010 at 8:32 AM, Alf Newman <[email protected]>wrote: > I make sql-Ledger. > sale invoice for $250. > credit note for $60. > customer he now pay balance of $190. > cash receipt report for this month shows receipt of $250, and receipt of * > -*$60. > where is receipt of $190 as paid by customer ? > how to do correct entry to make correct report receipts ? > thanks you > > > _______________________________________________ > SQL-Ledger mailing list > [email protected] > http://lists.ledger123.com/mailman/listinfo/sql-ledger > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
