Sage 100

Trying to copy a company (Company Maintenance) in Sage 100 Premium 4.50.7. I can copy ABX and other companies, but not one specific one. Tried just copying CI and GL modules and it fails copying the GL. I looked at the SQL permissions and they look good. Can use all modules with the company, but just can't it. Is there a repair utility to try? Any ideas? Next step to to call Sage

we've had issues with the ""next"" company key in sql and had to manually change that or basically our new company would use the key from an old company and screw things up. I can't remember if that key is in sy-system or another system table, but I would find and check that key and made sure it's not being used already by another company

@AlnoorCassim ??

Of course I am a fan of syzcon and replacing the embedded io (embedded io replacement script) for all module codes including the SY and LM. I like to call it ""no harm no foul"" repair tool. Is there is an error message returned or in the activity log. Can you create a new company code, activate the necessary modules and then copy over to this new company code. (just a few cents worth but I hope it helps).

Created new company and activated modules. Tried to copy GL module and after verifying data, the error SY_ActivityLog not found appears. I was able to copy a different company without an error. No entry in the activity log.

If possible click on Info and post the error info here

Error information:

Not 100% sure but appears like it's trying to open the options table in the destination company which doesn't exist of course. On the Info screen click on Debug and type at the -> prompt: ? optTable$ ? pthOtherCompany$ ? cDSTCompanyCode$ The 1st command prolly will show CI_Options or GL_Options table. Then look back at the source company in SQL Mgmt Studio and see if anything unusual on the table. E.g. instead of seeing the table as dbo.GL_Options maybe you see it as: <someOtherUser>.GL_Options

Looked at GL_Options and didn't see anything out of place. I am able to copy other companies to TST, just not company NSI. So, I'm doubting that it is an issue with the destination company. I used the debug commands and got the following. Also GL Transaction Detail reports are taking foever to run. One account for one month 45 minutes.

I was saying the problem might be in the source company (NSI) GL_Options. Can't tell for sure w/o a closer look.

What will this command do? File / Run / syzcon - O=NEW(""SY_ACTIVATION_BUS"",%SYS_SS) / Hit Enter PRINT O'ACTIVATE(""G/L"",""NSI"")

It's the embedded IO script @JoanSerr was referring to. It would make the G/L tables match the dictionary. So depending on what is wrong with GL_Options in NSI it may be able to fix it. This is where I would normally say make a copy company of NSI but that would be a circular reference.

WIll run on Saturday and report back,

The script returned 0, unsuccessful.

Myron, were you able to get through this matter? I don't see anyone replying to the script return of zero. (at the prompt following the 0, type ? o'lasterrormsg$)

Resolution - The GL wouldn't copy because the GL_Options file was still in the MAS_XXX\GL folder. During the migration to SQL, this file should have been removed, but wasn't. Vicky Siebert at Sage found the resolution on this. After migration to SQL, make sure the company data files have been purged of those tables moved to the SQL database. I don't think the custom GL financial Providex data files are moved to SQL, but most others are. If you get an error message when copying companies and the file cannot be found, it might be in the MAS_XXX\XX folder and needs to be deleted.