Welcome, Guest. Please Login.
05/14/25 at 03:11:21
News:
Home Help Search Login


Pages: 1
Send Topic Print
Shipments Screen in AR-A (Read 449 times)
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Shipments Screen in AR-A
10/19/07 at 11:55:57
 
It was just brought to my attention that the shipments screen in AR-A does not show the shipments in any particular order.
 
What table does this info come from?
 
Is it suppose to be shown in any particular order (by inv #, by inv date???)
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
JNAPIER
Active Member
*****


Evil-Evo Bad Dog!

Posts: 533
Gender: male
Re: Shipments Screen in AR-A
Reply #1 - 10/19/07 at 12:28:47
 
BKARINV OR BKARHINV One of those. If you are using the T7 Versions of AR-A you can select which sort you want while in the lookup. Older T5 or T6 were set by how the file was indexed.
 
John
Back to top
 
 

EVO-ERP, ISTS 3.27.08 , 2000I 10 user
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Shipments Screen in AR-A
Reply #2 - 10/19/07 at 12:59:41
 
The solution to this is to use the Pervasive Rebuild Utility on BKARINV and BKARHINV.
The trick is to set the options to use key 0 for the Rebuild so that the records get placed
in physical order by Key 0 ( invoice number).
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Theran
Member
**


I'm not a browser,
I'm a low end Bronze
member...

Posts: 70
Gender: female
Re: Shipments Screen in AR-A
Reply #3 - 10/19/07 at 17:07:47
 
This rebuild utility that you speak of in Pervasive,,,,, is this something that we should be using on some sort of basis for maintenance or is this something one would use if they had a specific problem?  I've been a DBA user for a while, but I've never used anything except the Monitor to see if users are logged on when I want to do a backup or an update.  I wasn't really aware that I should be doing anything with Pervasive.  Where would I learn more about this?
Back to top
 
 

Teres Heran
Armature Coil Equipment, Inc
DBA Classic, Ver 2004.1 with IS Tech 9/21/07
Email WWW   IP Logged
kevind
Active Member
*****


I was more than
willing to
"pony up",
how b'out U?

Posts: 634
Gender: male
Re: Shipments Screen in AR-A
Reply #4 - 10/19/07 at 18:01:28
 
No, you do not need to do any datafile rebuilds on a regular basis.
You should only do them to solve a problem with an index, or to
reduce the size of a datafile that has had many records deleted
from it.  
 
For example, if you archive Work orders, or PO's, you can rebuild
the appropriate files so that the deleted space from the data file
is removed.
 
Data files grow as needed, but do not shrink if records are deleted.
By rebuilding, you are copying only the data records to a new file;
not the deleted space.
 
If you have plenty of hard drive space, it does not mater if you  
shrink these files.  Pervasive uses it's own page allocation scheme
internal to the data files.  If you don't shrink them, then pervasive
does not have to expand the file to add new records; it just uses
the already allocated ( unused ) space.
 
 
Back to top
 
 

Kevin Damke
Spectronics Corporation
ISTECH 2004.1 7/26/13 SP1 - 20 user
Evo-ERP Build 7/25/13 T7 -7i R6 - 3 user
(Prev version was 2004.1 10/24/12)
(All Patches Installed as of 7/26/13)
Pervasive 2000i SP4 - Crystal Reports V10
Email WWW   IP Logged
Pages: 1
Send Topic Print