Sounds reasonable but we have not changed the accounts. There must be something else we are doing wrong. I will check with a fresh database. When I mentioned the code I had taken a look at the reverse logic and the COGS sub seemed to have a > 0 condition in the where clause that _seemed_ to me that it could have been the problem. Of course, it was a very fast first take of the code and I have never bothered to check with a fresh database. I will do that and let you know. Thanks for your input. > > On Thu, 22 May 2003, Alejandro Imass wrote: > > > > BTW, did you see my post on COGS on returns? : When you return > > something on a sales invoice (negative QTY and price 0) neither the > > COGS or Inventory accounts get reversed, but the physiscal qty does. I > > checked the code and it seems it will definitively it will never > > update COGS. My question is, if it wasn't meant to, how do all the > > other people out there handle returns on goods sold? > > There is nothing wrong with the code, returned goods are processed just > fine, however you changed the account links for the part and created > orphans. > > Just think, you link a part to account A, later you change this and link > the part to account B. Now when you return this item it cannot find the > links for the original invoice and the amounts are not updated. > > > Dieter Simader http://www.sql-ledger.com (780) 472-8161 > DWS Systems Inc. Accounting Software Fax: 478-5281 > ============ On a clear disk you can seek forever ========== > > > > -- Alejandro Imass