Hi Paul There is nothing wrong with Sql-Ledger or LedgerSMB, its just that some of us need (especially here in South Africa), those who deal with monthly accounts for our customers, need to see the actual payment from the customer.
What happens is that the agreement we have with our customers, is for example for all Purchases made by that customer between 1 march and 31 march, so long as he pays us by the 30 April (Last day in April) he will not pay interest or penalties on that amount. This is what we call a 30 day account, although its not strictly 30 days as stuff bought on 1 March is more like 60 days but for better or worse, that is the system that is used here. What this means that at the end of each month, we produce a report for our customers which we call a statement in it we show all the invoices still outstanding in the current, 30 day, 60 day etc columns but again the 30 day for example being what was due to be paid on the last day of the previous month, not what was owed 30 days from date of invoice, if you get my meaning from the paragraph above. We put in the customers payment in the apropriate column and we show a running balance down the right hand side and across the bottom what is owed in the current, 30 days 60 days etc. The invoices we could sort out with a PHP script as that Data we could get at and sort etc... The problem comes with the payment. The customer wants to see on the statement what he paid and on what date, he is not worried about which invoice its allocated to and the problem was there was no specific address on the database that captured the customers specific payment and the date. One could add a journal entry into the general ledger, but it gets messy and is prone to error as you capture the payment in one place and then capture it again in the payments section to satisfy the needs of Sql-Ledger or LedgerSMB. Its just one of those annoying things 95% of the information is there but unfortunately the 5% is critical to the report and the changes that need to be made to incorporate the 5% dont warrant the work and the cost. The Copy and paste works well enough for us into a spreadsheet and is not tooooo much of a problem, it would be nice though if we could handle it all in one package but then I guess if life was too easy too many people would be out of work and we would be bored stiff. Just thought I would mention it so that as these packages improve and develop it could possibly form part of a future upgrade. I hope that my lengthy explanation helps, Paul, its not that Sql or SMB are faulty, some of us just need 2 additional bits of information (Payment and a date linked to a customer) that due to the way Sql and SMB operate are not captured at this stage and as it is not something that appears to be universally used across the world I understand why it does not form part of the packages report architecture. Tim Wade Penguin Products On Fri, Aug 13, 2010 at 9:32 PM, Paul Tammes <[email protected]> wrote: > The customer paid plus 250 and minus 60 making a total payment of 190. > You received 250 minus 60 making a total receipt of 190. > > Both SQL ledger and SMBledger report the very same, which seems totally > correct and adequate to me. > Sorry but I do not grasp the problem. > > > 2010/8/11 Alf Newman <[email protected]> > >> 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 > >
_______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
