Make your own free website on Tripod.com
Sr Accountant tm  Global Find & Replace
SA:GFR01                                                              2:31:50 pm
+--------------------------------------------------------+
¦ Sr ACCOUNTANT - G L O B A L  F I N D  &  R E P L A C E ¦
+--------------------------------------------------------+
+------------------------------------------------------------------------------+
¦                                                                              ¦
¦ This program allows you to FIND any G/L # in the databases and REPLACE them  ¦
¦ with a new G/L #.                                                            ¦
¦                                                                              ¦
¦ If the new G/L is already in the master files, the information from the OLD  ¦
¦ G/L and the NEW G/L will be added together, except if you have designated it ¦
¦ as a Control account.                                                        ¦
¦                                                                              ¦
¦ If you use the bulk method of changes, they will be process by ORD+NGL, take ¦
¦ care when changing Old # to New # that have and Old # as well. Use the ORD   ¦
¦ field to contol the order of processing. Blank ORD will process first.       ¦
¦                                                                              ¦
¦        C H E C K   Y O U R   E N T R Y   D A T A   C A R E F U L L Y         ¦
¦         +----------------------------------------------------------+         ¦
¦         ¦ C A U T I O N: BACKUP DATA BEFORE RUNNING THIS PROCEDURE ¦         ¦
¦         +----------------------------------------------------------+         ¦
+------------------------------------------------------------------------------+
¦         Do you want (B)ulk changes, (S)ingle change or (R)eturn ( )          ¦
+------------------------------------------------------------------------------+

Access:
Press <8> on the Master Menu and <G> on the Utilities and Setup menu.

Operation:

BULK CHANGES:

CAUTION:  Backup your data first !!!

If you wish to change a large number of transactions with the same G/L account number to a different account number, press <B>.

+------------------------------------------------------------------------------+
¦ (B)rowse the SAGFR file, (L)oad GLs, (P)roceed with updates or (R)eturn ( )  ¦
+------------------------------------------------------------------------------+
Press <B> to browse the existing SAGFR.dbf file.


Press <L> to load all the existing G/L accounts into the SAGFR.dbf file.
 
          Enter starting GL :          :                                                  
          Enter ending   GL :          :                                                  

          Leave fields blank for all                                                      

Enter the starting and ending G/L account. If you want a single sub-ledger, enter first account (e.g. 120) and ending account (e.g. 120zzzz) of  the sub-ledger.



Press <P> to view the existing SAGFR.dbf file.
 
