Sale order zipcode import issue after upgrading from Sage 2018 to 2021

Hello,

We just recently upgraded to Sage 2018 to 2021 and our third-party web service(Deposco) sale order imports are now having issues after migration.

Error response: FAILED : Exception: Error trying to set property BillToZipCode$ with value 46550. Last error was US46550 is not on file. oSS Last Error Message: Error #12: File does not exist (or already exists) File: RA_Options so_bus Last Error Message: US46550 is not on file

The zipcode does exist within Sage. This all was working prior, but mapping must have changed

{
  "type": "sage100",
  "action": "POST",
  "callbackUri": "https://MWI.deposco.com/socket-server/rest/MWI/Sage 100 Integration/documents/860199/1--2/API_RESPONSE?status=READY&docStoreStatus=READY",
  "sageCompanyCode": "ACS",
  "companyFilePath": "E:\\SageApps\\Sage2021Prem\\MAS90\\MAS_DEP",
  "entity": "so",
  "module": "S/O",
  "body": [
    {
      "number": "1001542764",
      "id": "779809",
      "orderDate": "20230411",
      "type": "S",
      "status": "N",
      "shipExpireDate": "",
      "ARDivisionNo": "70",
      "customerNo": "WDEP332733",
      "createCustomerPerOrder": true,
      "billToName": "Kimberly Anderson",
      "billToAddress1": "13291 North 1025 West",
      "billToAddress2": "",
      "billToAddress3": "",
      "billToCity": "Nappanee",
      "billToCountryCode": "USA",
      "billToZipCode": "46550",
      "shipToName": "kimberly anderson",
      "shipToAddress1": "13291 N 1025 W",
      "shipToAddress2": "",
      "shipToAddress3": "",
      "shipToCity": "NAPPANEE",
      "shipToState": "IN",
      "shipToZipCode": "46550",
      "shipToCountryCode": "USA",
      "emailAddress": "[email protected]",
      "shipVia": "FREE SHIPPING",
      "customerPONo": "1001542764",
      "discountAmt": "4.49",
      "paymentTypeCategory": "D",
      "paymentType": "WEB",
      "otherPaymentTypeRefNo": "W",
      "depositAmt": "24.24",
      "freightAmt": "0.0",
      "weight": "0.0",
      "taxSchedule": "AVATAX",
      "orderLines": [
        {
          "lineNumber": "110--1",
          "itemCode": "110",
          "itemType": "1",
          "discount": "Y",
          "unitOfMeasure": "EACH",
          "quantityOrdered": 1,
          "unitPrice": 29.95,
          "extensionAmt": 29.95
        },
        {
          "lineNumber": "1001542764--REWARDS",
          "itemCode": "/REWARDS POINTS",
          "itemType": "5",
          "discount": "Y",
          "unitOfMeasure": "DOL",
          "costOfGoodsSoldAcctKey": "0000000EK",
          "salesAcctKey": "0000000EK",
          "quantityOrdered": -1,
          "unitPrice": 3,
          "extensionAmt": -3
        }
      ],
      "customFields": [
        {
          "name": "UDF_DEPOSCO_PULLED$",
          "value": "Y"
        },
        {
          "name": "BillToState$",
          "value": "IN"
        }
      ]
    },
    {
      "number": "1001542765",
      "id": "779810",
      "orderDate": "20230411",
      "type": "S",
      "status": "N",
      "shipExpireDate": "",
      "ARDivisionNo": "70",
      "customerNo": "WDEP332742",
      "createCustomerPerOrder": true,
      "billToName": "Kristina Brandle",
      "billToAddress1": "512 Garfield Avenue",
      "billToAddress2": "",
      "billToAddress3": "",
      "billToCity": "Carnegie",
      "billToCountryCode": "USA",
      "billToZipCode": "15106",
      "shipToName": "kolten ford",
      "shipToAddress1": "2231 IVY LN",
      "shipToAddress2": "",
      "shipToAddress3": "",
      "shipToCity": "CHESAPEAKE BEACH",
      "shipToState": "MD",
      "shipToZipCode": "20732",
      "shipToCountryCode": "USA",
      "emailAddress": "[email protected]",
      "shipVia": "FREE SHIPPING",
      "customerPONo": "1001542765",
      "discountAmt": "5.99",
      "paymentTypeCategory": "D",
      "paymentType": "WEB",
      "otherPaymentTypeRefNo": "W",
      "depositAmt": "33.96",
      "freightAmt": "0.0",
      "weight": "0.0",
      "taxSchedule": "AVATAX",
      "orderLines": [
        {
          "lineNumber": "182--1",
          "itemCode": "182",
          "itemType": "1",
          "discount": "Y",
          "unitOfMeasure": "EACH",
          "quantityOrdered": 1,
          "unitPrice": 39.95,
          "extensionAmt": 39.95
        }
      ],
      "customFields": [
        {
          "name": "UDF_DEPOSCO_PULLED$",
          "value": "Y"
        },
        {
          "name": "BillToState$",
          "value": "PA"
        }
      ]
    },
    {
      "number": "1001542934",
      "id": "779959",
      "orderDate": "20230411",
      "type": "S",
      "status": "N",
      "shipExpireDate": "",
      "ARDivisionNo": "70",
      "customerNo": "WDEP90481",
      "createCustomerPerOrder": true,
      "billToName": "Cindy Nickels",
      "billToAddress1": "1007 Cherokee Court",
      "billToAddress2": "",
      "billToAddress3": "",
      "billToCity": "Apex",
      "billToCountryCode": "USA",
      "billToZipCode": "27502",
      "shipToName": "cindy nickels",
      "shipToAddress1": "1007 CHEROKEE CT",
      "shipToAddress2": "",
      "shipToAddress3": "",
      "shipToCity": "APEX",
      "shipToState": "NC",
      "shipToZipCode": "27502",
      "shipToCountryCode": "USA",
      "emailAddress": "[email protected]",
      "shipVia": "FREE SHIPPING",
      "customerPONo": "1001542934",
      "discountAmt": "4.04",
      "paymentTypeCategory": "D",
      "paymentType": "WEB",
      "otherPaymentTypeRefNo": "W",
      "depositAmt": "24.57",
      "freightAmt": "0.0",
      "weight": "0.0",
      "taxSchedule": "AVATAX",
      "orderLines": [
        {
          "lineNumber": "1096--1",
          "itemCode": "1096",
          "discount": "Y",
          "unitOfMeasure": "EACH",
          "quantityOrdered": 1,
          "unitPrice": 26.95,
          "extensionAmt": 26.95
        }
      ],
      "customFields": [
        {
          "name": "UDF_DEPOSCO_PULLED$",
          "value": "Y"
        },
        {
          "name": "BillToState$",
          "value": "NC"
        }
      ]
    }
  ]
}

  • 0

    Changes to zip codes were made, for better handling of international addresses.  Country code is now part of the primary key for SY_ZipCode, and should be set prior to entering the ZipCode value.

  • 0 in reply to Kevin M

    Thank you for the response ! Should the SY_ZipCode be defined within the request? Also, would the country code be restricted to Alpha-2/3 or order set? In 2018 we had our country code take in just the zipcode, now is it requiring us to parse it in 2021(ie. USA92805 or US92805)? Getting mixed results with successful and failed imports.

  • 0 in reply to dnguyen

    If your Country / ZipCode is not found in the system table SY_ZipCode, it will be rejected.  Whether you want to deal with those manually, or set up a push of missing values into SY_ZipCode is up to you.

    Change the order you are setting the values.  Country first, then Zip, then State then City.

    If you set State and City before the Zip, Sage 100 will overwrite your values with what's in the SY_ZipCode table.