Make your own free website on Tripod.com
 Sr Accountant tm Correction &/or
Conversion Program
SA:CCP01                                                              4:25:30 pm
      +-----------------------------------------------------------------+
      ¦ C O R R E C T I O N  and/or  C O N V E R S I O N  P R O G R A M ¦
      +-----------------------------------------------------------------+
+------------------------------------------------------------------------------+
¦                                                                              ¦
¦     This program will correct and/or convert the Sr ACCOUNTANT database      ¦
¦     files to a NEW or the CORRECT format. The computer will ask you which    ¦
¦     drive the databases are on. You can convert all or specific files.       ¦
¦                                                                              ¦
¦                   This conversion is dated February, 1999                    ¦
¦                                                                              ¦
¦                                                                              ¦
¦                                                                              ¦
¦                                                                              ¦
¦                                                                              ¦
¦                                                                              ¦
¦                                                                              ¦
¦                   +--------------------------------------+                   ¦
¦                   ¦ MAKE BACKUPS OF THE DATA FILES FIRST ¦                   ¦
¦                   +--------------------------------------+                   ¦
+------------------------------------------------------------------------------+
¦    (P)roceed without View, (V)iew Structure, (S)ize fields or (Q)uit ( )     ¦
+------------------------------------------------------------------------------+

ACCESS:

Press <8> on the Master menu, and <C> on the Utilities and Setup menu.
 

OPERATION:

The purpose of the correction/conversion program is to update the files with the latest format of the Sr ACCOUNTANT database files or to rebuild the existing files if they have become corrupted for some reason. The program will not destroy any important data, but it is a good idea to BACKUP the DATA FILES before proceeding.

Press:

The following screen will appear:
 
SA:CCP02                                                              4:39:30 pm
      +-----------------------------------------------------------------+
      ¦ C O R R E C T I O N  and/or  C O N V E R S I O N  P R O G R A M ¦
      +-----------------------------------------------------------------+
+------------------------------------------------------------------------------+
¦                                                                              ¦
¦                   : :  ALL database files except Archived files              ¦
¦                                                                              ¦
¦                   : :  Company profile file   (PARM.dbf)    [Feb/99]         ¦
¦                   : :  Master Account file    (MSTR.DBF)    [Apr/95]         ¦
¦                   : :  Names & Addresses file (NAMES.dbf)   [Dec/95]         ¦
¦                   : :  TRANSACTIONS database files          [Feb/99]         ¦
¦                   : :  BUDGET database files                [Feb/99]         ¦
¦                   : :  STATEMENT database files             [Feb/99]         ¦
¦                   : :  AUXILIARY database files             [Feb/99]         ¦
¦                   : :  SOURCE Control and TAX Rate files    [Feb/99]         ¦
¦                   : :  Outstanding Items and NOTES files    [Feb/99]         ¦
¦                   : :  SYSTEM PARAMETER database files      [Mar/99]         ¦
¦                                                                              ¦
¦                   : :  Archived database files                               ¦
¦                                                                              ¦
+------------------------------------------------------------------------------+
        Mark the files that need to be changed since your last update by
        placing an 'x' opposite file Name and press 'PgDn' when finished

Mark the files that need to be changed since your last update by placing an 'x' opposite file Name and press <PgDn> and <P> when you have finished your selection. To exit see below.

If you pressed <V>, a similar screen as shown below will appear:
 

 Records   Organize   Fields   Go To   Exit                           8:18:59 am
+------------------------------------------------------------+                  
¦FIELD_NAME¦FIELD_TYPE¦FIELD_LEN¦FIELD_DEC¦FIELD_IDX¦STANDARD¦                  
¦----------+----------+---------+---------+---------+--------¦                  
¦RDATE     ¦C         ¦       10¦        0¦N        ¦        ¦If STANDARD = 'NO'
¦APNO      ¦C         ¦        3¦        0¦N        ¦        ¦                  
¦APSRC     ¦C         ¦        2¦        0¦N        ¦        ¦This field is not 
¦ARNO      ¦C         ¦        3¦        0¦N        ¦        ¦part of the normal
¦ARSRC     ¦C         ¦        2¦        0¦N        ¦        ¦system. It may be 
¦INVNO     ¦C         ¦        3¦        0¦N        ¦        ¦needed by your    
¦INVSRC    ¦C         ¦        2¦        0¦N        ¦        ¦custom software.  
¦REA       ¦C         ¦        3¦        0¦N        ¦        ¦                  
¦REV       ¦C         ¦        3¦        0¦N        ¦        ¦Use:              
¦REVEND    ¦C         ¦        3¦        0¦N        ¦        ¦ 'PgUp' & 'PgDn'  
¦ANS       ¦C         ¦        1¦        0¦N        ¦        ¦to view all fields
¦CPN       ¦C         ¦        8¦        0¦N        ¦        ¦                  
¦CPD       ¦C         ¦       25¦        0¦N        ¦        ¦Press  'F10'  to  
¦PLT       ¦C         ¦        3¦        0¦N        ¦        ¦activate Menu     
+------------------------------------------------------------+                  
+--------------------------------------------------------------+
¦ You are about to correct the C:\TEST\SA\SAPARM database file ¦
+--------------------------------------------------------------+
Browse  ¦C:\test\sa\TEMPSTRU     ¦Rec 1/29         ¦File ¦ExclLock¦   Num    Ins

Press 'Ctrl'+'End' to accept this change or 'Esc' to Abort

Read the Database definitions to see what each of the above files are used for.

Care should be taken if you reduce the size of a field, you may lose some data.
You can add new fields, but check in the definitions to make sure they are not used in any of the databases files. You should not start your custom field with the letter 'M', because that field name is used internally in the system for the memory variable field names.

The length of the Date field type (D) will show the field length of 8, leave this as is because the system stores the date fields in an universal date format. The system knows that when you enter or print the date that the year is a four digit field.

Press <Ctrl>+<End> to accept your changes or press <Esc> to Abort any changes.

The computer will the rebuild the database file(s) you have selected. For example using the "SYSTEM PARAMETER database files" as an example:
 

¦                   : :  Outstanding Items and NOTES files    [Feb/99]         ¦
¦                   :x:  SYSTEM PARAMETER database files      [Mar/99]         ¦
¦                                                                              ¦
¦                   : :  Archived database files                               ¦
¦                                                                              ¦
+------------------------------------------------------------------------------+
¦                      (P)roceed or (Q)uit to System ( )                       ¦
+------------------------------------------------------------------------------+

This procedure will rebuild the following System Parameter files:

"SAPARM.dbf", SAGFR.dbf", "SAEXCH.dbf", "SAINDEX.dbf", "SAAUDIT.dbf", "SAHELP.dbf", "SAEHELP.dbf", "SAUHELP.dbf".

Read the Database definitions to see what each of the above files are used for.

The computer will return to the "SA:CCP02" screen.

EXIT:

Press <Esc> and <Q> to finish. The computer will return you to Windows or the DOS operating system.

[Contents]  [Top]  [Overview]  [Operations]  [Appendix]  [Index]