ISTech Support Forum - S/O lookup button in IN/A

Welcome, Guest. Please Login.

	11/15/24 at 23:28:48 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › Problem Reports - Repeatable

‹ Previous topic | Next topic ›

Pages: 1

S/O lookup button in IN/A (Read 1185 times)

deburr Senior Member Posts: 487 Gender:	S/O lookup button in IN/A 01/08/11 at 07:11:04 When we look up sales orders using the SO button at the bottom of the IN/A screen, It takes a huge amount of time for the screen to update with open orders. Is there something that can be done to speed this up? I have as many work orders and that updates very fast. I don't understand why Sales orders should be so different.
Back to top	Thanks, Steve Cyr Deburring House Inc. EVOERP Version 2018.2 PSQL 12 IP Logged

gtladmin Active Member Diving is fun, diving is fun! Posts: 1306 Gender:	Re: S/O lookup button in IN/A Reply #1 - 03/08/11 at 16:10:12 You can try doing some purging/archiving - that worked wonders for us!
Back to top	Val Feehan IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: S/O lookup button in IN/A Reply #2 - 03/09/11 at 06:52:29 Don't restrict the view to Open orders. Viewing all is much quicker. There is something wrong with that filter. It should scale better.
Back to top	IP Logged

edbrown

Browser

I love YaBB 1G -
SP1!

Posts: 8

Re: S/O lookup button in IN/A
Reply #3 - 03/15/11 at 14:20:08

I don't have an answer for the initial question, but have a different problem along the same lines.

In EVO (1/18/11 with SP1) IN-A, select a part number, then hit SO button. When we try to then sort the grid by Sales Order number, we get the following error...

"You have tried to access a file that has not been previously opened, or the file number value (FNUM) passed was 0."

It does this for all users, including Admin. The 'sort by SO number' does work fine when 'SOLINES' is accessed via QU-E. Any ideas?

Travis

IP Logged

edbrown

Browser

I love YaBB 1G -
SP1!

Posts: 8

Re: S/O lookup button in IN/A
Reply #4 - 03/16/11 at 10:57:27

I did think of something, have you tried reindexing the affected files. We had performance problems before with a WO module and Lynn suggested re-indexing some files and it worked wonders. There is a program in DBA to reindex, and a list of the files in the help documents. Even if it doesn't solve your immediate problem, I think it is healthy for performance to reindex periodically and doesn't hurt anything that I'm aware of, we do it once per year.

IP Logged

btaylor

Browser

Posts: 32
Gender: male

Re: S/O lookup button in IN/A
Reply #5 - 04/01/11 at 09:38:43

I am having the same problem. S/O out of the IN/A screen used to take a while the first time I tried to access them after logging on but worked well after that. It has been degrading lately and now when I hit it, it takes 8-9 minutes to pull up sales orders. All other functions seem to respond fine. The problem seems to be getting worse and worse on its own. It is driving me insane. Any solution to this would be great!

IP Logged

deburr

Senior Member

Posts: 487
Gender: male

Re: S/O lookup button in IN/A
Reply #6 - 04/07/11 at 07:20:49

Quote from GasGiant on 03/09/11 at 06:52:29:

Don't restrict the view to Open orders. Viewing all is much quicker. There is something wrong with that filter. It should scale better.

Colin

I don't see an option for viewing all or open orders. I am using the SO button at the bottom in the classic view of T7INA.RWN. That returns open orders. Is there a way to see all orders?

Thanks,

Steve Cyr
Deburring House Inc.
EVOERP
Version 2018.2
PSQL 12

IP Logged

GasGiant Administrator How can I help? Posts: 1523 Gender:	Re: S/O lookup button in IN/A Reply #7 - 04/07/11 at 07:48:29 I was all wet. Sorry. Mine comes right up.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › Problem Reports - Repeatable

‹ Previous topic | Next topic ›