Issues with Web Services in Sage 100 Version 2020

Posted By Steve Krueger over 2 years ago

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

Steve Krueger over 2 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel
Kevin M over 2 years ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Reply

Kevin M over 2 years ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Children

Steve Krueger over 2 years ago 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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Cancel

Sage 100

Issues with Web Services in Sage 100 Version 2020

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING