Develop Integrations with Web Services | APIs

Hello - We noticed that we have missing numbers in the sequence for our payments for one of our properties. They are creating automatically from the AP suggest next record, and no one has access to modify that setting. The system skips from reference number 7526 to 7528, skipping two reference numbers. The auditors caught this and are wondering the cause, and have deemed it an actionable issue. As far as I am aware, once a payment is created and a reference number assigned, it cannot be deleted, only voided, which still leaves the reference number. My question is, what possible scenarios could cause this, outside of someone changing the Last Reference Number on the payment method?  

Hi Team, I am working on creating task in task Screen. But while creating a body it shows me two errors. One in “” Owner cannot be empty even I have mention owner value in body. Second I can see that the "RelatedEntityType" and RelatedEntityNoteID. Can anyone guide me on that. I have attach the screen shots below”my query: http://local/AcumaticaSB/entity/Default/22.200.001/Task?$select=Body,Owner,Summary,RelatedEntityType,RelatedEntityNoteID 

Hi There,I have a query which for various reasons has quite a long filter parameter passed in the URL - in fact it exceeds the maximum length for a URL (which is something like a 1000 chars).It seems to be the idea that going forward you should be able to pass this in the body of a POST request (getting around the length limitation) and postfixing the URL with /$queryAs per Passing OData query options in request body - OData | Microsoft LearnHowever - when I do this with Acumatica - I get a “Method Not Allowed” error which smells of - this hasn’t yet been implemented?Is this correct? And if so - are there plans to do so?Many thanks,Daniel Graham

Hi all, I am developing integration with Acumatica for a 3rd party WMS. Currently, I am using the REST API to get all of the documents and stock items.What are the advantages of using OData over using the REST API?I am specifically curious about performance.  Thanks

I have a bunch of .NET “jobs” that sync and pull data from Acumatica for use in an external eCommerce website.I often hit the login rate limit error and have been told to make sure I logout after each iteration. I call the /identity/connect/token endpoint and pass in my client_id, secret, API Username and API Password with the grant type of password. Its a typical oAuth flow. In testing via postman, I have logged in, did a simple GET query to return some data...then call the logout endpoint (with my bearer token). It returns a 204 success status code. /entity/auth/logout The issue is, I can go back and call the GET query to return some data. I would expect that my bearer token would be invalidated and that GET call would fail. However, it still works. This leads me to believe that I am not truly being logged out. I am reading that I need to pass in a cookie to the logout call, but I can’t really find out how that works. I am not used to working with cookies in a typical oAuth pattern. 

I can delete a row fine if I use RecordId.  However, in the case I don’t have the exact RecordId, how do I delete a row using these values:{    "SalesPriceDetails": [        {            "InventoryID": { "value": "00000-00002" },            "PriceType": { "value": "Customer Price Class" },            "PriceCode": { "value": "VIP" },            "delete": true        }    ]} When I try this, it deletes the first InventoryID/PriceType it finds which will delete the wrong row if I have a row with a PriceCode like “WHOLESALE”.

I can create a Sales Price fine using the following PUT method in Postman:https://sandbox.com/AcumaticaERP/entity/Default/20.200.001/SalesPricesInquiry?$expand=SalesPriceDetails   However, the Warehouse always shows up blank when I pass in this body:{    "SalesPriceDetails": [    {        "InventoryID": { "value": "00099-00098" },        "Warehouse": { "value": "TEST001" },        "PriceType": { "value": "Customer Price Class" },        "PriceCode": { "value": "VIP" },        "UOM": { "value": "EA" },        "Price": { "value": "149.44" },        "Currency": { "value": "USD" },        "EffectiveDate": { "value": "2022-03-01T00:00:00-08:00" }             }]}

Hi, I’m trying to delete a log line using the defaultendpoint http://localhost/AcumaticaERP/entity/Default/20.200.002/AppointmentPostman callbut this is not working, is this the right procedure or is there any other way we can achive deleting the logs?Error: business account (00081) cannot be deleted as it is referenced in multiple tables.

