# Utilities # Backup Database Utility for backing up the Computerlink Database # Backup - Appendix F ### **Appendix F. Backup** ### **F.1 Overview** It is essential that a backup of the database is performed on a regular basis, preferably as part of your daily tasks at the close of business every day. The backup is usually performed on the non server terminal (If available), and creates . A compressed (zipped) version of the database on terminal performing the backup. . A compressed (zipped) version of the database onto a USB Flash drive. This process may be automated as part of the end of day automation process. See separate notes available for this feature. ### **F.2. Performing a Backup.** You perform a backup by. 1\. Making sure that you close all programs including Computerlink on all terminals. 2\. Inserting the USB Flash Drive into the designated USB Port of the backup terminal. (to maintain the drive letter designation for the flash drive, always use the same USB port for backup.) 3\. Locating the Computerlink Backup icon on the desktop 4\. Double Click the Computerlink Backup icon. (a black dialogue box is displayed) 5\. Pressing ESC key when backup has been complete. A zipped copy of the database will be located in c:\\CLbackup folder and on the Flash Drive. To confirm that there is a backup on the Flash Drive. Double Click on the Computer Icon on the Desktop. Double click on the USB drive Icon you should see a zip file on the drive DAT00.zip with the date and time of when it finished the back up. Ensure that you right click on the up arrow Windows 7 task bar find the USB Icon click on this and eject the USB Drive. When the computer advises, that it safe to do so. # Change Tender Type Utility ### **Change Tender Type Utility** From the Main Computerlink Menu select the Utility pulldown. [![tender util1.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/tender-util1.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/tender-util1.jpg) The following screen will then be displayed [![tender util2.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/tender-util2.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/tender-util2.jpg) Enter your receipt number or invoice number Press **F10** to alter record Please note that the total tendered cannot be altered only tender type for the particluar receipt number or invoice number Press **f12** to save . # Consolidate Transactions Utility ### Consolidate Transaction Utility This utility enables the consolidation of cash sale transactions for each item into a single transaction for each day. Prior to running this utility please ensure that you have done a backup of your Computerlink database ( see instructions for backing up Computerlink Database) and have packed the Computerlink Database. (see instructions for Packing the Computerlink Database) **Please ensure that all other computers other than the server computer are totally out of** **Computerlink.** From the Main Computerlink Menu select the Utility Pulldown. [![consolidate util1.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/consolidate-util1.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/consolidate-util1.jpg) The Following screen is then displayed. [![consolidate util2.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/consolidate-util2.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/consolidate-util2.jpg) The Date last Consolidated will be highlighted. If it has been a long time ie several years since a consolidation was done, it is better to do several smaller steps than trying to do it in one step as you will come in the next morning and the consolidation will still be processing. If uncertain please contact Computerlink Support for assistance. Enter the Date to Consolidate to Press the **enter** key. NB: Once you consolidate you will not be able to go back and look at individual cash sale transactions. Press the **Process** Button to start the consolidation process. Once the the Consolidation is completed: **Pack and Reindex the Database** (see Pack and Reindex Database for further information) ( If uncertain please contact Computerlink Support for Assistance). # Customer Code Change Utility ### Customer Code Change Utility From the Main Computerlink Menu Ribbon at the top of the screen select the Utility Pulldown Menu. The picture below shows the options available select the Customer Code change option. [![customer code util1.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/customer-code-util1.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/customer-code-util1.jpg)The Screen shown below will now be displayed. [![customer code util2.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/customer-code-util2.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/customer-code-util2.jpg) The Original Customer Code is Now highlighed enter the Customer Code that you wish to change, Alternatively pressing the **F4** Search Key allows you to choose and select the Customer that you wish to change. The Customers name and address are displayed on the right side to ensure that you choose the correct customer. To Enter the New Customer Code you need to Press the **F10** to alter key. Enter the Customer Code. The System Message “ Customer Code is Not on file‐Create with Yes or No options will appear” The Change Code Button is now highlighted Pressing the Change Code button will now process and change Original Customer code to the New Customer Code that you have chosen. Pressing the Cancel button returns you to the Main Computerlink Screen. # Product Code Change Utility ### Product Code Change Utility From the Main Computerlink Menu Ribbon at the top of the screen select the Utility Pulldown Menu. The picture below shows the options available select the product code change option. [![prod code util1.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/prod-code-util1.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/prod-code-util1.jpg) The Screen below will be displayed. [![prod code util2.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/prod-code-util2.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/prod-code-util2.jpg) The Original Product Code Field is highlighted enter the product code to be changed or alternatively press F4 and search for the product and then select it. Press **F10** to enter Alter Mode . The Change to New Product Code Field is highlighted Enter your new product code. If you are happy to change the code select the change code button. If the product code that you choose is a totally new product you will get a system message appear which says *“This* *product code does not exist in the inventory file. Select OK to change to this New Code or* *CANCEL to find an existing product code.”* The Change Code Button is now highlighted, pressing the Change Code button will change the product code in the system Alternatively choosing the cancel button cancels the product code change A Pop up box is displayed asking whether you wish to save the changes this has the option of a Yes Button a No Button or a Cancel Button. Select No if you choose to cancel the transaction. This will return you to the main Computerlink Menu. The Cancel button returns you to the Product Code Change Utility Screen. # Product Group Code Change Utility ### Product Group Code Change Utility From the Main Computerlink Menu Ribbon at the top of the screen select the Utility Pulldown Menu. The picture below shows the options available select the Product Group Code change option. [![prod group util1.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/prod-group-util1.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/prod-group-util1.jpg) The Screen shown below will now be displayed. [![prod group util2.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/prod-group-util2.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/prod-group-util2.jpg) The Original Group Code is Now highlighed enter the group that you wish to change, Alternatively pressing the **F4** Search Key allows you to choose and select the Product group that you wish to change. Please note the writing in red in the Product Group Change Utility. *“All Products within the Old group will be changed to the NEW group* *All transactions created in the OLD group will also be changed to the NEW Group”* To Enter the new Group Code you need to Press the **F10** to alter key. Enter the New Group Code. The System Message “ Product Group Not on file‐Create with Yes or No options will appear” The Change Code Button is now highlighted Pressing the Change Code button will now process and change Original Group code to the New Group Code that you have chosen. Pressing the Cancel button returns you to the Main Computerlink Screen. # Supplier Code Change Utility ### Supplier Code Change Utility From the Main Computerlink Menu Ribbon at the top of the screen select the Utility Pulldown Menu. The picture below shows the options available select the Supplier Code change option. [![supplier code util1.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/supplier-code-util1.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/supplier-code-util1.jpg) The Screen shown below will now be displayed. [![supplier code util2.jpg](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/scaled-1680-/supplier-code-util2.jpg)](https://docs.computerlink.com.au/uploads/images/gallery/2023-08/supplier-code-util2.jpg) The Original Supplier Code is Now highlighed enter the Supplier Code that you wish to change, Alternatively pressing the **F4** Search Key allows you to choose and select the Supplier that you wish to change. To Enter the New Supplier Code you need to Press the **F10** to alter key. Enter the New Supplier Code. The System Message “ SupplierCode is Not on file‐Create with Yes or No options will appear” The Change Code Button is now highlighted Pressing the Change Code button will now process and change Original Supplier code to the New Supplier Code that you have chosen. Pressing the Cancel button returns you to the Main Computerlink Screen.