Important Note: The DBU is a database utility program that you can use to manipulate data directly. Great care should be taken when working in the DBU. You may cause irreparable damage, delete or change data if you do not know what you are doing. Make a backup before you open the DBU. Please follow the instructions very carefully. If you are unsure of any instruction please do not hesitate to contact Otomys directly at (012) 348 4071. Otomys will not be held accountable for any data loss or corruption.

How to mark all services, stock and clients to receive discount

Exit from of Microvet on all the computers

Make a backup

Do these steps on the File Server

 

Click on START

Click on PROGRAMS

Click on ACCESSORIES (only for windows ME/XP/NT and 2000)

Click on MS-DOS PROMPT or COMMAND PROMT

(From now on you will not be able to use your mouse, use the Enter key and the arrows on your keyboard.)

CD\MFW5

DBU

 

F2

OPEN

Open ACCOUNTS.DBF (mark ALL the clients)

OK

 

F6

REPLACE

Select the field ACSRDISC (mark ALL the clients to receive discount on all services)

Replace with  .T.

Scope ALL

OK

Confirm to replace

 

F6

REPLACE

Select the field ACSTDISC  (mark ALL the clients to receive discount on all stock items)

Replace with  .T.

Scope ALL

OK

Confirm to replace

 

F2

OPEN

Open SERVICE.DBF (mark ALL the services)

OK

 

F6

REPLACE

Select the field SRDISC 

Replace with  .T.

Scope ALL

OK

Confirm to replace

 

F2

OPEN

Open STOCK.DBF (mark ALL the stock items)

OK

 

F6

REPLACE

Select the field STDISC 

Replace with  .T.

Scope ALL

OK

Confirm to replace

 

ESC

ESC

EXIT TO DOS

Y

DEL  *.IDX

EXIT

 

Start Microvet

The program will automatically start to re-index

Log in