Introducing Acumatica Cloud ERP: 2026R1
Technical discussions focused on Web Services and APIs for developers
Recently active
I’m trying to delete a value from an attribute. I’m trying by sending the attribute with the value needing to be deleted with the “delete” flag set to true. I’m getting back no error message at all, with a status of OK, but the value is not being deleted.I can manually delete the value via the GUI, but the REST API will not delete it.The JSON object being sent to the AttributeDefinition endpoint:{"AttributeID":{"value":"DKWHLWIDTH"},"Values":[{"ValueID":{"value":"3-3/4"},"delete":true}]}Any suggestions?
Hello,I'm working with the Acumatica API to create time entries for the **Employee Time Activities** screen (EP307000) using the **TimeEntry** endpoint. The UI displays a **WorkGroup** field for each activity, but I cannot find this field in the API contract, even after attempting to extend the endpoint.There is only Items objact in the list, and there is no WorkGroupID in the list. I checked fields with selector - the same situation - field unavailableHere are the details:- Acumatica Version: 2025-1 - API Endpoint: `TimeEntry`- Issue: The `WorkGroupID` field is visible on the **Employee Time Activities** screen but is not available in the `TimeEntry` API payload. I checked the default and extended API contracts, but the field is missing.- What I Tried: - Extended the `TimeEntry` endpoint in Customization Projects to include additional fields, but `WorkGroup` is not listed.Questions: 1. Is the `WorkGroup` field available in the `TimeEntry` API, or is it handled differently (e.g., deriv
I’m getting the following error when I try to create a Sales Order:Document cannot be saved. Document number (<NEW>) equals to the New Number Symbol of a Numbering Sequence. Please change document number.This doesn’t make sense since I want the system to set the Sales Order Nbr so I need to use <NEW> for the Order Nbr. Is this a configuration issue?
Hi everyone, I’m just getting started with the Acumatica REST API and have successfully set up a GET request to the Employee endpoint, which returns a list of employees. However, I noticed that the BAccountID field, which is linked via DefContactID, is not included in the response. I’d like to know if it’s possible to add this BAccountID field to the Employee endpoint, and if so, what’s the correct way to do it—should I use the Customization Project Editor, or is it something that needs to be handled in code? Thanks in advance for your help!
HiI want to add a segment value using apiI added the screen, and I am able to pull exiting data. I now want to add a value on the segment value
Hi all,My objective is to connect my java client with the SignalR Hub.I added a push-notification with Destination Type SignalR Hub as it is described here: Push Notifications: To Connect to the SignalR Hub.I use the following code snippet to connect my client with the SignalR Hub:String login = "<my_user>"; String tenant = "<my_tenant>"; String password = "<my_password>"; String basicAuthPlain = login + "@" + tenant + ":" + password; String encodedBasicAuth = Base64.getEncoder().encodeToString(basicAuthPlain.getBytes()); HubConnection hubConnection = HubConnectionBuilder.create("https://<my_x360_domain>/PushNotificationsHub") .withHeader("Authorization", "Basic " + encodedBasicAuth) .build(); hubConnection.start().blockingAwait(30, TimeUnit.SECONDS);... However, after executing start().blockingAwait() I receive the http status 401. Do I miss something? Can anyone tell me how I can sucessfully connect/authenticate the client? Thanks in advance
For some reason our RefreshToken is always expiring after 24 hours. Regardless of what we set in Connected Applications settings. We are using Resource Owner Password Credentials and RefreshToken is set to Absolute expiration 30 days. Our Acumatica version is: 2024R1 and installed locally. Any help is much appreciated
hi!we have a prospect who’s current POS system is lightspeed POS and they are looking to make the switch to acumatica. I was wondering if anyone else has any clients who use lightspeed pos and was able to successfully integrate with acumatica. I would love to hear your experience and what challenges you faced.
We are trying to create an integration with Acumatica API and we are encountering issues or weird behavior when updating multiple items in a parent record.For example when we try to update multiple contacts for a customer, it won't update the all contacts but only update the first one, but the weird thing is it picks up the values from the second item to update the first item, like the contact note field of second item will replace the contact note field of the first item, we are not sure if its bug or something.Anyone experience the same issues?Here is my sample Json payload for a Customer PutEntity endpoint, the note for ContactID: 100745 will replace the note for ContactID: 100743, but will not touch the second item.Seems like only first Contact gets updated.{ "id": "01a0c017-df7f-ea11-8175-b9d61cb73193", "Contacts": [ { "note": { "value": "Note for 100743" }, "ContactID": { "value": 100743 }, }, { "note": { "value": "Note f
Hi All,I am trying to set up a push notification to a Google Space webhook. I get an error that the format is incorrect - the error is generated from Google. Google does not like the format of the JSON that is sent.Does anyone know how to customize the JSON?
I am having issues setting the PrimaryContact on a BusinessAccount entity.We are building a customer application form where potentical customers can apply for an account. This data is going to flow into the Business Account entity as a “prospect. The application will contain their business information as well as a list of owners/authorized buyers. These owners will be added as associated contacts to the business account entity. I have all of that working via the RestAPI without much issue. The trouble I am having is setting the first owner (in the list of owners) as the PrimaryContact. I can’t get anything to work. Here are my order of operations: Create the BusinessAccount Iterate over the incoming contacts and create each new contact and associate them to the BusinessAccount ID Call and PUT against the newly created BusinessAccount and pass in the PrimaryContactID of the first Contact in the list from step 2. (this isn’t working) I am doing a PUT to {{MY-BASE-URL}}/entity/PHDCus
Good day,I have a client who would like to use Watsaap to send customer notifications, I have not been able to find something on the market, anyone have some suggestions?Thank you!
Hi all, we have a pretty large ACU implementation that ends up crawling to a halt. I am NOT the Acumatica owner in that, I do not support this system, another vendor does. We have written a robust integration that uses GI’s and OData to sync data to an external DB which is for the public facing eCommerce website. I use a combination of hot path and cold path data syncs. Hot paths are push notifications...so I get the data updates for some entities that way. The Cold path are syncs that run every 3 hours. This uses oData over the GI’s. These will reconcile any thing that might have been missed on the push notifications and other entities that don’t need to be as timely. All the syncs are delta/incremental updates. All of those queries are quite fast on a normal day. When there are system issues, these really slow down as well. These syncs have been in play for many many months. Almost untouched for the last 6-9 months. My issue is that we (for lack of better terms) are being blam
Some tables throw ‘The multi-part identifier could not be bound.’ when filtering by specific fields. Below is an example for Invoice filtering by BillToContactOverride. Attached is the SQL query executed by the API as retrieved from the request profiler. It looks like the generated SQL is incorrect. This is happening across multiple versions (tested v23 and v24). No customizations have been applied to the instance. DECLARE @P1 AS INT = -2147483648, @P2 AS INT = -2147483648, @P4 AS BIT = 1;SELECT TOP (1000) [Document_ARInvoice_ARRegister].[DocType] AS [DocType], [Document_ARInvoice_ARRegister].[RefNbr] AS [RefNbr], [Document_ARInvoice_ARRegister].[NoteID] AS [NoteID], NULL AS [NoteText], NULL AS [NoteFiles], (SELECT TOP (1) [DocumentNoteExt].[NoteText] FROM [Note] AS [DocumentNoteExt] WHERE ([DocumentNoteExt].[CompanyID] IN (1, 2)
Today all our PUT requests regarding Appointments seem to have stopped working via the REST API. We’re using a custom endpoint. Has anybody seen an error like this before? We are a bit stuck, as all the endpoints were previously working."message": "An error has occurred.","exceptionMessage": "Sequence contains more than one matching element","exceptionType": "System.InvalidOperationException","stackTrace": at System.Linq.Enumerable.SingleOrDefault[TSource](IEnumerable`1 source, Func`2 predicate)at PX.Api.ContractBased.EntityExportContextBuilder.GetDescriptorKeys(EntityImpl entity, String baseMappingKey, Boolean includeNulls) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityExportContextBuilder.cs:line 2064at PX.Api.ContractBased.EntityExportContextBuilder.TryDetermineDescriptorFromValues(EntityImpl entity, String baseMappingKey, EntityDescriptor& entityDescriptor, Boolean includeNulls) in C:\\build\\code_repo\\NetTools\\PX.Api.ContractBased\\EntityExportContextBuil
I am writing an iterface to pull open operations from Acumatica but I am finding that the planned setup time and planned run time doesn’t appear to be in the operation records. Where would I find these?
Hello, I'm new to API development and I need help with a specific query. In my current project, I can successfully retrieve all employees from the top list using $expand=Employees.My goal is to get the results from the bottom section (Overrides) which are linked to specific employees. In the UI form, when I click on Employee #1, the bottom window changes to show their specific overrides, and similarly for Employee #0.I've tried using $expand=Employees/EmployeesOverrides, but this returns Employee #0's overrides for Employee #1, which doesn't make sense.How can I properly query the API to get the correct overrides for each specific employee? I need to establish the proper parent-child relationship between each employee and their corresponding overrides.I've attached screenshots showing the UI interface and the API endpoint configuration for reference. Any guidance would be greatly appreciated!employee 0 overridesemployee 1 overrides
I got this error when i validate a Default endpoint without any extension, same with Admin user.Why?Thanks
Hello,In the Web Service Endpoint screen in 2020/R1, when I click on Validate Endpoint for endpoint Default/18.200.001, it executes for about a minute, then fails with this exception:Exception of type 'System.Web.HttpUnhandledException' was thrown. PX.Data.PXNotEnoughRightsException: You don't have enough rights on 'Select'. …Can anyone please shed some light on what is happening?
Hi, I am trying to save CustomerLocation including LocationContact.Address, the CustomerLocation gets saved but not the child object LocationAddress. I am using PUT.how to save CustomerLocation with Child object LocationContact.Address? var customerLocation = new CustomerLocation { AddressOverride = new BooleanValue { Value = false }, ContactOverride = new BooleanValue { Value = true }, Customer = new StringValue { Value = accountingData[0].EntityId.ToString() }, LocationID = new StringValue { Value = accountingData[0].Addressid.ToString() }, LocationName = new StringValue { Value = accountingData[0].Addressline1.ToString() }, LocationContact = new Contact(), Active = new BooleanValue() { Value = true }, }; customerLocation.LocationContact.Address = new Address() { AddressLine1 = new StringValue { Value = accountingData[0].Addressline1.ToString() }, AddressLine2 = new StringValue { Value = string.IsNullOrEmpty(accountingData[0].Addressline2) ? str
I would like to know if it is possible to send payment links to customers so they can pay their invoices through Stripe, integrated with Acumatica. Unfortunately, Acumatica Payments is not available in my region, so I am exploring alternative options to collect payments efficiently.thanks.
I want to use rest API to upload item prices against a vendor, can I directly upload to the “Supplier Price” without going through the worksheet hold and release route?
Hi Everyone,We are making an API calls to Acumatica like below but creating lot of API sessions and not logging out from Acumatica. Can you please review and help us on this? Log into Acumatica - Working Creating Sales Orders - Working Logout from Acumatica - Not workingPlease find the screenshot for reference.
Hi...we are in the middle of converting to Acumatica and I am just beginning to get into the API for integrating with our other internal systems.I have figured out how to use ODatav4 to read stock items. I even figured out how to use a “Navigation Property” (by trial & error) to pull in the item class description. Below is the current request broken down for readability.But now I also want to pull all of the Cross-References (customer item numbers) for a given inventory item. The Cross-References show as another DAC - INItemXRef - but there doesn’t seem to be any navigation property from the InventoryItem DAC to it. Can I pull in this related information with an $expand clause? Or do I just need to query the INItemXRef separately and combine them manually?Thanks!https://<company>.acumatica.com/ODatav4/<tenant>/PX_Objects_IN_InventoryItem?$select=InventoryCD,Descr,ItemStatus,BaseUnit&$filter=ItemStatus eq 'AC'&$expand=INItemClassByItemClassID($select=ItemClas
When I uploading an image using the API, the following error message occurs: Error 500: Internal Server Error.
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.