Since we recently moved to an in-house database for Acumatica, creating Sales Orders using the RESTAPI is working correctly only 85% of time (instead of 100% of the time when the database was server-based). Now the address and contact info are missing sometimes. I am saving the JSON request and response which basically tells me that the override was nulled out even though the contact/addresses were submitted.
Question: is this a bug in the REST API? Is it being looked at?
Here’s my JSON request:
{"OrderType":{"value":"EB"},"OrderNbr":{"value":"\u003CNEW\u003E"},"CustomerID":{"value":"C10010471824"},"Description":{"value":""},"CustomerOrder":{"value":"666605896426-10073114154208"},"ExternalRef":{"value":"220297"},"PaymentMethod":null,"CashAccount":null,"FinancialSettings":{"OverrideTaxZone":{"value":true},"CustomerTaxZone":{"value":"CHANNEL"},"InvoiceNbr":{"value":""}},"BillToContactOverride":{"value":true},"BillToContact":{"Attention":{"value":"Test"},"Email":{"value":"test421@gmail.com"},"Phone1":{"value":"\u002B1315-617-3358"}},"BillToAddressOverride":{"value":true},"BillToAddress":{"AddressLine1":{"value":"3245 Test Rd"},"City":{"value":"Madison"},"Country":{"value":"US"},"State":{"value":"NY"},"PostalCode":{"value":"13402-9300"}},"ShipToContactOverride":{"value":true},"ShipToContact":{"Attention":{"value":"Test"},"Email":{"value":"test421@gmail.com"},"Phone1":{"value":"\u002B1315-667-3156"}},"ShippingSettings":{"ShipVia":{"value":"BESTWAYG"},"Priority":{"value":0},"ShippingTerms":{"value":"CASHIP"},"ShippingRules":{"value":"Back Order Allowed"}},"ShipToAddressOverride":{"value":true},"ShipToAddress":{"AddressLine1":{"value":"3245 Test Rd"},"City":{"value":"Madison"},"Country":{"value":"US"},"State":{"value":"NY"},"PostalCode":{"value":"13402-9300"}},"Totals":{"PremiumFreight":{"value":0.00}},"Details":[{"InventoryID":{"value":"999-4914-4910-KIT"},"LineDescription":null,"OrderQty":{"value":1},"UOM":null,"UnitPrice":{"value":296.9400},"ManualPrice":{"value":true},"DiscountAmount":{"value":0.0},"DiscountPercent":{"value":0.0},"Subaccount":{"value":"WEB"},"WarehouseID":null,"Location":null}],"DiscountDetails":null,"UsrIsFraud":null,"UsrSignifydFraudId":null,"UsrDeviceIPaddress":null,"UsrDeviceSessionId":null}
Here’s my response:
{"id":"840a6c97-8857-f011-80d0-00505698c18d","rowNumber":1,"note":{"value":""},"Approved":{"value":false},"BaseCurrencyID":{"value":"USD"},"BillToAddress":null,"BillToAddressOverride":{"value":false},"BillToAddressValidated":{"value":false},"BillToContact":null,"BillToContactOverride":{"value":false},"Branch":{"value":"CM"},"CashAccount":{},"ContactID":{},"ControlTotal":{"value":296.94},"CreatedDate":{"value":"2025-07-02T14:07:50.38-07:00"},"CreditHold":{"value":false},"CurrencyID":{"value":"USD"},"CurrencyRate":{"value":1.0},"CurrencyRateTypeID":{},"CustomerID":{"value":"C10010471824"},"CustomerOrder":{"value":"666605896426-10073114154208"},"Date":{"value":"2025-07-02T00:00:00-07:00"},"Description":{"value":""},"DestinationWarehouseID":{},"Details":[],"DisableAutomaticDiscountUpdate":{"value":false},"DisableAutomaticTaxCalculation":{"value":true},"EffectiveDate":{"value":"2025-07-02T00:00:00-07:00"},"ExternalRef":{"value":"220297"},"FinancialSettings":null,"Hold":{"value":true},"IsTaxValid":{"value":false},"LastModified":{"value":"2025-07-02T14:07:50.697-07:00"},"LocationID":{"value":"MAIN"},"NoteID":{"value":"840a6c97-8857-f011-80d0-00505698c18d"},"OrderedQty":{"value":1.0},"OrderNbr":{"value":"EB00172131"},"OrderTotal":{"value":296.94},"OrderType":{"value":"EB"},"PaymentMethod":{},"PaymentRef":{},"PreferredWarehouseID":{},"ReciprocalRate":{"value":1.0},"RequestedOn":{"value":"2025-07-02T00:00:00-07:00"},"ShippingSettings":null,"ShipToAddress":null,"ShipToAddressOverride":{"value":false},"ShipToAddressValidated":{"value":false},"ShipToContact":null,"ShipToContactOverride":{"value":false},"ShipVia":{"value":"BESTWAYG"},"Status":{"value":"On Hold"},"TaxCalcMode":{"value":"Tax Settings"},"TaxTotal":{"value":0.0},"Totals":null,"WillCall":{"value":false},"custom":{},"_links":{"self":"/entity/DefaultExtended/23.200.001/SalesOrder/840a6c97-8857-f011-80d0-00505698c18d","files:put":"/entity/DefaultExtended/23.200.001/files/PX.Objects.SO.SOOrderEntry/Document/840a6c97-8857-f011-80d0-00505698c18d/{filename}"}}
