Develop Integrations with Web Services | APIs

I've been trying to generate my access token in the Acumatcia platform using the Authorization code flow but i am unable to generate it as it is raising me an error invalid client i have also tried the Resource owner password flow but still it is giving me the same error invalid client. I have generated the access code but when i am using that access code in authorization flow it is giving me an error . I have followed all the steps as told in their Acumatica Integration guide and made an client application in the acumatica , generated the client id and client secret.   Here i am using the post request to send in the request and is using the redirect uri of the postman only. By using the GET method i have generated the Authorization Code and was successful in it. Can anyone help me to resolve the issue of invalid client ?

Hello everyone I was hoping if someone could help me with this subject. We are using the Acumatica API for the upload of files in respect of  some payments.The thing is we can't attach files once an operation is closed, and we want to know if there is a workaround on this or an alternative that we can use to avoid this lock.Thanks for the help in advance.

Hi There,I am trying to run a REST query to retrieves some fields at AR Line Level (coming from ARTran) with a couple of fields coming from the ARInvoice header table.If I start just with the AR Tran part, I have this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'which works fine.I then try to add the expand clause to pull in the related information from AR Invoice. This gets me this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'&$expand=ARInvoiceByRefNbrwhich also works fine.However - lets say I only want to see the InvoiceDate - I add a select giving me this:/ODatav4/PX_Objects_AR_ARTran?$select=RefNbr,LineNbr&$filter=RefNbr eq 'AR012031'&$expand=ARInvoiceByRefNbr($select=InvoiceDate)BANG!And this rather exciting error message that I can’t make head nor tail of.   "innererror": {            "message": "Column DocType is not found in DAC ARRegister. ",            "type": "PX.Data.PXNotSupportedEx

Hi,I’m trying to test Acumatica’s OAuth Authorization flow using Postman. I need to implement an API that will generally be called from a website (our customer portal) and return some information from our company’s Acumatica via OData.I followed the steps in the I300 Web Services course: https://openuni.acumatica.com/courses/integration/i300-web-services-basic-data-retrieval/as well as in the reference documents: https://help-2021r1.acumatica.com/(W(2))/Wiki/ShowWiki.aspx?pageid=2930d2f7-e081-4d0e-8879-93907ce82607I am able to use the Resource Owner Password Credentials flow successfully, but we need to implement the Authorization flow, using a client_id + client_secret approach.I already created a Client in the Connected Applications screen, and set the flow to Authorization Code.Please correct me if I’m wrong: I understand that every time this API will be called, it will need to first request an authorization code from (GET) https://<Acumatica ERP instance URL>/identity/connect

Hi all, Hope you guys are doing good. I am trying to get customer data from my Acumatica instance using some script. Is there any API/endpoint available to get the customer screen field/data together and using code. Please guide me in this . Thanks

Hi everyone, is there a way to modify this License Monitoring Console in my local?I’m trying to use the acumatica api in my local and i’m getting “api login limit” response.

I have new payment processor installed in acumatica. When trying to import payment from bigcommerce. Got issue The payment could not be imported because the combination of the NMI (CREDIT_CARD) store payment method and the NMI store order payment method is not mapped to an ERP payment method for the USD currency or the mapping is inactive in the store settings.Please suggest what could be wrong?

I am trying to expose a Generic Inquiry as a REST endpoint. This Generic Inquiry has a filter parameter of date. When I try to call the endpoint from POSTMAN, it keeps on erroring out.I followed the instructions in acumatica help that tell you to encode the datetime   You should encode date and time values in URL format before passing them as the value of the parameter. For example, you can encode the current date and time by using the System.Net.WebUtility.URLEncode() method as follows: WebUtility.UrlEncode(new DateTimeOffset(DateTime.Now).ToString("yyyy-MM-ddTHH:mm:ss.fffK")).I have tried to call this using different syntax, but it looks like it is erroring out.The parameter is ReportDate and is of type datetime.  I have tried  1) $filter=(ReportDate eq datetime '2024-03-01T00:00:00.000')2) $filter=(ReportDate gt datetimeoffset '2024-03-01T00:00:00.000')3) $filter=(ReportDate eq datetimeoffset '2024-03-01T00:00:00.000')4) $filter=(ReportDate eq datetime '2024-03-01')Each of these cal

