Issues with Web Services in Sage 100 Version 2020

Client upgraded from 2018 to 2020 and now can't import CAN (Canada) orders due to default Zip Code issue.

Creating customer and importing sales order via Web Services.

AR_Customer_bus column ZipCode$ is adding the default country code from Company maintnenace.  If we import Country CAN and Zip Code T8N5T8 it tries to validate USAT8N5T8 and throws and error that its not on file.  Not sure how to get CAN instead of USA for this validation although we have Country Code CAN as part of the customer file.  If I change the default country code in company maintenance then CAN orders import but USA orders don't...

Then....SO_SalesOrderDetail_Bus field TasAmt does not exist in this record.  I beleive this is a Sage error in Tas verses Tax for the field name?

  • Sage is indicating a defect in Version 2020 Web Services not allowing a 6 character zip code?  How can this be when it worked in Version 2018.  Of course International Address support was added to version 2020.  Works for Visual Integrator but not Web Services.

  • in reply to Steve Krueger

    It's probably the order things are set.  Country now needs to be done first, before ZIP, which is something you can change in a VI job but is controlled by Sage for Web Services.

  • Are you sure the Canadian Postal Codes were installed on the new version?  You have to select it separately during the installation.

  • in reply to hyanaga

    Yes.  That's not the issue.  Sage is passing the default Country Code from Company maintenance with Zip Code for validation instead of the country code from the import.  Orders will work fine whatever the default country code is in company maintenance.

  • in reply to Kevin M

    Tried changing the order but defect in Web Services using default country code from company maintenance instead of the country code from the import file.  Works fine for whatever default country code is in company maintenance.  Change to CAN and import works for CAN but not USA and visa versa.