I’m not able to access the Acumatica API, through Postman and also Power Automate Tried with both OAuth2.0 and Standard Authentication.I’ll paste the sample below - ++++++++++++++++++++++++++++++++++++++++curl --location 'http://23.19.244.91/AcumaticaERP/entity/Default/20.200.001/Customer?%24select=CustomerName&%24top=10'++++++++++++++++++++++++++++++++++++++++"message": "An error has occurred.",    "exceptionMessage": "Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.",    "exceptionType": "PX.Data.PXDatabaseException""innerException": {            "message": "An error has occurred.",            "exceptionMessage": "The wait operation timed out",            "exceptionType": "System.ComponentModel.Win32Exception",            "stackTrace": null        }++++++++++++++++++++++++++++++++++++++++++I was able to access them before, and It's been above 3 days this issue has started.Also, could you please provide me

Can I get some clarification regarding the point in the below screenshot? Thank you. 

I’ve tried using RecordID as a parameter in the following DELETE method in Postman:https://sandbox.com/AcumaticaERP/entity/Default/20.200.001/SalesPricesInquiry/SalesPricesInquiry/5143487However, I just get the following error:{    "message": "An error has occurred.",    "exceptionMessage": "Operation is not valid due to the current state of the object.",    "exceptionType": "System.InvalidOperationException",    "stackTrace": "   at PX.Api.ContractBased.EntityService.FillEntityImplWithKeys(String version, String name, EntityImpl entity, String[] keys)\r\n   at PX.Api.ContractBased.SystemContracts.V2.SoapFacade.PX.Api.ContractBased.IRestGate.FillEntityImplWithKeys(EntityImpl entity, String[] keys)\r\n   at PX.Api.ContractBased.SystemContracts.V2.RestController.CreateEntityFromKeys(String objectName, String idsString)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_1.<GetEx

Hey all.I’m looking for advice about entity restriction and cost allocation for multi entity customers. Let’s say we have Company A who has subsidiaries with Company B and Company C. An employee for company B might work on Projects setup on Company C, however they want to be paid out from Company B’s payroll, but keep Job Costing on Company C. Acumatica has different Companies and branches nested under those companies. I’m assuming what we need to do is filter the Projects for Company C based on some predetermined Branch configuration they have set up on our end when we establish the integration. However I’m not sure if there are any gotchas to this approach. Has anyone come across this before and have advice on how to handle it?

Hi,I want to trigger Sales Order remove hold action via REST API.End point : Posthttps://globalrubberindustrieslimited.acumatica.com/entity/SFEndPoint/22.200.001/SalesOrder/ReleaseFromHold{ "entity": { "OrderNbr": { "value": "SO000896" } }}But when request is triggered it shows an error.But , This So is already created.Can anyone help for this

Hello everyone!Following this material: Accessing Data in Generic Inquiries using Contract Based API’s (acumatica.com)I performed an exercise as detailed in the document and it works: However, when I create my own GI postman it does not return any results and I get this:The GI si basically two tables (POOrder and POLine) where you can see the detail that each PO contains. Do you have any idea what I am missing?Thank you very much for your support!Best regards.

