ISTech Support Forum - IN-A Rebuilding Stock Status slow

chrisbowden Full Member Doing it all with DBA. Posts: 106 Gender:	IN-A Rebuilding Stock Status slow 03/12/07 at 15:19:08 I have noticed that the Rebuilding Stock Status message seems to be taking longer and longer as time goes on. Are there any suggestions on how to speed this up? Do we need to clear out some kind of transaction history to help this? Thanks! Chris
Back to top	Chris Bowden Amstar Foods LLC ISTech 2004.1 12/21/08 - 5 user - Classic & Evo - patch as of 01/07/09 Pervasive 2000i SP3 / XP Pro IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5663

Re: IN-A Rebuilding Stock Status slow
Reply #1 - 03/12/07 at 16:01:55

Two things that will help significantly:

1. Archive Closed Work Orders (SM-J-B). No loss of data, you simply look at JC reports selecting Archived rather than Active Work ORders.
2. Purge Closed Sales Orders (SM-J-J). While this does in fact delete the closed sales orders up through the specified date, the information is all stored and available in the Invoice History file which is not touched by this program.

Back to top

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

chrisbowden Full Member Doing it all with DBA. Posts: 106 Gender:	Re: IN-A Rebuilding Stock Status slow Reply #2 - 03/12/07 at 18:30:09 Thanks Lynn! I will try these archiving hints tomorrow and hopefully this will reduce the grousing I keep getting from a couple of impatient users (including myself!) about how slow IN-A is on our more popular items. Cheers! Chris
Back to top	Chris Bowden Amstar Foods LLC ISTech 2004.1 12/21/08 - 5 user - Classic & Evo - patch as of 01/07/09 Pervasive 2000i SP3 / XP Pro IP Logged

cmsk

Senior Member

Posts: 279

Re: IN-A Rebuilding Stock Status slow
Reply #3 - 03/14/07 at 03:56:20

Quote from Lynn_Pantic on 03/12/07 at 16:01:55:

Two things that will help significantly:

1. Archive Closed Work Orders (SM-J-B). No loss of data, you simply look at JC reports selecting Archived rather than Active Work ORders.
2. Purge Closed Sales Orders (SM-J-J). While this does in fact delete the closed sales orders up through the specified date, the information is all stored and available in the Invoice History file which is not touched by this program.

Lynn,

This sounds like it would speed up MANY things throughout the system, yes?

How do you view the information in the SO invoice history file? It's pretty common that we look up a customers order history, so this needs to be readily accessible.

Back to top

--
Thank you
Chris Simo-Kinzer
Vice President
brookfield industries, inc.

Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11
Pervasive 9.5

IP Logged

Lynn_Pantic Administrator evolution (n) - gradual change to a different form Posts: 5663	Re: IN-A Rebuilding Stock Status slow Reply #4 - 03/14/07 at 16:00:43 It will speed up MRP and anything that needs to rebuild or look at stock status as well as many reports so yes, it will have wide ranging effect. SO-H is the easiest way to look at individual invoices. Any of the SA module reports can be used. SO-I and the Shipments button in AR-A (or AR-Q) are also options.
Back to top	Lynn Pantic IS Tech Support lynn@istechsupport.com IP Logged

cmsk Senior Member Posts: 279	Re: IN-A Rebuilding Stock Status slow Reply #5 - 03/15/07 at 03:03:35 Great Lynn, many thanks. This sounds like a very beneficial option / feature.
Back to top	-- Thank you Chris Simo-Kinzer Vice President brookfield industries, inc. Evo-ERP 2017.2 Build 4.5.17 Update T7-7i R11 Pervasive 9.5 IP Logged