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" } ] } ] }