Hello,I am attempting to create a PREmployeeSetting entity via the “Default/23.200.001/EmployeePayrollSetting” endpoint.My payload looks like this:{ "EmployeeID": { "value": "TEST1" }, "Active": { "value": "true" }, "TaxSettings": [ { "Name": { "value": "Social Security Number" }, "Required": { "value": true }, "Setting": { "value": "Employee_FED_SocialSecurityNumber" }, "State": { "value": "FED" }, "Value": { "value": "123123123" } } ], "CashAccount": { "value": "8000-1130" }, "ClassID": { "value": "HRLY" }, "PaymentMethod": { "value": "CHECK" }, "EmployeeTypeClassDefault": { "value": "true" }, "Compensation": [ { "Active": { "value": "true" }, "Earn

Hi, All I am trying to put notes on every customer. My login is successful but when I am trying to call put api through another script of python, its says you are not login in. I have attach my login code below. I have attach cookie in put request header but still it shows error. Any idea on this please. Thanks def login_to_acumatica():    # API endpoint    url = "http://my-company/AcumaticaSB/entity/Auth/login"    json_data = ({        "name": "ta",        "password": "Db}",        "tenat": "Store",        "branch": "",        "locale": ""        })    try:        # Send POST request with JSON body        response = requests.post(url,  json=json_data)        import re        # Check if the request was successful        if response.status_code == 204:            print("Login successful.")            print("Response:")            cookie = response.cookies              return cookie        else:            print("Login failed with status code:", response.status_code)    except Exception

Hi, I’m a retailer with a distributor using Acumatica for their ERP. They gave me a login so I can check inventory balances in real time, but as we carry thousands of their products I need an automated way to check stock level daily.I noticed that their implementation seems to have some web services enabled via a SOAP endpoint when visiting a “Web Services” link from the SP700000 screen ([clientname].acumatica.com/(W(1))/Soap/SP700000.asmx). I’m quite familiar with developing Python apps so I’ve been working on using this endpoint to pull their catalog down into a CSV file.So far I’m able to connect and authenticate to the endpoint and run GetSchema, but when I request the fields I want the endpoint just times out. Even if I specify just one Inventory ID the endpoint just times out eventually.Here’s my code for reference:import requestsfrom zeep import Clientfrom zeep.transports import Transportimport csvimport loggingimport sysfrom datetime import datetime# Set up logginglogging.basic

We have a project where the customer’s external system will be reading data from Acumatica via the REST Api regularly and often. Is there an alternative to using cookies, such as setting the connection up as a “known application” with a shared secret value?  So that their authentication comes with the request vs. having a login to get the cookie and then they have to store the cookie. I know that I can bump up the lifespan of a cookie, and maybe that’s my only option, but I’m curious if there is another way to grant access without the logon/logoff calls.

Is there a way to copy an endpoint that was created in a Test instance to a Prod instance? It does not appear these came over from a snapshot and I would have assumed they would.  Am I missing something or do these have to be manually recreated between instances?

hi, I am trying to get login using python code. My code is working fine in localhost. But when I am trying to do it with my company testing env . The login is raising Max retries error. I think This is because of logout. I tried same api in post man and it works fine over there.    HTTPConnectionPool(host='acusb.mycompany.local', port=80): Max retries exceeded with url: /entity/Auth/login (Caused by NameResolutionError("<urllib3.connection.HTTPConnection object at 0x000001FB3A068BD0>: Failed to resolve 'acusb.mycompany.local' ([Errno 11001] getaddrinfo failed)"))

My company uses a custom routing module that enforces cutoff times for sales order entry. We are experiencing issues because an API user is accessing our tenant from multiple time zones, but the cutoff time comparisons apparently weren’t built to handle these situations. To work around the issue, we’ve tried setting the user time zone preference (found under Users → Personal Setting). When accessing the site through the GUI, that time zone is used, regardless of login location. But for API access, it seems that the time zone of the login location overrides the user preference. Is there a way to control the time zone associated with an API login? Either by setting a user preference, or by specifying somewhere in the API request? Thanks!

This article lists field changes in the endpoints for 24R1: https://help.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=b49d1af2-80a7-4271-b421-ab64173eead8 For the field highlighted below, I cannot find it in the 24R1 DAC schema browser. I am not knowledgeable of endpoints. Would appreciate advise! 

How can I input data into the warehouse column in the MaterialDetail section of the BillofMaterial API through the API? I have successfully input data into BillofMaterial through the API, and the warehouse column in MaterialDetail API has been filled with "Warehouse": { "value": "PMS23" }, but the result does not appear. 

Hello, We just implemented Shopify for both ecommerce and POS and I’ve noticed an issue with the order type import on a few orders. I’m not sure why or how this is happening. On the Shopify Stores screen, we have our Order Type for Import set as WB for web orders, and then FI and FO are the POS order types. However, a few orders have come through with a different order type, MO for mail order.   The one common thing I have been able to find between these sales orders is that there are items included that are automatically fulfilled (for shipping orders) or items that are not automatically fulfilled (for in store orders). Has anyone else noticed this issue or resolved something like this? Thanks in advance!

Hi There Hope you are doing well I’m trying to retrieve project tasks based on some parameters but it throwing the error Endpoint : /ProjectTask?$filter=startswith(ProjectTaskID, '0LED') and ProjectID eq '000407' but the error i’m receiving is :    "exceptionMessage": "Incorrect syntax near the keyword 'AND'.",  Thanks