[SL] Re: stock problem help please

Thanks a lot Roy!

At least I now where to start, and see what my users are doing. I will 
take some time to test this and see what I can do.

Thanks again,
ait

> 
> Hello Alejandro
> 
> How I ran into this problem:
> 1) I set up the initial stock for January 1st by creating 
vendor/purchase invoices for them.
> 2) I created a vendor invoice for the items sold prior to Jan 1st 
that were on outstanding customer invoices
> 3) I entered all the outstanding customer invoices
> 
> At this time...All was showing up the way it should be...So i 
started using the system
> 2 days later I realized that the paper stock count sheets from 
January 1st  did not match the true stock count on Jan 1st.
> 
> 6) I went back and changed the existing vendor/purchase invoices 
that I created for the Jan 1st
> 
> This caused duplicate entries to be created in the COGS account for 
the invoices that were effected.
> Changing existing closed invoices is not a common issue with me, so 
I have had no problems since.
> 
> I haven't talked to Dieter about it for that reason but he'll see 
this post.
> 
> One day when i get some free time I'm gonna sit down and do some 
thorough testing to see when this occurs
> 
> Roy
> 
> 
> On May 22, 2003 12:51 pm, you wrote:
> > Roy,
> > 
> > It's good you got it pinned down.
> > Have you talked to DS about it?
> > Can you replicate it?
> > 
> > We've been using SL _heavily_ for since Jan and it's _the only_ 
major 
> > problem we have. It happens once in a while but we invoice 50 
maybe a 
> > 100 invoices a day on each of the 2 businesses we handle with SL, 
when 
> > it happens to us, we can spend hours reposting and making the 
trial 
> > balance to zero. 
> > 
> > If you could tell me how to replicate this problem perhaps I could 
> > look in the code and see what causes it and give DS a hand here.
> > 
> > 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?
> > 
> > Thanks,
> > Alejandro Imass
> > 
> > 
> > 
> > > 
> > > Check the "COGS gone mad..."  thread.
> > > Your problem may be caused by the same thing.
> > > 
> > > Problems occur when you alter existing vendor invoices for goods 
> > that have 
> > > been sold on existing customer invoices.
> > > The solution in this type of case is to call up the affected 
> > customer invoices 
> > > and re post them.
> > > 
> > > Cheers,
> > > Roy Pennington
> > > 
> > > On May 14, 2003 02:32 am, Ghassan Abdallah wrote:
> > > > Hi,
> > > > i was working on sql Ledger from about the beginning of the 
year, 
> > but when
> > > > i was checking my reports in the "Chart of accounts"; i found 
that 
> > in the
> > > > stock account, the accounts were doubled or there is some 
problem 
> > in them
> > > > or in the COGS so can anyone help me with that. thanks.
> > > 
> > > 
> > > 
> > > 
> > 
> > -- 
> > Alejandro Imass
> > 
> > 
> 
> -- 
> Roy W. Pennington
> Arch Distributors of Canada
> 
> 
> 
> 

-- 
Alejandro Imass

Other related posts: