BOSEnterprise upgrades are released approximately every quarter and are named accordingly based on the year of release. Business Agents are notified of upgrades, and are encouraged to implement these upgrades for sustained improved performance and functionality of the application.

Continue to watch this space for upgrade notes.

Plus, find these topics on BOS Internal Docs:

• Migrating to Firebird 3.0.

• Running Firebird 2.5 and 3.0 side by side

For assistance with performing an upgrade please contact your Business Agent, or the QuickEasy Helpdesk.

Discover Upgrades

• Before you upgrade

• How to upgrade

Before you upgrade

Before upgrading it is important to check what the enhancements and fixes are in order to determine whether additional setups and user training will be required after the upgrade.

NB. Always test the upgrade on a copy of the live DB before commencing the live upgrade.

Upgrade Steps

• Get all the users to log out and delete the QuickEasy.exe to make sure nobody can login while you are upgrading.

• Backup the live database.

• Rename the live database - eg. Database_date.FDB - so that you don't delete the live DB when you restore the backup.

• Restore the Backup without checking the 'Replace' flag - that ensures your backup is working correctly and you can't erase the live DB (which you renamed).

• Open Tools.exe and download the upgraded QuickEasy.exe.

• Use Tools.exe to execute the Upgrade Script. NB If it's a major upgrade (eg. from Ver 2018 to Ver 2019), you need to first run the last Fix script for the current version before executing the Upgrade Script for the current version. See How to Upgrade below.

• Use Tools.exe to execute the last Fix script for the new version.

• Decompress and restore the new QuickEasy.exe to the QuickEasy folder.

• Test that the upgraded version is working correctly.

The Upgrade Process

1. Contact Helpdesk to schedule an appointment for a consultant to demonstrate the new version onsite or remotely using Teamviewer.

2. If, after the demonstration, you feel that upgrading will benefit your business, your consultant will prepare a quotation and schedule the upgrade.

3. A few days before the scheduled upgrade, our Helpdesk will obtain a copy of your database and run a test upgrade on it.

4. The upgraded copy of the database will be installed at your company for training users to ensure they are familiar with the new functionality before upgrading the live database. Every user should test the functionality they use on the new version, paying attention to new template layouts, upgraded reports, etc.

5. When all the users are comfortable with the new version, your consultant will upgrade the live database.

Testing the Upgrade

Run the old and upgraded versions next to each other and compare the following.

Accounting

• Ledger - Remove all the filters to view all the transactions and compare the Total, Allocated and Unallocated fields.

• Customer Age Analysis - Compare at current date as well as at a prior date.

• Supplier Age Analysis - Compare at current date as well as at a prior date.

• Trial Balance - Compare at current date as well as at a prior date in the previous financial year. Compare a full year as well as a few months in the year.

• Income Statement - Compare current period as well as a prior period.

• Balance Sheet - Compare current date as well as a prior date.

Inventory

Compare total stock levels at current date for all Categories in the BOSEnterprise Inventory modules.

Non-accounting Transactions

Open all the core non-accounting transaction types (Quote, Sales Order, Work Order, Purchase Order).

Remove the data filters to view all the transactions and compare the transaction count and totals.

Reports

Establish which reports are in use (in later versions, QuickEasy creates an Audit when a report is executed) and compare the old and upgraded report values.

If any discrepancies are found, investigate the cause of the problem so a solution can be found BEFORE upgrading the live database. This should be done before the upgraded demo is installed at the customer.

User Testing

Make sure that each QuickEasy user tests the functionality they use in the upgraded demo and let them sign off on it. This is also a way to establish the actual user-count in the company.

Same-Version Upgrade

If you are upgrading the same version of BOSPrint, you may be required to run the fix script. You can find it in the Fixes folder of the downloadable scripts folder or in QuickEasy Tools > Execute SQL Statement window.

The concept with the fix scripts in BOSPrint is that you only have one fix script for each numbered version, which can be executed multiple times. So every time you do a same-version upgrade (exe Upgrade), you simply run the Fix script for that version.

The Fix script only updates Triggers and Procedures, so it executes in a few seconds and can be run while users are logged into QuickEasy.

The Fixes are also updated to the main scripts, so when upgrading from an earlier version, you never need to execute the Fix scripts.

How to Upgrade

QuickEasy BOS will be upgraded by using QuickEasy Tools. You need to run the Fix script of your current version first and then the Script of the next version. Disconnect between script executions as a precaution.

You will need to know what is your current version of BOS before you start with the upgrade. Open QuickEasy BOS and navigate to Main Menu > Help > About QuickEasy Software. An Information window will pop up stating your current version. See image below:

Here is a step by step guide on how to upgrade

In this example we will upgrade QuickEasy BOS from Version 2017.03 to 2018.02 with QuickEasy Tools.

If you only need to execute a Fix follow step 1 to 9.

16. Right-click on the database and select Disconnect.

17. Right-click on the database and select Connect.

18. Right-click on the database and select Execute SQL Statements.

19. The Execute SQL Statements window will appear. Navigate to the top-right and click on the Menu button.

20. Select the same version of BOS script you executed. Select Scripts - BOSPrint 2018 again.

21. Double-click on the Fix of the version script you executed previously. In this case Fixes_BOSPrint_2018_01.sql

22. Execute the script and close the window.

23. Right-click on the database and select Disconnect.

24. Right-click on the database and select Connect.

25. Right-click on the database and select Execute SQL Statements.

26. The Execute SQL Statements window will appear. Navigate to the top-right and click on the Menu button.

27. Select the same version of BOS script you executed. Select Scripts - BOSPrint 2018 again.

28. Double-click on the Script of the next version of BOS. In this case Script_BOSPrint_2018.02.sql

29. Execute the script and close the window.

30. Right-click on the database and select Disconnect.

31. Right-click on the database and select Connect.

32. Right-click on the database and select Execute SQL Statements.

33. The Execute SQL Statements window will appear. Navigate to the top-right and click on the Menu button.

34. Select the same version of BOS script you executed. Select Scripts - BOSPrint 2018 again.

35. Double-click on the Fix of the version script you executed previously. In this case Fixes_BOSPrint_2018_02.sql

36. Execute the script and close the window.

37. Right-click on the database and select Disconnect.

Now you have successfully executed all the scripts from BOSPrint 2017.03 to BOSPrint2018.02. The final step is to download the new BOSPrint 2018.02 Executable from Tools.

38. Open Tools and navigate to Utilities > QuickEasy Downloads > select the BOSPrint_Exe_2018_02_7z and click on the Download button.

Upgrading the database form 2017.03 to 2018.02 is now complete.