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?

Parents Reply Children
  • 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.