Hi Matthew, We have built some approach for a modified version of sql-ledger, and we are building this now on trunk.
Basically what we did is a prepayment/overpayment system that allows you to "use" (link) this payments against invoices latter, so you can track both payments without an invoice and overpayment linkage. 2009/2/24 Chris Travers <[email protected]>: > On Tue, Feb 24, 2009 at 5:00 AM, Matthew Kent <[email protected]> wrote: >> We have a small problem I hope you can provide some insight on. Our >> data capturer has captured payments for invoices through the general >> ledger section as apposed to capturing them against invoices. Is there >> a way we can link these payments to the invoices so that our debtors >> balances correctly? I am fairly competent with databases as I am a >> developer myself, so if there is a way we can create the association >> in the database I will be prepared to try that route as apposed to >> undoing all the work done to this point. > > The current database schema doesn't seem to handle things this way (it > is somewhat braindead in how payments are tracked at the moment). > > I see two options at this point (outside of undoing the work): > 1) You could help us get to where payments are GL entries (where we > want to be for 1.4) > > What would be needed here would be redoing the outstanding reports and > transactions reports (in AA.pm), and providing a linking table. > > 2) We could come up with a way to automatically take the data you > have, reverse it, and add proper payments. > > Without knowing how this came in, I can't comment, but given that you > are trying to associate everything this shouldn't be out of the > question. > > Best WIshes, > Chris Travers > > ------------------------------------------------------------------------------ > Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA > -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise > -Strategies to boost innovation and cut costs with open source participation > -Receive a $600 discount off the registration fee with the source code: SFAD > http://p.sf.net/sfu/XcvMzF8H > _______________________________________________ > Ledger-smb-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/ledger-smb-users > ------------------------------------------------------------------------------ Open Source Business Conference (OSBC), March 24-25, 2009, San Francisco, CA -OSBC tackles the biggest issue in open source: Open Sourcing the Enterprise -Strategies to boost innovation and cut costs with open source participation -Receive a $600 discount off the registration fee with the source code: SFAD http://p.sf.net/sfu/XcvMzF8H _______________________________________________ Ledger-smb-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
