Only option would seem to me that you somehow created a difference between the General Ledger (A/R totals) and the subledger (totals of all individual A/R accounts). Every bookkeepers nightmare! Possible causes: 1) invoice date out of current reporting period 2) payment date or receive date out of current reporting period
the above could well be a typo, say 07/02/05 i.s.o 07/02/02 (5 is right above the 2 on the keyboard..) I do not know if an extra check on those (something like "if year_of_posting_date <> current year gosub WARNING!!) Would slow down the input routines drastic, otherwise it MIGHT be a userfriendly anti foolproof tool? Good luck hunting, Paul. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Scott Taylor Sent: maandag 22 juli 2002 23:04 To: [EMAIL PROTECTED] Subject: Re: Fwd: [SL] Duplicate AR payments Thanks for the lesson but I learnt that when I became a CPA. The problem which I thought that I had adequately explained, was that the bank account balance was overstated (as in the bank rec is out by these amounts) by these duplicate payments, yet the debtor invoices which they related to were not overpaid. I have subsequently found that the AR ledger balance was out by the same amount and was able to correct it by GL journal. This would seem to suggest I had duplicated the payment entries (which I know I did not) yet the individual invoices were not in credit? How can this be? Scott On Monday 22 July 2002 9:01 pm, Dieter Simader wrote: > What seems to be a duplicate AR is just an offsetting entry for a > payment. > > double entry bookkeeping! Debit = Credit > > > Dieter Simader http://www.sql-ledger.org (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > =========== On a clear disk you can seek forever =========== > > On Sun, 21 Jul 2002, Scott Taylor wrote: > > Could someone help me with this please > > > > Thanks > > > > Scott > > > > ---------- Forwarded Message ---------- > > > > Subject: [SL] Duplicate AR payments > > Date: Fri, 19 Jul 2002 11:14:13 +0100 > > From: Scott Taylor <[EMAIL PROTECTED]> > > To: [EMAIL PROTECTED] > > > > Apologies if this has been covered. > > > > I have: > > > > SL 1.8.4 > > Apache 2 > > PostgreSQL 7.1.3 > > > > I have noticed that 3 AR payments have been duplicated in the bank > > ledger account. However, when you run a transaction report on the AR > > account the invoices in question are not overpaid. (I only have one > > client so won't be in another AR account) > > > > I seem to recall that I receipted all three amounts at the same time > > in the "Payments" screen and wonder this has something to do with > > it? > > > > Anyway, how do I correct this as doing an AR payment reversal would > > seem to make the amounts due again? > > > > Regards > > > > Scott > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > ------------------------------------------------------- > (un)subscribe: > http://lists.sourceforge.net/lists/listinfo/sql-ledger-users > Archive: http://www.mail-archive.com/[email protected]/ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/ ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf ------------------------------------------------------- (un)subscribe: http://lists.sourceforge.net/lists/listinfo/sql-ledger-users Archive: http://www.mail-archive.com/[email protected]/
