Sage 100

 View Only

  • 1.  Sage 100cloud 2020 Premium w/CRM - entering zip code does not populate STATE

    Posted 08-27-2020 10:52
    I have a brand new upgrade where they are integrated to Sage CRM using the standard Sage integration for Sage 100 2020.

    They have called noting that when they create a new customer and supply the zip code in the address field they see it populate ONLY the CITY. The State is left BLANK. 

    If they try to go back into that customer through Sage - AR - Main - Customer Maintenance - and add in the state to the customer record they can save it but when they go right back to that customer the state is blank again.

    THINGS I'VE TRIED

    - Reset panels all users / all companies
    - Enter a test customer record myself through server (I'm not a CRM user ) - CANNOT duplicate

    Anyone seen this?

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------


  • 2.  RE: Sage 100cloud 2020 Premium w/CRM - entering zip code does not populate STATE

    Posted 08-27-2020 11:16
    Wasn't the International addresses affecting the zip code?  Not all 'states' in other counties have zip codes.

    ------------------------------
    Moira Goggin
    Executive Director
    90 Minds, Inc.
    ------------------------------



  • 3.  RE: Sage 100cloud 2020 Premium w/CRM - entering zip code does not populate STATE

    Posted 08-27-2020 11:32
    Isn't there an issue with CRM around 2 vs 3 digit country codes? Could that be it?

    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    Toronto ON
    ------------------------------



  • 4.  RE: Sage 100cloud 2020 Premium w/CRM - entering zip code does not populate STATE

    Posted 08-28-2020 10:59
    I'm still looking at this. Some of the Zip Codes have blank country codes. I'm going to need to test a little further to see if I can hit on the exact combo causing this issue because it works fine for me but not for some other users.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



  • 5.  RE: Sage 100cloud 2020 Premium w/CRM - entering zip code does not populate STATE

    Posted 10-12-2020 15:34
    We are still looking at this issue. It seems that Sage could reproduce the issue although I'm not sure if they have reached the conclusion that the problem is on their end. 

    For now, it appears that we need to make changes only in Sage 100 and if the issue occurs remove the zip code and save the record and then re-add the zip code and save.

    We tried a rebuild on the data from the CRM side and it caused some issues where the country codes on about 1,400 records were changed from USA to UK.

    Not sure what's happening. We are on Sage 100 2020 and I believe the R1 version of CRM.

    ------------------------------
    Wayne Schulz - Schulz Consulting - 860-516-8990
    ------------------------------



Related Content