Sage 100

 View Only

  • 1.  v3.71 Migration issue

    Posted 10-25-2024 16:01

    Does anyone have any ideas on how to resolve this error in GL? I'm not able to convert the data to v4.0. I have deleted the account with the special character in v3.71 and it still picking these two accounts in the GL history files. I have deleted any records linked to these two accounts (GL1, GL5, GL8 and GL20). I ran all the rebuild utilities. No luck. 



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------


  • 2.  RE: v3.71 Migration issue

    Posted 10-25-2024 16:14

    Use Delete/ Renumber/ merge to merge the bad account into a valid account.  the utility should examine all of the tables that have the invalid account and change it.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------



  • 3.  RE: v3.71 Migration issue

    Posted 10-25-2024 16:49

    @Doug Higgs I will try that. What do I do about the account listed in the example that has no numbers or characters?



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------

    Original Message


  • 4.  RE: v3.71 Migration issue

    Posted 10-25-2024 16:57

    The first message indicates the invalid gl account contains a /.    The second message has a gl account with a / in it.  I would try that account.  If you already deleted it maybe add it back then run the utility.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 5.  RE: v3.71 Migration issue

    Posted 10-25-2024 17:10

    @Doug Higgs Still getting the same error during the migration about the blank and A\R -0-TH accounts.



    ------------------------------
    Shannon Stanley
    Sage 100 Consultant
    Ardent Consulting LLC
    ------------------------------

    Original Message


  • 6.  RE: v3.71 Migration issue

    Posted 10-25-2024 17:14

    Do you have the technical reference and support guide for 3.71?  If so I would look at every gl table and look for invalid account numbers.  If you don't have it I can upload the PDF later today.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 7.  RE: v3.71 Migration issue

    Posted 10-25-2024 17:15

    Also rebuild the GL key and sort files after deleting.



    ------------------------------
    Doug Higgs
    Midwest Commerce Solutions, Inc
    (312) 315-0960
    Chauffeur, Chef, and Personal Assistant to Sprinkles
    ------------------------------

    Original Message


  • 8.  RE: v3.71 Migration issue

    Posted 10-26-2024 10:28

    Sorry I'm likely going to repeat things that you've already tried - feel free to skip everything you've already tried.

    1. Run the InvalidAccountCharacters.RPT - https://drive.google.com/file/d/0B0TwfMghmCJ0Z0ptX0RXQWNkME0/view?usp=sharing&resourcekey=0-vpTwAEcTG12q8irwLHdtGQ

    2. Try using Crystal Reports to review for invalid characters. Plan B = print a big GL Detail Report to PDF using all years of data and search for invalid characters. Neither of this is perfect for finding this type of thing but they might be a good tool.

    3. It's not clear exactly what version of Sage 100 you are migrating to. You mention 4.0 and I'm unsure if that just means "4.x standards" or if you're actually using Sage 100 v4.0 as the first upgrade. Depending on whether you have payroll you may be able to go directly from 3.71 to 2017. I only mention this because (a) it saves you some conversion and (b) perhaps on a later releases of Sage 100 the conversion tools or utility is a bit better.


    3.x ->3.71->2017->2024.x



    ------------------------------
    Wayne Schulz
    wayne@s-consult.com
    Schulz Consulting
    (860) 516-8990
    CT
    ------------------------------



Related Content