Unable to upgrade to SAGE 300 2024 Advance

Question

Hi All, 
 I am trying to upgrade one of my Client to Sage 300 2024 Advance version. When i try to upgrade, i get the following error: "You cannot upgrade because some of the features you currently use are not available in the Sage 300 Advanced. Oldest Year of Transaction Detail. Contact your Certified Consultant for the correct product to upgrade your General Ledger data.Source: 09:12:33 - General Ledger 7.1A". 
 Support advised us to set "Number of Years of History" to 7. This was already the case when i referred as shown below: 
 
 We are still unable to upgrade the company file to Sage 300 2024 Advance. 
 Has anyone else faced similar issues? 
 Is there a way to fix this without upgrading from Advance version to Premium?

DCrampton · Accepted Answer

Hello Dhiraj, 
 your client's data has 10 years of fiscal sets already. My guess is your client is running Premium Edition. 
 
 This dataset can only be opened in Premium, or you will need to run and click Delete Fiscal Set and transaction detail.. (you'd need to make a backup first).. or you'll need to upgrade your Sage 300 edition to Premium. 
 
 Regards, 
 DCrampton

Tim - Accsys Consulting · Answer

Hi Dhiraj Kumar I've done this a few times and its normal to encounter several incompatibilities starting with this one. You will need to: 
 
 Get all users out and run SQL and DB dump backups (as per DCrampton advice). In Microsoft SQL: 
 Delete from GLAFS (fiscal sets) where FSCSYR <= 7 years from the current fiscal year. This is to ensure the remaining fiscal sets are no more than seven years older than the current fiscal year. 
 Update GL01.YRNOPSTPR (oldest year of Transaction Detail) to a year >= 7 years from the current fiscal year. 
 Update GL01.YRLSTACTL (oldest year of Fiscal Sets) to a year >= 7 years from the current fiscal year. 
 
 Once this is done and attempt to activate the data in the new version of Sage 300, you may run into another incompatibility, resolve that then run into another etc etc. If you need help with with anything else just post back. 
 Good luck!...Tim.

Tim - Accsys Consulting · Answer

Hi Dhiraj Kumar 
 Dhiraj Kumar said: Will you be able to advise where i can find GL01.YRNOPSTPR & GL01.YRLSTACTL and how do i update them. 
 These are columns in table GL01 in the SQL company database. If you're not familiar with working with SQL databases I highly recommend you engage your Sage 300 business partner or consultant. Good luck!

Sage 300

Unable to upgrade to SAGE 300 2024 Advance

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING