Sage 100

 View Only
Expand all | Collapse all

HELP! What system file holds the conversion record

  • 1.  HELP! What system file holds the conversion record

    Posted 01-10-2022 17:20
    What file or files hold the information that the data has been converted for a given company?

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------


  • 2.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 17:24
    Under the MAS_xxx folder there are conversion files for each level.

    ------------------------------
    Dana Halpin
    Vrakas/Blum Computer Consulting, Inc.
    ------------------------------



  • 3.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 17:27
    I need to know the file/files in DFDM.

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------



  • 4.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 17:39
    It appears in SY_Activation as well as in each company's and module's options files.  Wouldn't be surprised if it is still stored in some of the other legacy files under SOA.

    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 5.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:18
    @David Speck II 
    I'm at a loss.  I've checked the company SY_Company record and all the modules' options and they all specify the correct version 6.20.  ​Do you have any idea where in the code that prompts the message that the Data Files haven't been converted whenever you access any menu item in Sage?

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------



  • 6.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:21
    Did you check SY_Activation?  These records are by CompanyKey so you might want to use crystal reports to join it with SY_Company to get the company code/name.


    ------------------------------
    David Speck II
    Tennessee Software Solutions
    ------------------------------



  • 7.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:36
    @David Speck II  sorry I forgot to say that I did check sy_activation and its level is correct.  ​

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------



  • 8.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:42
    Try sy0ctl.soa in the SOA folder. It's from ancient times (hate to admit my age here) but just last week I had to edit a record out. Sage100 kept thinking a module was still installed even though it was uninstalled 3 versions ago. the file is cryptic so you might need to scroll and search the various record types to get to the installed modules and their versions.

    ------------------------------
    Kenny Daniel
    TechnoClarity, Inc.
    ------------------------------



  • 9.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:48
    Edited by Jane Scanlan 01-10-2022 18:50
    @Kenny Daniel

    I did try to go through the SY0ctl. file, which gave me a nice reminder of how much I hate that file of conglomeration of cryptic records.  ​  In the records I was able to identify that hold a version/level all looked good, but it's possible I missed one or more record.  I finally was able to kick people out and run the data conversion from Company Maintenance so that people could work again.

    I'm a little suspicious of the Job Cost module, as this company never had Job Cost but now shows it installed.  Something is whacky.  Hate this stuff.

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------



  • 10.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:53
    Suggest taking a look at CI_EnhancementActivation in the company data directory.  






  • 11.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 18:56
    There are zero records in that file @Randy Marion.​

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------



  • 12.  RE: HELP! What system file holds the conversion record

    Posted 01-10-2022 19:19
    Happy Day -- thank you everyone and lastly @Alnoor Cassim!

    Somewhere along the way the Job Cost module got triggered, but never activated fully (or something like that).  I was able to run the actual Data Conversion program from company maintenance (even though there shouldn't have been any data to convert) , and then noticed the JCxxx.notsetup folder on the ​network.  I went back into company maintenance and removed the JC module, and once I did I then could perform a company data copy from the live company to a test company.   THE END.

    @Robert Wood you can move this out of urgent now.​

    ------------------------------
    Jane Scanlan
    Partner
    Next Level Manufacturing Consulting Group
    Chanhassen MN
    952-210-7758
    ------------------------------