Develop Integrations with Web Services | APIs

We use https://[tenant].acumatica.com/identity/connect/authorize to get an authorization code which works fine then we callhttps://[tenant].acumatica.com/identity/connect/tokenendpoint with below params:grant_type: authorization_codeclient_id: [client id]client_secret: [client secret]code: (the value from "code" query parameter from the first request respomse)redirect_uri: https://[local].ngrok.io/accumatica/access-tokenWe get a bad request with error message:{ "error": "invalid_client"}What could be the reason?

Hi there,can anyone please help me out on how to setup things in acumatica for establishing connection from an integration tool and fire some restAPIS. thank you 

Hi,I’m trying to create a shipment via the rest api. The api call succeeds and the shipment is created but I’m getting errors in the Request Profiler. How do I debug these? The errors are vague and the stack traces don’t help either.Data:Type = “Shipment”, ShipmentDate = “9/12/2022”, CustomerID = 2943, Operation = “Issue”, WarehouseID = “MAIN”.Detail lines:OrderNbr = “SO123”, LineNbr = 1, InventoryID = “50500”, UOM = “CASE”, OrderedQty = 2, OpenQty = 0, OrderType = “SO”, ShippedQty = 2, WarehouseID = “MAIN”. How do I figure whether I’m filling in all the appropriate fields for the call?The request profiles is giving these errors:Sequence contains no matching element Exception has been thrown by the target of an invocation Operation Failed Object reference not set to an instance of an object

We Want To Create A  Batch Payment for multiple bills & Credit Adjustmentin batch payment create custom batch number . 

