7.27 [UPGRADE VER] Things need to Consider on Upgrade from Version 3 to Version 4.2016.789.736.

Before Upgrade

01. Hardware - For Workstation (Double the spec for Server)

- CPU

- Intel I5 & Above (min)

- Intel I7 & Above (Recommended)

- RAM

- 4 GB & Above (min) - Use Firebird Super Server Mode

- 8 GB & Above (Recommended) - Use Firebird Super Server Mode

- 16 GB & Above - Use Firebird Super Classic Server Mode

02. Very Old Version

- Upgrade to Version 483 - setup-483.exe

Reason: to skip the error "unsuccessful metadata update. New scale specified for column D_Stockvalue must be at most 4"

- Change Costing Method to Fixed Cost

- Upgrade to Version 554 - setup-554.exe

03. Script

- Script with Normal Calculation will only work - 95%

- Script with got Control by user/ UI Locking 100% can't work - Need To Redo again

04. Report

- Most 90% to SL/PH/ST data Entry report need go to Click Design & Save again

==> No need if using Version 696.685 & above

- Some might redesign again if preview had error

- All Stock & Stock Analysis/Management Report need to Redo - Existing Customise Report will be set as Custom in Report Designer

05. Grid Layout

- All Grid Layout need to reset again

==> Only Layout which set to Public & using below Version 551 can't Upgrade ==> Use Version 702.689 & above.

- All Report Grid Layout can't Save ==> Can save(some only) if using Version 696.685 & above

06. User Right

- All some of the user Access Right need to reset again

07. Document Number

- Make sure the Description & Format for Maintain Document don't had something like ' (eg Mar '01 not allow)

==> No need if using Version 732.704 & above

08. Firebird

- Must use Firebird 2.5.2 & above (if can install as Firebird Super Classic Mode (must be 16 GB & above RAM))

09. Time

- The bigger the database the longer the upgrade time taken

10. Non Stock Control Items

- There will be no more posting in Stock Transaction so you will unable to Print/Preview any record for Non Stock Control

Steps to Upgrade

01. Uninstall old Version SQLAccounting Version 3.

02. Install SQLAccounting Version 3 (483).

03. Login to Upgrade to 483.

04. Change Costing to Fixed Cost.

05. Backup all database, if can backup few copy for each database to different location.

06. Uninstall old Version SQLAccounting Version 3.

07. Install SQLAccounting Version 3 (554).

08. Login to Upgrade to 554.

09. Change back to the Original Costing Method.

10. Backup the database again to different location.

11. Uninstall SQLAccounting Version 3.

12. Uninstall Firebird.

13. Reboot.

14. Install Firebird 2.5.2 (if can install as Firebird Super Classic Mode (must be 16 GB & above RAM)).

15. Install SQLAccounting Version 4 - setup-7699.exe.

16. Setup the SQLAccounting Version 4 setting.

17. Restore all the database.

18. Login SQLAccounting Version 4. (might take very long time)

19. Backup the database & restore Back

20. Run Analysis Costing.

21. Go To Report Designer Click Design & Save back. ==> No need if using Version 696.685 & above

22. Backup the database & restore Back.

23. Uninstall SQLAccounting Version 4.

24. Install SQLAccounting Version 4 - Latest Version.

25. Login Each Database.

26. Run Analyse Data Integrity at Tools | Analyse Data Integrity...

27. Delete/Reset the Grid Layout if had the Layout Problem.

28. To upgrade to Version 5 refer to Version 5

===============================================================================================================================

Failure to Upgrade (after follow the above steps)

01. For Duplicate GL_Trans Generator Error

Solution:

- Run Patch-UpgradeVersion101-102Error.sql

02. For Error SY_Registry - Duplicate Value

Solution: