Overview
This article is to provide guidance on dealing with errors that have been encountered with Acumatica data sync and potential actions to take. This has been broken out into different sections Import Errors (Orders and Payments), To Website Errors, and Miscellaneous
Order and Payment Import Errors
Many times finding the error in the error trace is the key to identifying the issue. If you search for error in the error trace many times you can find the information needed to identify the issue. As an example the issue in the trace below is in the bold section just after “error”. In this case it is saying that Shipping Terms are required for this customer and do not exist.
Exection Level: [AcumaticaConnection::PostData] 1 – {“id”:”3b1f117f-7ff3-ee11-835f-0601fa1803eb”,”rowNumber”:1,”note”:{“value”:””},”error”:”Inserting ‘Sales Order’ record raised at least one error. Please review the errors.; Inserting ‘Sales Order’ record raised at least one error. Please review the errors.; CuryOpenTaxTotal: Tax is not up-to-date.”,”Approved”:{“value”:false},”BaseCurrencyID”:{“value”:”USD”},”BillToAddress”:{“id”:”e846b7b0-b5e4-4127-ba26-b7188da9548f”,”rowNumber”:1,”note”:null,”AddressLine1″:{“value”:”1800 NW 86th St”},”AddressLine2″:{“value”:”1800 NW 86th St”},”City”:{“value”:”Clive”},”Country”:{“value”:”US”},”PostalCode”:{“value”:”50325-7147″},”State”:{“value”:”IA”},”custom”:{}},”BillToAddressOverride”:{“value”:true},”BillToContact”:{“id”:”b8584e4c-2e76-42cc-bff3-bccf05fb6d86″,”rowNumber”:1,”note”:null,”Attention”:{“value”:”Rob Schockemoehl”},”BusinessName”:{“value”:”Fireplace & Bbq Center – Clive”},”Email”:{“value”:”fireplacebbqcenter@yahoo.com”},”Phone1″:{“value”:”515-278-9278″},”custom”:{}},”BillToContactOverride”:{“value”:false},”CashAccount”:{},”ContactID”:{“value”:”121144″},”ControlTotal”:{“value”:3179.99},”CreditHold”:{“value”:false},”CurrencyID”:{“value”:”USD”},”CurrencyRate”:{“value”:1.0},”CurrencyRateTypeID”:{},”CustomerID”:{“value”:”C000787″},”CustomerOrder”:{“value”:”WILSON PROPERTI”},”Date”:{“value”:”2024-04-05T00:00:00+00:00″},”Description”:{“value”:”Non-Standard Shipping Address. PLEASE SHIP TO THE DESMOINES ADDRESS SHIPMENTS HAVE BEEN GOING TO THE WRONG LOCATION”},”DestinationWarehouseID”:{},”Details”:[{“id”:”ce354785-7ff3-ee11-835f-0601fa1803eb”,”rowNumber”:1,”note”:{“value”:””},”Account”:{“value”:”4000″},”AlternateID”:{“value”:”500002573″},”Amount”:{“value”:3179.99},”AutoCreateIssue”:{“value”:false},”AverageCost”:{“value”:1333.22},”Branch”:{“value”:”ROGERS”},”CalculateDiscountsOnImport”:{},”Commissionable”:{“value”:false},”Completed”:{“value”:false},”DiscountAmount”:{“value”:0.0},”DiscountCode”:{},”DiscountedUnitPrice”:{“value”:3179.99},”DiscountPercent”:{“value”:0.0},”ExtendedPrice”:{“value”:3179.99},”FreeItem”:{“value”:false},”InventoryID”:{“value”:”DX500002573″},”LastModifiedDate”:{“value”:”04/05/2024 19:05:53″},”LineDescription”:{“value”:”EVOLVE 50” IgniteXL Linear Electric Fireplace”},”LineNbr”:{“value”:1},”LineType”:{“value”:”Goods for Inventory”},”Location”:{},”ManualDiscount”:{“value”:false},”MarkForPO”:{“value”:false},”OpenQty”:{“value”:1.0},”Operation”:{“value”:”Issue”},”OrderQty”:{“value”:1.0},”OvershipThreshold”:{“value”:100.000000},”POSource”:{},”QtyOnShipments”:{“value”:0.0},”ReasonCode”:{},”RequestedOn”:{“value”:”2024-04-05T00:00:00+00:00″},”SalespersonID”:{“value”:”KEVINO”},”ShipOn”:{“value”:”2024-04-05T00:00:00+00:00″},”ShippingRule”:{“value”:”Back Order Allowed”},”TaxCategory”:{“value”:”TAXABLE”},”UnbilledAmount”:{“value”:3179.99},”UndershipThreshold”:{“value”:100.000000},”UnitCost”:{“value”:1367.40},”UnitPrice”:{“value”:3179.99},”UOM”:{“value”:”EA”},”WarehouseID”:{“value”:”40″},”custom”:{}}],”DisableAutomaticDiscountUpdate”:{“value”:false},”EffectiveDate”:{“value”:”2024-04-05T00:00:00+00:00″},”ExternalRef”:{},”Hold”:{“value”:true},”IsTaxValid”:{“value”:false},”LastModified”:{“value”:”2024-04-05T19:05:53.507+00:00″},”LocationID”:{“value”:”W002″},”OrderedQty”:{“value”:1.0},”OrderNbr”:{“value”:”W100871″},”OrderTotal”:{“value”:3179.99},”OrderType”:{“value”:”WO”},”PaymentMethod”:{“value”:”CHECK”},”PreferredWarehouseID”:{},”ReciprocalRate”:{“value”:1.0},”RequestedOn”:{“value”:”2024-04-05T00:00:00+00:00″},”ShippingSettings”:{“id”:”401c8e27-152c-4ba4-b7c7-928c786223c5″,”rowNumber”:1,”note”:null,”CancelByDate”:{“value”:”2024-10-12T00:00:00+00:00″},”Canceled”:{“value”:false},”FOBPoint”:{},”Freight”:{“value”:0.0},”FreightCost”:{“value”:0.0},”FreightCostIsuptodate”:{“value”:true},”FreightTaxCategory”:{},”GroundCollect”:{“value”:false},”Insurance”:{“value”:false},”OrderVolume”:{“value”:0.000000},”OrderWeight”:{“value”:90.960000},”PackageWeight”:{“value”:0.0},”PreferredWarehouseID”:{},”PremiumFreight”:{“value”:0.0},”Priority”:{“value”:0},”ResidentialDelivery”:{“value”:false},”SaturdayDelivery”:{“value”:false},”ScheduledShipmentDate”:{“value”:”2024-04-05T00:00:00+00:00″},”ShippingRule”:{“value”:”Back Order Allowed”},”ShippingTerms”:{“value”:””,”error”:”Shipping Terms ” cannot be found in the system.”},”ShippingZone”:{},”ShipSeparately”:{“value”:false},”ShipVia”:{},”UseCustomersAccount”:{“value”:false},”custom”:{}},”ShipToAddress”:{“id”:”e846b7b0-b5e4-4127-ba26-b7188da9548f”,”rowNumber”:1,”note”:null,”AddressLine1″:{“value”:”108 JEFFERSON AVE”},”AddressLine2″:{“value”:””},”City”:{“value”:”DES MOINES”},”Country”:{“value”:”US”},”PostalCode”:{“value”:”50314″},”State”:{“value”:”IA”},”custom”:{}},”ShipToAddressOverride”:{“value”:true},”ShipToContact”:{“id”:”b8584e4c-2e76-42cc-bff3-bccf05fb6d86″,”rowNumber”:1,”note”:null,”Attention”:{},”BusinessName”:{“value”:”FIREPLACE CENTER”},”Email”:{“value”:”fireplacebbqcenter@yahoo.com”},”Phone1″:{},”custom”:{}},”ShipToContactOverride”:{“value”:true},”ShipVia”:{},”Status”:{“value”:”On Hold”},”TaxTotal”:{“value”:0.0},”Totals”:{“id”:”9d004dca-3d1a-4fd4-a71b-4f7551ed6c09″,”rowNumber”:1,”note”:null,”DiscountTotal”:{“value”:0.0},”LineTotalAmount”:{“value”:3179.99},”MiscTotalAmount”:{“value”:0.0},”TaxTotal”:{“value”:0.0},”UnbilledAmount”:{“value”:3179.99},”UnbilledQty”:{“value”:1.0},”UnpaidBalance”:{“value”:3179.99},”custom”:{}},”custom”:{}}|~|——————————————–|~| at CIMcloud.ERPDriver.ERP.Acumatica.AcumaticaConnection.PostData(String endpoint, String jsonData, String method) in C:BuildAgentwork5d7c42bf576c3d9esrcCIMcloud.ERPDriver.ERP.AcumaticaAcumaticaConnection.cs:line 294
at CIMcloud.ERPDriver.ERP.Acumatica.Orders.ImportData(_iSalesOrderData SalesOrderData, _PullDataFromWebService_Config ImportConfig) in C:BuildAgentwork5d7c42bf576c3d9esrcCIMcloud.ERPDriver.ERP.AcumaticaDataImportOrdersOrders.cs:line 98
Common Errors:
“message”:”You are not logged in.” – The standard API for Acumatica requires re-authentication on a regular basis. The import process is designed to automatically do this. There are times when the timing of this matches an order import and you may get this error. All you need to do is re-export the order.
To Website Errors
Error on Change tracking – If the config will run a full export but errors when trying to do an incremental update, this is likely due to an issue with the change tracking fields. Make sure the field(s) on the GI in Acumatica directly match those on the corresponding ERP config. The field is case sensitive for this so make sure the cases match as well.
System.Threading.ThreadAbortException – This error may indicate an issue with Acumatica and the oData layer. If all configs are erring and you see this error, try and hit the configs outside of erp driver with Postman to see if data returns. If you still see this error with this, it means there is an issue with Acumatica. The time this was seen the customer was able to restart Acumatica and the error cleared.
Miscellaneous
Around Acumatica version 2023R1 to 2023R2 the Order import process no longer automatically populates the Item name(Desc) onto the order detail line on order import. If upgrading to or past these versions check and verify the import needs to include this.