Hi, I am trying to customize or filter the Inventory ID Lookup on the Sales Order Screen (SO30100) by using SOLine_InventoryID_CacheAttached. Whenever I select the item, the grid line is filled up with the internal inventory ID value instead of the inventory CD.After selecting the item Here is my code public class SOOrderEntry_Extension : PXGraphExtension<PX.Objects.SO.SOOrderEntry> { [PXMergeAttributes(Method = MergeMethod.Append)] [InventorySelectorCustom(typeof(InventoryItem.inventoryCD))] protected virtual void SOLine_InventoryID_CacheAttached(PXCache cache) { } [Serializable] public class InventorySelectorCustom : PXCustomSelectorAttribute { public InventorySelectorCustom(Type type) : base(type, typeof(InventoryItem.inventoryCD),typeof(InventoryItem.descr) , typeof(InventoryItem.itemClassID), typeof(InventoryItem.itemStatus), typeof(InventoryItem.itemType)

How to access acumatica from an integration applications using auth 2.0 authorization

Hello all I have made a custom Inquiry screen, that filters and provides a record based on passing 3 input parameter.Item Sales Price ScreenNow I want the same value to be returned when via WebService . I did extend  my webservice Endpoint and added new screen. However, I am not able to see the right value on mapped object Item Sales Price InquiryWhen I call via my POSTMAN, I get empty result. Below is my code.public class ItemSalesPrice : PXGraph<ItemSalesPrice>    {        public PXFilter<SalesPriceFilter> Filter;        [PXFilterable]        public PXSelect<SalesPriceResult> DetailsView;        public PXCancel<SalesPriceFilter> Cancel;        protected virtual IEnumerable<SalesPriceResult> detailsView()        {                 ----                yield return ar;            }        }}  public class SalesPriceFilter : IBqlTable { #region CustomerID [PXDefault(PersistingCheck = PXPersistingCheck.Nothing)] [CustomerActive(Displ

why this payload is giving me an Error:422 "error": "Inserting 'Address' record raised at least one error. Please review the errors.; CountryID: 'Country' cannot be empty.",{"Status": {"value": "Active"},"EmployeeID": {"value": "CRIC123789"},"EmployeeName": {"value": "Doe, Jane"},"FinancialSettings":{"APAccount": {"value": "ACCOUNT123"},"APSubaccount": {"value": "000000"},"ExpenseAccount": {"value": "ACCOUNT456"},"PaymentMethod": {"value": "CHECK"},"PrepaymentSubaccount": {"value": "000000"},"SalesAccount": {"value": "ACCOUNT789"},"TaxZone": {}},"EmployeeSettings":{"BranchID": {"value": "CRIC012345"},"Calendar": {"value": "NEWCAL1234"},"CurrencyID": {"value": "USD"},"CurrencyRateTypeID": {"value": "SPOT"},"DepartmentID": {"value": "1"},"EmployeeClass": {"value": "EMPCLASSNE"}},"ContactInfo":{"LastName": {"value": "Doe"}},"Address":{"CountryID":{"value":"India"}}}

Hello. Im trying to run SalesOrderCreateShipment method right after the sales order is created.Im sending this (json encoded) array http://joxi.ru/LmGpkVnuwQvRR2 to /entity/Default/20.200.001/SalesOrder/SalesOrderCreateShipmentaddress (just like here) https://help.acumatica.com/(W(8))/Help?ScreenId=ShowWiki&pageid=9a0b1037-c931-4eff-a974-15403d3227a7but getting the following error"Error in action invocation: Value cannot be null. Parameter name: key"here is stack trace https://justpaste.it/52nn1wats im doing wrong? thanks!

Hi All, .i am basically from integration background.. i've just installed the local instance of acumatica ERP.. i wanted to create an employee in acumatica via postman by using the rest apis..… i have read the documentation but didnt understand how can i get those Endpoint URLs.. please help me out.. Thank you  

Hello Team,I found the following error with payments.1. I have created a payment via API. The payment is being created successfully.2. Then I use a payment to allocate with invoice or credit memo via API to pay it.3. Send the payment with allocation to the invoice or credit memo to Acumatica via API.Acumatica returns the following error message:Payment update request returns the error message - "exceptionMessage": "An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR.......' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR......' cannot be found in the system."When I repeat the same Payment update request after a period of time (in 1,5,10,20 minutes), Acumatica creates a payment successfully.Could you clarify what is the reason of this behavior?

I’ve been working on debugging this one for a couple weeks now. Due to the fact that this project is not open source, and there is encryption being employed to verify requests, it took a while indeed to finally figure out where this bug was exactly. I have been circling it for a couple weeks, but I didn’t have the time to go all the way down the rabbit hole until now.The Workwave API functions by having the client set a callback url where Workwave can send requests when deliveries and other things occur in Workwave. This callback url must conform to best practices for urls, and therefore cannot violate the RFC’s for urls by, for example, having a non-url-encoded space in the url.The Acumatica Webhook feature, on the other hand, does not url encode spaces in webhook urls, and hardcodes the url for a webhook to the name of the site and the company, which can have a non-url encoded space in it...see red arrow.  This is where we get into the catch 22 part of this particular bug. If you add

Hello, I am new to Acumatica, I have been working for a while on a project trying to cross information between Acumatica and other information sources and I am using Node js with an endpoint service to do that, let me show you what my problem is.I got the items from my request, as shown in the image (number 1), in my request I used the parameter "$expand=Detail" for that reason, I got all the items (number 2) but it takes a lot of time (number 3 ) around 30 seconds, I need to reduce the query time.Different parameters that I can use are mentioned in the Acumatica notes, one of them is "$filter". I have tried using different ways to filter the query, but to no avail.The parameters has been send like:"<Acumatica ERP instance URL>/entity/Integration/18.200.001/Integration?$expand=Detail&$filter=Date gt DateTimeOffset'2022-08-03T00:00:00+00:00'" I tried to test with Postman and it's response was:{"message": "An error has occurred.", "exceptionMessage": "More than one entity sa

Hi,Previously I sent documents to Acumatica files for bills with the help of such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Bill/INV/002272/files/image (3).pdfFor Checks and Payments it worked via such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Payment/payment/002272/files/file.pdfHow to do same for Purchase Receipt tab ? I tried several variations but did not succeed in it 

  Quick question.  We renamed our endpoint that we use for our customization, but we need to delete the old endpoint for some of our customers that still have the old one.  The old endpoint was named Altec2017R2, and is now called DLAltec2017R2.  I can't see any way to delete the old endpoint from the customers list of endpoints. 

Hi,I am doing Unit testing by using Acumatica Test SDK.https://www.acumatica.com/blog/creating-acumatica-test-sdk-tests-from-scratch-for-isvs/By taking the reference of above link Compiling the Code for my custom screen.Getting the Below error'Tests.exe' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_32\mscorlib\v4.0_4.0.0.0__b77a5c561934e089\mscorlib.dll'. Symbols loaded.'Tests.exe' (CLR v4.0.30319: DefaultDomain): Loaded 'C:\Users\TH-003_PC\source\repos\Tests\Tests\bin\Debug\net4.8\Tests.exe'. Symbols loaded.'Tests.exe' (CLR v4.0.30319: Tests.exe): Loaded 'C:\Users\TH-003_PC\source\repos\Tests\Tests\bin\Debug\net4.8\Execution.dll'. 'Tests.exe' (CLR v4.0.30319: Tests.exe): Loaded 'C:\WINDOWS\Microsoft.Net\assembly\GAC_MSIL\netstandard\v4.0_2.0.0.0__cc7b13ffcd2ddd51\netstandard.dll'. Cannot find or open the PDB file.'Tests.exe' (CLR v4.0.30319: Tests.exe): Loaded 'C:\Users\TH-003_PC\source\repos\Tests\Tests\bin\Debug\net4.8\PX.QA.Tools.dll'. 'Tests.exe'

Scenario:We want to create returns via REST APIs. We have published a customization package for this. Technically, this is how the customization package works:Creates a blank RC order Trigger SalesOrderAddInvoice action to add products from the invoices Update RC with relevant quantitiesThe above process works for the first RC.Any further RC creation from the same invoice throws the below error:"The return quantity exceeds the quantity available for return for the related invoice line <INVOICE_NBR>. Decrease the quantity in the current line, or in the corresponding line of another return document or documents <RETURN_NBR> that exist for the invoice line." This is the similar error we usually see on Acumatica UI when adding the same inventory from an invoice.  However, we can create the RC from the UI by modifying the quantity. Question:Is there anyway to fix this issue? We are on Acumatica 2022 R1. Regards

 i create extendedEndpoint for update Hold = false and result like in picture.how to update hold = false with API?

When I publish my Api to other multiple sites. project name Dharmandar publish but execute all database my script not execute show my create endpoint not show in web service endpoint. How i this Check execute through Api.

I want to publish that API to other multiple sites using some code, I will be having access token of every customer but not UI access. So can you please share the way of publishing this kind of extension to any customer

Hi, I have 3 custom projects in my Acumatica that I need to reuse in other Acumatica instances with same version 2021r2In this topic : It was described how to merge 3 customization projects into one single.My goal is to merge all customization projects into one single and use new package for other Acumatica instances with same version 2021R2In this topic It was described how to merge customization projects into one single.So, I had separated packages beforeWith the new package that contains  package “Custom Endpoint” I receive such error while publishing my new customization package that contains “Custom Endpoint” package I tried to change namespace CustomEndpoint for which I receive error,  to my project name namespace, but it become unworkable, so I cancelled changes.Just to be sure that I described everything :I merged customization project into one  by viewing published  I tried to publish it to another Acumatica instance but get error for your customization package Please, help to

hi,When I asked for a help with customization package creation, it was told to me that Acumatica where this package will be created must be same version as other Acumatica instances where this package will be used.Is the any way to create universal package for all Acumatica version or maybe more simple process that switch to other Acumatica, recreate package for each version ?

Hi,In this topic  I asked for possibility to store credentials for ftp server connection in Acumatica custom entityHow to do it in a right way ?When I created custom entity, it required Screen Name of the  already existing entityWhat should I choose ?

We are using the REST API to create a Sales Order in Acumatica. For some customers we receive the below error message. Not sure why the API is complaining about “inter branch” as we target a single tenant and try to create a sales order for an existing customer under that tenant. (Not sure if branch means something else than “tenant” in this context) I read the other post on the forum and tried to find the feature for enabling inter branch but that feature was not listed. Can someone please help with this?   Exception: An error occurred during processing of the field Allocated value False Inter-Branch Transactions feature is disabled.PX.Data.PXOuterException: An error occurred during processing of the field Allocated value False Inter-Branch Transactions feature is disabled

We are using the rest api to create and update purchase orders. We can create them ok, but when we need to update a line we get semi-random errors. One of which is"Subaccount": { "error": "'Sub.' cannot be empty."},Our request does include a valid value for the account and subaccount and in the item we have the same for the defaults. If anyone has any experience with the api, could you please help point us in the right direction?