Introducing Acumatica Cloud ERP: 2026R1
Technical discussions focused on Web Services and APIs for developers
Recently active
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.co
We’re integrating with a multi-tenant Acumatica (MYOB Advanced) instance. There are two companies (CompanyOne and CompanyTwo). For each tenant, I created a separate Connected App with its own client ID and secret.Setup: Using OAuth Authorization Code flow Generating an access_token for each tenant’s Connected App Using that token to call the REST API Issue: REST API calls sometimes return data from the wrong tenant. For example, calling with CompanyOne’s token occasionally still returns data from CompanyTwo. Behavior is inconsistent: if both tokens have expired and I refresh them, tenant separation works correctly for a while, but later the API “sticks” to CompanyTwo again.
For a webhook that has been registered with an endpoint in Acumatica (24R1), how does a non-developer discover the interface for documentation/testing purposes outside of requesting it from the developer or having access to the underlying class in the VS project? The customization project only has the DLL in it, and there is no option on the screen to view the interface definition or to generate a swagger file. Thanks.Added: Additionally, is there a way for a developer to read/consume the webhook endpoint in order to generate a stub for the interface?
I am trying to add record through a webhook, it works on my local but on production it gives me 500 internal server error.
I am currently writing a small C# console app in Visual Studio to pull GI records from a GI that is exposed through OData. I have been searching through documentation and cannot seem to figure out what I need to actually login to Acumatica in order to access the OData.Right now I can use the URL of <Acumatica ERP instance URL>/t/<TenantName>/api/odata/gi but I get a 401 error for not being signed in. I tried creating a JSON payload to login using <Acumatica ERP instance URL>/entity/auth/login but I keep getting a 500 error for invalid credentials. I am unsure if my URL is wrong, or I do not have the right things in my payload, or maybe I am trying to set up the HTTP Client all wrong. Does anyone have knowledge in this area or a link to a complete/updated guide?My ultimate goal is to find records from this GI based on a certain condition, and then use the REST API to generate the report for each record and save it a separate folder.
After I downloaded the example from Acumatica/Help-and-Training-Examples: Examples from the Acumatica ERP developer guides and training courses while I am running code, I get an error message. The type or namespace name 'PX' could not be found (are you missing a using directive or an assembly reference?)definitely I am missing the references which is clear, from where should I get these. here is the version I got installedAcumatica Cloud ERP 2025 R1Build 25.100.0054
I’m trying to refresh the screen AR303000 after I updated the customer status via REST-API. This is my API-Call (PUT):{ "CustomerID": { "value": "XXXX" }, "Status": { "value": "A" }}Right now the user has to manually refresh the screen to see the new status value. If the user changes the customer data without hitting refresh he receives an error.Is there any possibility to refresh the screen after the customer object is updated by the REST call?
I want to be able to save multiple PackageContents for an SOShipment in a single API call, but I’m getting odd results. I have the following Body for my PUT REST API request{ "Packages": [ { "PackageContents": [ { "ShipmentSplitLineNbr": { "value": 11 }, "Canister": { "value": 8 }, "Position": { "value": "Bottom" } }, { "ShipmentSplitLineNbr": { "value": 17 }, "Canister": { "value": 8 }, "Position": { "value": "Bottom" } }, { "ShipmentSplitLineNbr": { "value": 19 },
My task: Update two custom fields in the operation record named JBStartDate and JBEndDateThe Process: programmatically put the production order on hold, update the operations, release the production order from hold.Accomplished: put the production order on hold and release the production order from holdError encountered: updating the operation record (specifically the custom fields JBStartDate and JBEndDate)JSON: {"OrderType" : {"value": "RO" },"ProductionNbr" : {"value" : "MFG000007-000" }, "Operations" : [{"id" : "c24f0a14-d742-f011-8429-129114ee79ef", "JBStartDate" : { "value" : "2025-10-16T13:24:51Z"}, "JBEndDate" : { "value" : "2025-10-22T11:26:39Z"} },{"id" : "c64f0a14-d742-f011-8429-129114ee79ef", "JBStartDate" : { "value" : "2025-10-22T11:26:40Z"}, "JBEndDate" : { "value" : "2025-10-23T11:57:16Z"} },{"id" : "ca4f0a14-d742-f011-8429-129114ee79ef", "JBStartDate" : { "value" : "2025-10-23T11:57:17Z"}, "JBEndDate" : { "value" : "2025-10-29T07:14:05Z"} }]}Error Message returned (th
Hi I am trying to update the purchase order line details via API call below using the GUID:Request Type: PUTURL: https://{URL}/entity/Integration/23.200.001/PurchaseOrder/5ad3671b-217f-f011-ac46-0a3ddcc27c8dThe above GUID used in the request URL is the purchase order related one. Body:{ "id": "5ad3671b-217f-f011-ac46-0a3ddcc27c8d", "Type": { "value": "RO" }, "OrderNbr": { "value": "SPC005897" }, "Details": [ { "id": "d109d928-217f-f011-ac46-029be7b75a6f", "VesselName": { "value": "TEST" }, "DepartureDate": { "value": "2024-01-15T00:00:00Z" }, "ETA": { "value": "2024-02-20T00:00:00Z" }, "FirstFreeDay": { "value": "2024-02-22T00:00:00Z" }, "LastFreeDay": { "value": "2024-02-25T00:00:00Z" }, "ContainerNumber": { "value": "CONTAINER1
Hi Team,We have a requirement to create Issues(IN302000) via API calls and insert line details along with a custom field, but without mapping the custom field in the Web Service Endpoint. Currently, when we use a PUT request, the Issue is created with the line details, but the custom field is not being inserted. Could you please review this and suggest the best possible approach to achieve it.For your reference, we’ve attached the package and the Postman request.http://localhost/NAWEndpoints25.101.0153/(W(7))/entity/Default/24.200.001/InventoryIssue?$expand=Details{ "Details": [ { "InventoryID": { "value": "AACOMPUT01" }, "WarehouseID": { "value": "WHOLESALE" }, "Location": { "value": "R1S1" }, "Qty": { "value": 1.000000 }, "UOM": { "value": "EA" }, "custom": { "Transac
Hey everyone! New to acumatica REST API. Getting this error when trying to simply login using the HTTPClient in MS visual studio:StatusCode: 415, ReasonPhrase: 'Unsupported Media Type', Version: 1.1, Content: System.Net.Http.StreamContentGrateful for any assist on this.Thanks!
Im trying to get all expense receipt using GET https://{BASE URL}/entity/Default/22.200.001/ExpenseReceipt but nothing is returned on postman. Can any help ? what am I missing here?If i replace ExpenseReceipt with Vendor, I get a list of all vendors.
I have created a new local installation of Acumatica as a test bed and created a user with the hope of using OData access to pull the data from Acumatica. The user that I created was assigned the role of API user and the Tenant name is Company.I can log in as the admin user interactively but when I try to use Postman to simply get a list of OData exposed generic inquiries (I exposed one so there should be something on the list) I simply get the 401 Unauthorized response. The url I am trying to access is: http://localhost/ACUERP/t/Company/api/odata/gi/Please give me some direction on this.Thanks in advance!
Hi,What is last Acumatica supported version?Second moment, which I need to clarify, how to find out which endpoint version corresponds to Acumatica version ? Does any endpoint version can be imported for any Acumatica version or there are some rules and logic, which must be followed for correct work ?
Hi folks,I want to create a pivot from Generic enquiry where I want to do the below image have FY and YTD values. I have already created the GI but the YTD values and sometimes even the FY values are not correct. I am not sure what my formula can improve the result intended on the Pivot table is as follows:My formula for FY2022 is as below (Using AU financial year July to June):=Round(IIF(( [ARTran.TranDate] > Cdate('2021-06-30')) and ([ARTran.TranDate] < Cdate('2022-07-01')),[ARTran.CuryExtPrice],0),2)Formula for YTD is as below:=Round(IIF(( [ARTran.TranDate] > Cdate('2021-06-30')) and ([ARTran.TranDate] < Dateadd(Today(),'y',-4)),[ARTran.CuryExtPrice],0),2)I have attached my GI as well:Pivot table is as below: Any help or tips would be appreciated.
I’m trying to get some data using the Acumatica REST API, and while it works for some entities (StockItem, TaxCategory, Contact, Account) just fine, others (SalesOrder, SalesInvoice, or Customer) return 200 status with a json empty set returned ala []. Note: I CAN see data for SalesOrder, Customers, etc, using my normal login in the standard UI.Does this sound like a permission issue on the APIUSER user account that is calling the REST API?Thanks for your time, Paul
Hi there,I am currently trying to resolve a API call to enter a activity on a customer. I have tried referring a few articles online. One of them was as below.https://www.postman.com/flight-geoscientist-57391170/celigo-pakcage/request/wgijcfd/create-an-activity-that-is-linked-to-a-customerMy postman call is as below:https://{URL}/entity/Default/24.200.001/Activity/{ "Summary": {"value": "Automated Test 2"}, "Type": {"value": "N"}, "RelatedEntityNoteID": {"value": "a474872e-1378-f011-ac49-0a202afc9b19"}, "RelatedEntityType": {"value": "PX.Objects.AR.Customer"}, "ActivityDetails":{"value": "Automated Test 2"}, "RefNoteID":{"value": "CUST000001, BA Industries"}}My error is: 406 not acceptable. My I please get some tips in this regards.
Can someone know how to update acumatica order's delivery status, timestamp, signature image (URL or attachment) and optional delivery notes/photos using restapi?Thanks in Advance
Basically, I’m looking to build something similar to the Tenant select combo box on the standard Acumatica login screen.Is there an API call that will return the tenant list of an Acumatica instance?
What is the proper format for a DateTime parameter when using OData against a GI that has parameters.A simple sample would be getting a list of customers modified since a certain date / time, assuming parameter name is ModDate. ParametersCondition to apply parameterODataDateText_WithParameters(ModDate=2025-06-01) == 500 - Specified cast is not valid.ODataDateText_WithParameters(ModDate='2025-06-01') == 404ODataDateText_WithParameters(ModDate=2025-06-01T00:00:00Z) == 400 (problem with : )I’ve tried other formatting techniques such as URL encoding the values, encoding the entire parameter string, even asked AI, but that just sent me in circles trying the same things over and over, getting the same results.The only hack I’ve found is to have the parameter derive it’s type from a text field (such as Account Name), and then pass in the value as a string : Mapping to a string schema fieldODataDateText_WithParameters(ModDate='2025-06-01') == works when parameter is mapped to a string field i
Hello. Is it possible to create the Active directory user via API or Import scenario. The import doesn't create the user, even though it completes the import. Failing on the API side as well - I can create the native user but not API
hey everyone hope all good I’ve a PO with “OPEN” Status, i want to create purchase receipt I’ve added new action to the endpoint I’ve added new field “OrderNbr” so i can add that to by request to find the PO This is my endpoint request https://company/entity/vendorpolineitems/22.200.001/purchasereceipt/AddPOOrder Http body request { "entity": {}, "parameters": { "OrderNbr": { "value": "PPO-05298" } } }Error Message "message":"An error has occurred.","exceptionMessage":"Operation failed","exceptionType":"Thanks
I am trying to update a custom field in a Sales Order line using the REST API, but I’m encountering the following error:API URL:http://localhost/AcumaticaDA/entity/DefaultExt/24.200.010/SalesOrder?$expand=Details&$select=OrderType,OrderNbr,Details/InventoryID,Details/LineNbr Method: PUTJSON Payload:{ "OrderType": { "value": "SO" }, "OrderNbr": { "value": "000183" }, "Details": [ { "LineNbr": { "value": "1" }, "MetaData": { "value": "Updated via CBAPI" } } ]}Error Returned:{ "message": "An error has occurred.", "exceptionMessage": "The given key was not present in the dictionary.", "exceptionType": "System.Collections.Generic.KeyNotFoundException" } Has anyone encountered this issue before? Is there something wrong with the structure of the payload or the custom field name?Any help is appreciated!
Post data migration process, I was trying to sync credit cards from Authorize.net to our Acumatica 2024 R2 version, but the process ends with error:“E00001: An error occurred during processing. Please try again. The profile in the received response is empty. Please try to send a request later.”I would appreciate any suggestions might help to overcome this issue. Thanks
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.