Navigation:  SHOPKEEPER > FIX ERRORS >

8FFIX

Previous pageReturn to chapter overviewNext page

8FFIX

 

 

 

HOW TO FIX A DATABASE

_____________________

 

To fix bad records in the INVENTORY database:

 

*) Choose 8,F (fix databases)

 

*) Choose CURRENT year (C)

 

*) Go to INV.DBF (number 15)

 

*) When prompted for an index number, choose 1 (sku no)

 

*) You will see a list of inventory

 

Sku_no   ³Po_no      ³Mfg_code³Ven_code³Vndr_style      ³Desc

       ³~010103222 ³        ³        ³                ³

       ³~E01290010 ³        ³        ³                ³

       ³~010202272 ³        ³        ³                ³

       ³1227       ³        ³        ³                ³

       ³~BT0209041 ³        ³        ³                ³

       ³~020301101 ³        ³        ³                ³

       ³~010402041 ³        ³        ³                ³

1-00001³#97111500  ³CMP     ³CMP     ³PEND-XYZ        ³14KT.20#

1-00002³#011050900 ³214     ³214     ³12              ³14K PENDENT

1-00003³#25        ³CMP     ³CMP     ³1234ABCD        ³18KY 5.0C SAPH, .25

1-00234³#96051500  ³ABC     ³ABC     ³34              ³AD

1-00500³#99        ³CGL     ³CGL     ³ESTATE          ³18KY GOLD PEN W .75

1-10001³~E280970   ³CMP     ³CMP     ³13241           ³123 RING

1-10002³~020305091 ³RJO     ³CMP     ³AELKJDA         ³123 RING

1-10003³~020305091 ³KRJ     ³CMP     ³DF              ³14KY RING

 

        ³<F:>³INV        ³Exclusive      ³Rec: 1277/1359     ³Ins   ³Num

 

 

*) Notice the 1277/1359 at the BOTTOM.

That means you're at the 1277th record of 1359 TOTAL records

 

************************************************************

This is IMPORTANT - NEVER DELETE the 1/1359 (or top record)!!!

 

*) Press the UP arrow to get to the TOP record.

 

*) Press CTRL+T to delete this record. A small dot will

appear to the left of the SKU NUMBER of that line.

 

That means the record is TAGGED to be deleted.

It will be delete when you move that item off the

screen.

 

*) If you delete (CTRL+T) an item by mistake, press CTRL+T again to

recover the record (the DOT will disappear)

 

 

*) Press page up and page down to scroll

 

*) Any item withOUT a sku number MUST be deleted (except for record 1)

 

*) To see information to the RIGHT, press TAB

 

*) To scroll BACK the LEFT, press SHIFT+TAB

 

*) When finished, press CTRL+W

 

*) Answer NO and YES