[SL] Re: stock problem help please


Thanks for your valuable input but we have not changed the accounts. 
If the issue has popped up several times it was probably myself trying 
to see if anyone had this problem. It could have something to do in 
the way loaded the data. As I answered to Dieter I will take fresh 
database and see for myself. Then I will take mine and try to 
determine the differences. 

Thanks again, I will let you guys know anyway for the record.




> 
> For reference, i did try selling an item, noting the balances of 
stock, COGS, 
> and sales sales account before sale, after sale, and after a return 
using 
> negative sales quantity.
> 
> The ending numbers all returned exactly to the starting balance for 
each 
> account.
> 
> I have to go with Dieter on this as tampering with account numbers 
is the only 
> way I was able to mess mine up. (of course I only spent half an hour 
messing 
> with it --have to work too!)
> 
> Althought I hate to refer to Quirkbooks for an idea, here's what it 
does when 
> an account link is changed: (I still keep quirkbooks handy to 
calculate 
> payroll as SL can't do this yet)
> 
> Quirkbooks notes the danger in changing an account number and pops a 
dialog 
> warning - 
> "You changed an [Income/Expense] Account associated with this item. 
All future 
> transations with this item will use this new account. Would you like 
existing 
> transactions with this item to use this new account? This will 
include 
> transactions prior to the close date that use this item." [Default 
answer is 
> yes]
> 
> if yes it does a mass update to the child records, and if no - it 
orphans the 
> records as is, and changes the number. (can also be used to merge 
two 
> different accounts into the same one)  **NOTE: If you tamper with 
the now 
> orphaned transaction things get really messed up!
> 
> Since it seems that this situation has come up on the board a few 
times in as 
> many months, perhaps at least a warning should pop up when tampering 
with 
> account numbers that have child transactions -- I think that most 
users are 
> not accounting types and do not realize the gravity of a seemingly 
simple 
> change.
> 
> Comments, anyone?
> 
> --Dave
> ========================================
> David Ratte
> Superior Circuit Technologies, Inc.
> dratte@xxxxxxxxxxxxxxxxxxxx
> http://www.superiorcircuits.com
> Tel 321-254-4201 x 204
> Fax 321-254-6192
> 
> 
> On Thursday 22 May 2003 03:35 pm, Dieter Simader wrote:
> > 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

Other related posts: