Sage 100

 View Only

  • 1.  Convert data for all companies ... doesn't

    Posted 09-23-2023 16:31

    I've upgraded a client from v2017 to v2023.  There are ... 569 company codes to convert.

    When I select each company code, it will convert it correctly.  However, when I check the box for Convert Data For All Companies, it goes through the list of companies, 'acknowledges the ones that are converted' by showing in the message box as it looks to see what's to be done, skips most of them and the comes back with "There are no data conversions required for the selected companies". 

    Please help.  I don't want to have to select each company individually.  10 down, 549 to go.

    Thanks, Robert



    ------------------------------
    Robert White
    Munjal White Consulting Corp
    Toronto ON
    ------------------------------


  • 2.  RE: Convert data for all companies ... doesn't

    Posted 09-23-2023 17:16

    The CompanyType flag is missing in SY_Company so it's skipping companies without that.  I guess that conversion program missed setting that



    ------------------------------
    Robert White
    Munjal White Consulting Corp
    Toronto ON
    ------------------------------



  • 3.  RE: Convert data for all companies ... doesn't

    Posted 09-23-2023 17:33

    If any developer out there is feeling generous, I'm looking for an SYZCON command that will let me update CompanyType = 'L' within SY_Company, I'd be forever in your debt!

    Thanks, Robert



    ------------------------------
    Robert White
    Munjal White Consulting Corp
    Toronto ON
    ------------------------------

    Original Message


  • 4.  RE: Convert data for all companies ... doesn't

    Posted 09-23-2023 18:25

    If you can export the list of Company Codes, Visual Integrator should work for an import (you can set CompanyType = L). Or you can use DFD&M if you're truly desperate. 



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 5.  RE: Convert data for all companies ... doesn't

    Posted 09-23-2023 18:31
    I never thought of VI.  Doh. 

    I had started the DFDM path ! 

    In my head I was wishing for SQL and completely blanked out in VI as an option 

    Thank you 

    Sent from my iPhone



    Original Message


  • 6.  RE: Convert data for all companies ... doesn't

    Posted 09-23-2023 18:33

    Exactly, my first thought was switch'em to Premium!



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 7.  RE: Convert data for all companies ... doesn't

    Posted 09-23-2023 18:32
      |   view attached

    VI package attached. You can use "SYCE" to export all companies to a file and then job "SYY" to import that file and set all companyTypes to 'L'.



    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Attachment(s)

    EXP
    SY_CompanyPackage.EXP   90 KB 1 version
    Original Message


  • 8.  RE: Convert data for all companies ... doesn't

    Posted 09-24-2023 00:04

    Thank you everyone for your offer to help and input.  VI into the SY_Company table was possible and I was able to update the missing CompanyType which was preventing the conversion of all companies.



    ------------------------------
    Robert White
    Munjal White Consulting Corp
    Toronto ON
    ------------------------------



Related Content