Records   Organize   Fields   Go To   Exit                           4:25:47 pm
¦NGL    ¦OLD_GL ¦CHG¦CTL¦ORD ¦NEW_NAME                 ¦OLD_NAME               ¦
¦-------+-------+---+---+----+-------------------------+-----------------------¦
¦100    ¦100    ¦   ¦   ¦    ¦                         ¦Cash on Hand           ¦
¦101    ¦101    ¦   ¦   ¦    ¦                         ¦Cash on Hand (US)      ¦
¦101XUS ¦101XUS ¦   ¦   ¦    ¦                         ¦US Cash Exchange       ¦
¦105    ¦105    ¦   ¦   ¦    ¦                         ¦Petty Cash             ¦
¦110    ¦110    ¦   ¦   ¦    ¦                         ¦Cash in Bank           ¦
¦111    ¦111    ¦   ¦   ¦    ¦                         ¦Cash in Bank (US)      ¦
¦111XUS ¦111XUS ¦   ¦   ¦    ¦                         ¦US Bank Exchange       ¦
¦120    ¦120    ¦   ¦   ¦    ¦                         ¦Accounts Receivable    ¦
¦121    ¦121    ¦   ¦   ¦    ¦                         ¦Accounts Receivable (US¦
¦121XUS ¦121XUS ¦   ¦   ¦    ¦                         ¦US Receivable Exchange ¦
¦130    ¦130    ¦   ¦   ¦    ¦                         ¦Inventory              ¦
¦140    ¦140    ¦   ¦   ¦    ¦                         ¦Investments            ¦
¦160    ¦160    ¦   ¦   ¦    ¦                         ¦Automotive Equipment   ¦
¦161    ¦161    ¦   ¦   ¦    ¦                         ¦Less: C.C.A.-Auto. Equi¦
¦165    ¦165    ¦   ¦   ¦    ¦                         ¦Furniture & Fixtures   ¦
¦166    ¦166    ¦   ¦   ¦    ¦                         ¦Less: C.C.A.-Furn.& Fix¦
¦170    ¦170    ¦   ¦   ¦    ¦                         ¦Equipment & Tools      ¦
¦171    ¦171    ¦   ¦   ¦    ¦                         ¦Less: C.C.A.-Equip.& To¦
+------------------------------------------------------------------------------+
Browse  ¦C:\test\sa\SAGFR        ¦Rec 1/65         ¦File ¦ExclLock¦

Press 'Ctrl'+'End' to exit or 'Esc' to switch to MSTR file

Enter the New General Ledger account number in the "NGL" browse field.

If the New General Ledger account number is a Control Account entry a <Y> in the "CTL" browse field.

If you wish to cause one account number to change before an other, enter a number in the "" browse field [see the IMPORTANT Notice below].

Press <Esc> to switch to browsing the Master (MSTR.dbf) file in order to lookup and account or see what account numbers are available.

Press <Ctrl>+<End> to exit the browse screen and  return to the following message:

+------------------------------------------------------------------------------+
¦ (B)rowse the SAGFR file, (L)oad GLs, (P)roceed with updates or (R)eturn ( )  ¦
+------------------------------------------------------------------------------+

Press <R> if you want to exit the "Global Find & Replace" procedure, the work you have done will not be lost and you can return to finish it at a later time.

Press <P> to proceed with the "Global Find & Replace", the following screen will appear:

+----<SYSTEM DIRECTORIES>-------------------------------------------- 1:47:23 pm
¦    Are you using "Sr ACCOUNTANT - Sales Order System"         (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Open Receivable System"     (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Purchase Order System"      (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Accounts Payable System"    (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Invoice System"             (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Inventory Contol System"    (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "G S T back! Program"                        (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "MAILTIME Program"                           (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Do you want to send changes to another SAGFR or SAGFRA     (Y/N) :Y:      ¦
¦           Drive\Path> :C:\TEST\VR\                             :             ¦
¦    Year/month of Oldest Historic file :1903:    Change ACCTNO (Y/N) :N:      ¦
¦                                                                              ¦
+------------------------------------------------------------------------------+
¦      (P)roceed, (D)irectory of Historic files, (C)orrect or (R)eturn ( )     ¦
+------------------------------------------------------------------------------+
This screen allows you to tell the  "Global Find & Replace" program which other Sr Accountant System and/or Custom written database systems are located. If you have a Custom system, you will need to write a custom program called SAGFRA.PRG and install it in the folder where the _____ is located.
Make sure you end the "Drive\Path> :    ..." entry field in a '\' (back slash) [e.g. C:\ZSC\SA\  ].
If you have Historic files that you wish to change account numbers in, press <D> to see which is the oldest files that you wish to go back to, then enter it in the "Year/month of Oldest Historic file :    :" entry field.
Place a <Y> in the "Change ACCTNO (Y/N) : :" entry field, if you wish to change the ACCTNO field in the NAMES.DBF file in all the selected systems.


Press <R> to return to the "Utilities and Setup menu".


SINGLE CHANGES:
CAUTION:  Backup your data first !!!

If you wish to change a small amount of account accounts numbers to change, press <S> on the initial "Global Find & Replace" screen.

The next screen to appear will be:
+----<SYSTEM DIRECTORIES>-------------------------------------------- 1:47:23 pm
¦    Are you using "Sr ACCOUNTANT - Sales Order System"         (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Open Receivable System"     (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Purchase Order System"      (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Accounts Payable System"    (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Invoice System"             (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "Sr ACCOUNTANT - Inventory Contol System"    (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "G S T back! Program"                        (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Are you using "MAILTIME Program"                           (Y/N) :N:      ¦
¦           Drive\Path> :                                        :             ¦
¦    Do you want to send changes to another SAGFR or SAGFRA     (Y/N) :Y:      ¦
¦           Drive\Path> :C:\TEST\VR\                             :             ¦
¦    Year/month of Oldest Historic file :1903:    Change ACCTNO (Y/N) :N:      ¦
¦                                                                              ¦
+------------------------------------------------------------------------------+
¦      (P)roceed, (D)irectory of Historic files, (C)orrect or (R)eturn ( )     ¦
+------------------------------------------------------------------------------+
This screen allows you to tell the  "Global Find & Replace" program which other Sr Accountant System and/or Custom written database systems are located. If you have a Custom system, you will need to write a custom program called SAGFRA.PRG and install it in the folder where the _____ is located.
Make sure you end the "Drive\Path> :    ..." entry field in a '\' (back slash) [e.g. C:\ZSC\SA\  ].
If you have Historic files that you wish to change account numbers in, press <D> to see which is the oldest files that you wish to go back to, then enter it in the "Year/month of Oldest Historic file :    :" entry field.
Place a <Y> in the "Change ACCTNO (Y/N) : :" entry field, if you wish to change the ACCTNO field in the NAMES.DBF file in all the selected systems.
SA:GFR02                                                              1:59:32 pm
+--------------------------------------------------------+
¦ Sr ACCOUNTANT - G L O B A L  F I N D  &  R E P L A C E ¦
+--------------------------------------------------------+
+------------------------------------------------------------------------------+



Enter the Old and New G/L #:
+----------------------------+
¦ Old GL code :          :   ¦
¦                            ¦
¦                            ¦
¦----------------------------¦
¦ New GL code :          :   ¦
¦                            ¦
¦                            ¦
+----------------------------+

Is this a control account : :



Leave Old and New GL blank to exit or '?' in Old GL to view
Enter the Old GL number, then the New GL number, if this is a Control Account (Master Account for Payables or Receivables etc.), enter <Y> in the "Is this a control account : :" entry field.
IMPORTANT Notice:
You have to plan you changes carefully, you need to change the numbers so that you don't accidentally merge two or more accounts together.
e.g.
105 110
110 115
in this example 105 will change to 110, the 110 (which includes the 105 records) will change to 115. That will merger bothe accounts together. The correct way to change the account numbers is:
110 115
105 110
so that 110 changes before you change 105 to 110.
You can change an account number to an existing number, if you want to merge two accounts together.
The following message will appear:
+------------------------------------------------------------------------------+
¦                     (P)roceed, (T)ry again or (Q)uit ( )                     ¦
+------------------------------------------------------------------------------+
Press <P> to make the changes. This may take some time, depending on speed of your compter and the number and size of your databases.

The computer will return to the "Enter the Old and New G/L #:" screen allowing you to make more changes.

Once you are finish, leave the OLD and NEW entry fields blank and press <PgDn> to return to the "Utilities and Setup menu".



Exit:

Press <R> to end the procedure and return to "Utilities and Setup menu".


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