ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> Sales >> Disappearing Sales Orders
http://www.istechforum.com/YaBB.pl?num=1371748996

Message started by Shanthi Nair on 06/20/13 at 10:23:16

Title: Disappearing Sales Orders
Post by Shanthi Nair on 06/20/13 at 10:23:16

IN the last few weeks we have had about 3 Sales Orders disappear. We have had the problem about 4 months back. I did notice that this problem was solved a couple of years ago. So I am not sure how it is happening.

We are running DBA Classic 2004.1 with update 10/24/12 SP1.

Thanks
Shanthi

Title: Re: Disappearing Sales Orders
Post by Shanthi Nair on 06/26/13 at 09:35:50

HI,

Does anybody know why this might be happening? We are seeing this happen at least once a week now.

Thank you!

Title: Re: Disappearing Sales Orders
Post by Kelloggs on 06/26/13 at 10:32:33

Go into Maintain Database

Open tables BKARHINV or BKARINV Can you see those Sales Orders??

Do you re-index your tables on a regular basis?

:P

Kelloggs

Title: Re: Disappearing Sales Orders
Post by Shanthi Nair on 06/26/13 at 10:41:16

Not unless we absolutely need to. I did look in BKARINV and BKARHINV and they wwre not there. Do think reindexing will help the problem?

Title: Re: Disappearing Sales Orders
Post by Kelloggs on 06/26/13 at 10:53:54

if they aren't there no need to re-index. They are gone.

I have seen lots of post about data "mysteriously disappearing". We regularly see purchase order lines "disappear"

:P

Kelloggs

Title: Re: Disappearing Sales Orders
Post by Kelloggs on 06/26/13 at 11:07:36

Are there inventory transactions for those sales orders?
if so, someone could have delete them

:P