ISTech Support Forum - how do I find key number for pervasive rebuild?

Welcome, Guest. Please Login.

	05/25/25 at 08:31:49 News: \| IS Tech Support \| Evo~ERP \| Evo Wiki \| Forum \|

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›

Pages: 1

how do I find key number for pervasive rebuild? (Read 659 times)

newline

Browser

Posts: 37

how do I find key number for pervasive rebuild?
08/07/07 at 15:54:02

I want to use the Pervasive Rebuild Utility to sort the BKARHINV file so shipments show up in a logical order when viewed from AR-A.

They got jumbled after reindexing the file, and I have used the rebuild to put them in INV number order ,but we have some old voucher invoices with high numbers so we would rather see them in INV DATE or shipment DATE order.

Can anyone please tell me what key number to use to sort them by date?

IP Logged

Lynn_Pantic

Administrator

evolution (n) -
gradual change to a
different form

Posts: 5663

Re: how do I find key number for pervasive rebuild
Reply #1 - 08/07/07 at 18:55:10

Open the file in Maintain Database. The Keys (Indexes) are listed in order under "Sort By", beginning with 0. So in the case of BKARHINV, the Key 0 is BKAR.INV.NUM which is the invoice number and what would normally be used. In your example, you want to change to 14 for SHPDTE (Ship Date)

If you were rebuilding the BKARINV (open Sales Orders), then you would probably want Key 1 which is the SONUM.

Lynn Pantic
IS Tech Support
lynn@istechsupport.com

IP Logged

newline Browser Posts: 37	Re: how do I find key number for pervasive rebuild Reply #2 - 08/07/07 at 19:01:26 Thanks. I'd figured out the BKARINV where the So num was key 1 but every key I tried for BKARHINV seem to make it worse.
Back to top	IP Logged

Pages: 1

ISTech Support Forum › Evo-ERP and DBA Classic › System Manager

‹ Previous topic | Next topic ›