Hi Team,Line Details are not adding while creating shipment from REST API using custom endpoint.Below is the JSON used.Note: Tried same JSON using Default endpoint (22.200.001),line details are adding but ship via is not updating using the default endpoint.{    "Type": {        "value": "Shipment"    },    "CustomerID": {        "value": "ASHTEST"    },    "WarehouseID": {        "value": "MAIN"    },    "Operation": {        "value": "Issue"    },    "ShipmentDate": {        "value": "02/28/2024"    },    "Details": [        {            "OrderNbr": {                "value": "000041"            },            "OrderType": {                "value": "SO"            },            "OrderLineNbr": {                "value": 1            },            "InventoryID": {                "value": "DV1221"            },            "ShippedQty": {                "value": 1            },            "UOM": {                "value": "EA"            }        }    ],    "Packages": [        {           

I'm using the Acumatica RESTClient and Acumatica Default_22.200.001 libraries in building an API interface. I'm connecting to the Default endpoint. The Purchase Order screen has a User Defined Field based off an Attribute.I am able to create the PO however the UDF field is not updated. The Custom field in the generated JSON request is only showing the Type but not the Value of the attribute. Below are some code snippets:public class CustomStringField : Acumatica.RESTClient.ContractBasedApi.Model.CustomField { public string Value { get; set; } }Acumatica.RESTClient.ContractBasedApi.Model.CustomStringField customStringField = new Acumatica.RESTClient.ContractBasedApi.Model.CustomStringField() { viewName = "Document", fieldName = "AttributeESTPONBR", Type = "CustomStringField", Value = "E123" };PurchaseOrder order = new PurchaseOrder() {

Hello everyone,I’ve been testing Concurrent Requests in Acumatica. Per the license we should have 6 concurrent requests and 500 requests per minute. I put together a contrived example to send off requests concurrently. The program runs through 2 scenarios. 8 Concurrent requests from a single user and then 8 requests each from 3 different users. However, the results were unexpected.It seems for Web API requests, that requests are not processed concurrently in Acumatica for a single user. In the first test the first request takes 600 ms and the second request (exactly the same as the first) takes 1018ms. And the trend continues with around a 400-500 ms delay between each request.In the second test, It looks like there is a little concurrency, but I’m not getting a concurrency of 6.Further, if you switch the request to be an OData call from a GI concurrency does seem to work as expected.I’ve provided code below to try it for yourself.So my question is: Why do the Web API requests not run

Hello community, As you probably know, in 2024R1 we’ve released an ability to retrieve reports in PDF format from the system via API.You can find more about that feature here (page 11). Now, we’d like to add mapping for some reports to allow you to do it via the Default endpoint.  Please help us to determine which reports should be mapped. Any suggestions are welcome, but if you also specify what you are going to use it for that’s even more valuable. Thanks in advance! 

I am using Microsoft.WindowsAure.Storage DLL to read files from Azure Blobs it was working fine until i upgrade to Acumatica 2023 R2, No w am getting above error.  So tried to change the DLL to Azure.Storage.Blobs but still getting error as below  Thanks,Arun.

Good day. We have an enquiry regarding the creation of a sales orders with allocations. We query the inventory summary results - expanded  by lot/serial number to retrieve a list of serials for an inventory product. We then display these options to the user to choose from when ordering a product ex: a gun. It seems that when we create an order with an allocation it creates/duplicates the lotSerialNbr entry within the inventory summary. Please see attached:- Example of create order call from documentation- Screenshot of our request logs- Screenshot of additional lotSerial entries created Our understanding of allocation on an order is that an existing lot serial number will be assigned to a Details/Product entry. Would appreciate any clarification and guidance on why our request is in fact creating a new lot/serial entry for an inventory item. Kind regards, Alecia

Hello Developers,I hope everything is going well.I'm currently working on implementing a feature to "Hold" a Purchase Order using the Rest API. I've set up the necessary actions in our web services.Here's the rundown: Actions - WebServices This is the Purchase Order I'm attempting to put on "HOLD." Actions - WebServices2-  This is Purchase Order I”m trying to “HOLD”   I've sent the request using the following endpoint: https://company.acumatica.com/entity/vendorpolineitems/22.200.001/PurchaseOrder/Hold 4- Request Body  {    "entity": {        "Type": {            "value": "Normal"        },        "OrderNbr": {            "value": "PPO05340"        }    }}  Unfortunately, I encountered the following error:  "source": "application", "code": 500, "message": "{\"message\":\"An error has occurred.\",\"exceptionMessage\":\"Operation failed\",\"exceptionType\":\"PX.Data.PXInvalidOperationException\",\"stackTrace\":\" at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContra

Acumatica Web Service Endpoints says that for Sales Prices I can only make a PUT request to get data.I don’t see anywhere in the docs where it says how to make this PUT request.Any information is greatly appreciated.Thanks!

Hi!, Just wanted to ask on how to create new Vendor Price Worksheet thru API?What Params, Body should I send?

I’m getting this error despite all my addresses being US addresses. Carrier Service returned error. DHL Express:This DHL account is owned by EasyPost and does not support non-US origin shipments. Please link your DHL Express account to continue with the shipment  

I am trying to enable Copy Order for QT to SO.It works fine when I copy SO to SO. It seems like once you hit OK parameters dialog and the process finishes, the QT order is still displayed and the Save button doesn’t really do anything and if you cancel your changes are discarded. Hitting copy twice before exiting will result in a new SO. If anyone has done this or has ideas, please share and thank you.update screen SO301000 {     update container "OrderSummary" {    formActionsToExpand = 2    add recordAction "copyOrder" {      redirect = true      redirectToDialog  = "SO30100D2"     }        add recordAction "copyOrderQT" {      redirect = true      redirectToDialog  = "SO30100D3"     }   }    add dialog SO30100D2 {     add dialogAction "CheckCopyParams" {       CloseDialog = true           DialogResult = "OK"      }     openAs = Form      add container "CopyTO" {           includeDialogActions = True       add field "OrderType"       add field "OrderNbr"         add recordAction "Che

Hello we have a website that syncs in all sorts of data from Acumatica. We sync in StockItems, SalesOrders, Invoices, etc.My struggle is that when data is deleted from Acumatica, how can I get those updates so I can delete on my side?One typical scenario is on Sales Orders. Items are often removed from sales orders. I don’t really have a way to get those updates.  I know I can use push notifications to get these deletes in realtime, but we do more of a night batch process.Outside of downloading all of our salesorders and doing a comparision of the nightly download and website list...and delete those items that are not in the nightly download.  This process is time consuming unfortunatley. I am hoping to find some sort of query I can call that will give me a list of deleted items, maybe by date?Does anyhow have an insights on how I could approach this? Thanks! 

New to Acumatica, we are in early implementation phase. Our iPaaS system is MuleSoft, and our CRM is Salesforce. Currently, we are working to POST new customers to Acumatica via REST API.  Receiving an error that we do not appear to have permission to create the SF Price Cls field, so the method fails.  When I look at the endpoint in Acumatica, I don’t even see that field as available.  Do I need to do the mapping inside Acumatica individually?  And do I simply extend the endpoint to do so?  Any insight appreciated, thanks!

I am uploading a project via Postman to acumatica. The project is getting created, but the default branch is always coming up as empty. I am sending a valid default branch and it is a part of the webservice endpoint. There is no error message.In the course of setting up the project, I am using a project template. This project template does not have a default branch set. Will the project template’s default branch override the one I am sending via POSTMAN?

I have a scenario with 2023 R2 Construction Edition with standard Equipment (EP208000) whereby I want to utilize a Project Attribute enabled for Equipment in the Web Service for Equipment.  I am not understanding how to reference the Attribute in the web service.  I have read a similar question on Sales Orders but this does not seem to be the same procedure.  I would like for the dev team to be able to evaluate the “Attribute” and the “Value”.  In this case, the “Value” will hold a default value that is needed.  Thanks in advance! 

Hi There,Working with 2023 R1.I am trying to run the following query through PostManhttp://AcumaticaVM/AcumaticaDemoDB/ODatav4/PX_Objects_GL_GLTran?$apply=groupby((AccountID,BranchID,LedgerID,FinPeriodID),aggregate(DebitAmt with sum as SumDebitAmt))And Acumatica is coming back with the following error:"error": {        "code": "",        "message": "An error has occurred.",        "innererror": {            "message": "Object reference not set to an instance of an object.",            "type": "System.NullReferenceException",            "stacktrace": "   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.VisitDacProperty(Type propertyType, String propertyName, SQLExpression defaultExpression)\r\n   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.VisitMember(MemberExpression expression)\r\n   at Remotion.Linq.Parsing.ThrowingExpressionVisitor.Visit(Expression expression)\r\n   at PX.Data.SQLTree.SQLinqExecutor.SQLinqExpressionVisitor.Visit(Expression expression)\r\n   at

“CustomerSignedReport” is a GUID field in database and also in FSAppointment class. I am working on an external application that is capturing signature and sending email to customer with pdf report.I have everything sorted, only issue I am facing is that I am unable to update the new file id in the field “CustomerSignedReport” as I am not able to add it in the web service endpoint even by extending it. My requirement is to update this field from REST API or web service SOAP.I need help from the community if I am missing something here.For reference:SQL : Select CustomerSignedReport,* from FsAppointment where refnbr='TMVT000069-1' and CompanyID=3DAC Class: