ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Evo-ERP and DBA Classic >> System Manager >> how do I find key number for pervasive rebuild?
http://www.istechforum.com/YaBB.pl?num=1186527242

Message started by newline on 08/07/07 at 15:54:02

Title: how do I find key number for pervasive rebuild?
Post by newline on 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?

Title: Re: how do I find key number for pervasive rebuild
Post by Lynn_Pantic on 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.

Title: Re: how do I find key number for pervasive rebuild
Post by newline on 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.