[SL] Re: stock problem help please

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

Other related posts: