[SL] Re: stock problem help please

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 ==========

Other related posts: