Develop Integrations with Web Services | APIs

Our organization just upgraded to 24R2 and we are seeing new functionality that did not exist in the prior version.We have a shipment with a single line item, but two packages.  When we pack into the Contents, the package that we specify isn’t being used.  It seems like it is adding to the package with the highest PackageLineNbr.For example, we have the following: { "id": "74db342b-bf4e-ef11-93aa-00155d1eec41", "rowNumber": 1, "note": { "value": "" }, "Packages": [ { "id": "262d42ac-c04e-ef11-93aa-00155d1eec41", "rowNumber": 1, "note": { "value": "" }, "Contents": [], "LineNbr": { "value": 1 }, "custom": {}, "_links": { "files:put": "/AcumaticaERP/entity/Packing/22.200.001/files/PX.Objects.SO.SOShipmentEntry/Packages/262d42ac-c04e-ef11-93aa-00155d1eec41/{filename}" } }, { "id": "7

Hi folks, I’ve been trying to solve an issue where creating sales order via the REST API can be very slow. To diagnose this issue, I enabled the request profiler and used it observe that--in addition to very large SQL counts and CPU time--the slow requests are generating exactly three exceptions per detail line: two System.InvalidCastExceptions and one PX.Objects.IN.PXUnitConversionException. Not exactly a smoking gun, but it does seem suspect to me (I don’t think we should be generating these exceptions, no?). Perhaps some data was stored in the wrong format (i.e. a string being sent where an integer is expected)? Drilling down into the exception details, it looks like the source of some exceptions may be from PX.Objects.IN.PXQuantityAttribute.CalcBaseQty; but I’m not sure where to go from here. Is there a way I can determine exactly which attributes are being set? Maybe that will help me locate the offending data format mismatch. Failing that, anyone have tips for tracking down the c

Hi Team, We are working with 24R2 (Build version) and created a custom processing screen to create Sales Order but during processing we are getting an error like: 'Another process has updated the 'SOContact' record. Your changes will be lost'. But the same is working in previous build (Build version) On further verification we identified the issue occurs while updating Sales Order Contact and on executing Save action getting another process error, without this code block order created successfully. Please find the below sample code for your verification and review: public static void SetBillingContact(SOOrderEntry graph, ItemResult OrderDetails)        {            graph.Billing_Contact.Current = (SOBillingContact)graph.Billing_Contact.Select();            if (graph.Billing_Contact.Current != null && OrderDetails != null && OrderDetails.BillingAddress != null)            {                graph.Billing_Contact.Current.OverrideContact = true;                graph.Billing_

Hey everyone. We have done a customisation where we extended the Opening Balances to the Customer screen. Here are the fields in DAC: public class MAKLCustomerBalanceSummaryExt : PXCacheExtension<CustomerMaint.CustomerBalanceSummary> { #region UsrMAKLCurrentBalance [PXBaseCury(null, typeof(Customer.baseCuryID))] [CurySymbol(null, typeof(Customer.baseCuryID), null, null)] [PXUIField(DisplayName = "Current Balance", Visible = true, Enabled = false)] public virtual decimal? UsrMAKLCurrentBalance { get; set; } public abstract class usrMAKLCurrentBalance : BqlType<IBqlDecimal, decimal>.Field<usrMAKLCurrentBalance> { } #endregion }We have then extended this field to the Web Service Endpoint, but it returns 0 every time even though the customer has a balance.I have then added the RowSelected event handler and populated the field in there as well, but to no avail. How can I get this field to display in the Web Service? 

Hello, I’m attempting to create a Sales Order via the REST API and I’m running into an error I don’t understand when applying a discount. My DiscountDetails JSON payload looks like this:   "DiscountDetails": [        {            "Description": {                "value": "Coupon Discount"            },            "DiscountCode": {                "value": "COUPON"            },            "DiscountPercent": {                "value": 15            },            "DiscountAmount": {                "value": 0.6            },            "ManualDiscount": {              "value": true            },            "SequenceID": {              "value": "TATER15"            },            "Type": {                "value": "Document"            }        }  ]The error I’m receiving is “’Type’ cannot be empty”, but I am providing a “Type”, so I don’t really understand what’s wrong. There are no other errors. The error only seems to occur when using the REST API; I have been able to successfully apply the

I am setting up FedEx and UPS integrated shipping, however, my team is needing to send Paks, which I don’t see the option to create within Boxes. How do I create this shipping “box” so the APIs detect the right shipping size?

Hi all, I have a customization project where I have added custom fields to PMTASK and Project Address.I have them on the screen and they work fine. The 2 Fields that I added to addresses appear and I can add to the extended endpoint. For the Project Task I do not see it in Task Summary or Summary→ Task Properties.  I can see it in the DAC.Any Ideas?  I created the fields the same way. Thank you

I had to write a custom program for Physical Inventory because the Acumatica native PI stuff doesn’t work for us. Last year it worked great and everyone was very happy with it.This year I wanted to enhance it by automatically loading the counted quantities to Acumatica over the Web Service, once counting was complete, instead of using my SQL view, exporting it to Excel and loading it into Physical Inventory Review. I am having an issue though where when I upload the scans to the web service, it fails with a 500 “Operation Failed” and Inner Message “Failed to insert the PIDetail Row”. The rest is just abstract stack tracing that gives me ZERO clues of why it wouldn’t persist. This happens after several hundred scans are successfully processed. I started by sending batches of 500 rows of test data (last years actual PI scans) to my development server. When I got that failure, I cut the batches down to 5 and output what part/location it is working on. I then hand entered all 5 of those sc

I’m in a cloud version, and created a customization project, how can I add a new ASPX page that can be publicy accessible by anyone without the need to login?Locally I can make it public by doing modification in web.config, but how this can be done on Cloud instance of Acumatica?2024R1

I cannot seem to find anything on the API that returns currency exchange rates.  Is it possible to get to these?I have come across an answer stating that Acumatica uses https://openexchangerates.org/ internally as the source of exchange rate data, but if we have the exchange rates already it seems superfluous to have to subscribe to another service to get them.

Hello, I've added two push notification of type WebhooksThe first One working perfectly and it's set to read data from the Genric Inquiry  the push notification is firing and the webhook URL receive response without issues.The other one whch read inventory updates and available qty is the one that we have a problem with and can't make it work,  this one was created also based on the generic inquiry this one is set to push notification to the same end point as the first one I see that the generic inqury working well and grap data, but the push notifications is not firing. The push notification has beened added and configured the same way as the first one but not sure why the second one doesn't work, is there any reason on why this happening Best regards

I am calling a REST API and receiving the error “Form key or value length limit 2048 exceeded”.The body of the request is about 75KB.This seems to be controlled by a setting in IIS. Is there anything I can do to get around this? 

Hello I m not seeing a default action in the web service endpoints for bills to allow an apply action on a debit adjustment type bill. Can I accomplish this action via the rest api? Applying this debit adjustment to another bill.  

We want to provide access for customers to certain data via the API using the resource owner password credentials flow.  We can successfully login to get a token if the login type is UI or unrestricted, but we need to limit the user to API so they can’t login directly through the UI.  Is this possible?DetailsThe first screenshot shows the normal token request when the username has a login type of UI or unrestriced. The second screenshot we limit the user type to API only The third screenshot shows how the same Postman request from #1 now provides an error that only API requests are available for the user.Is it not possible to lock the user account down to only allow API access but also get a token? 

Hi, I’m trying to access the ability to change a subaccount ID via REST API. The default endpoint (current version in my environment is 23.200.001 doesn’t have this action available, and it does not appear in the list of actions I can pick from when trying to extend the endpoint (as opposed to, say, StockItems where it is available to select and add). If we are synching subaccount data from an external source where subaccount values can change (and we know the old > new values for each change), how can we go about making sure we change the existing record in Acumatica instead of inserting a new value and keeping a now obsolete subaccount? Thanks!

We’ve been working on an integration to Acumatica utilizing a mixture of Web Service APIs and OData queries. After some testing we seem to be running into some issues with concurrency. We seem to hit our limit of 6. This seems unusable considering if we have 10 people view an item on the site the first 6 api calls would succeed but the other 4 will have to wait.Is there a way to get more concurrent requests with this license? e.g. would having multiple api users increase concurrency? Do OData calls count towards the limit? How hard/how expensive for our clients to get a license with 1000+ concurrency? or is that something Acumatica even offers

This software is from https://www.seagullscientific.com/ and it supports XML input.  Client needs to print various types of product labels and currently they use BarTender.  Do not want to write code or API’s.

Hello,We are working on an integration into Acumatica via the REST Api and have had some troubles with pulling the latest payment objects. When logged into Acumatica I can see recent payments objects in our demo account but when pulling payment via the REST Api I’m only seeing the demo account data. I’ve verified that our user and api account have access to all of the branches/companies in the Acumatica account so I m unsure why I wouldn’t be seeing all payments? I’ve attached a screen shot with a modifiedDatefilter and it returns no results. When changing the date filter to april of this year I do receive payment objects that were setup in the demo account. The second screen shot is showing the many newly created payment objects in many different status’ that do not come back.Any help is greatly appreciated. Thank you

I am trying to create a customer but getting 422 Unprocessable Entity.I am trying this call:PUT @https://xxxxxxxxxxx.acumatica.com/entity/Default/20.200.001/CustomerThis is my request body:{ "CustomerID": {"value": "Cust01"}, "CustomerName": {"value": "Customer 01"}, "CustomerClass": {"value": "MISC"}}This is my response: { "id": "bd225325-d6b3-ef11-8363-12ab09909afb", "rowNumber": 1, "note": { "value": "" }, "error": "Inserting 'Location' record raised at least one error. Please review the errors.; CSalesAcctID: 'Sales Account' cannot be empty.; CSalesSubID: 'Sales Sub.' cannot be empty.; CARAccountID: Account 1050 is not a control account. Please select an account configured as a control account for AR.", "AccountRef": {}, "AutoApplyPayments": { "value": false }, "BillingAddressOverride": { "value": false }, "BillingContactOverride": { "value": false }, "CreatedDateTime": { "value": "2024-12-06T

Hello,On my payment plugin I’m getting the errorValue cannot be null.Parameter name: source at System.Linq.Enumerable.Where[TSource](IEnumerable`1 source, Func`2 predicate)   at PX.Objects.Extensions.PaymentTransaction.PaymentTransactionAcceptFormGraph`2.GetTransByDoc(ICCPayment payment, IEnumerable`1 trans) in C:\build\code_repo\WebSites\Pure\PX.Objects\Extensions\PaymentTransaction\PaymentTransactionAcceptFormGraph.cs:line 1033   at PX.Objects.Extensions.PaymentTransaction.PaymentTransactionAcceptFormGraph`2.<>c__DisplayClass29_0.<CheckPaymentTransaction>b__0(IEnumerable`1 i) in C:\build\code_repo\WebSites\Pure\PX.Objects\Extensions\PaymentTransaction\PaymentTransactionAcceptFormGraph.cs:line 617   at PX.CCProcessingBase.RetryPolicy`1.DoExecute(Func`1 execAcion)   at PX.CCProcessingBase.RetryPolicy`1.Execute(Func`1 execAcion)   at PX.Objects.Extensions.PaymentTransaction.PaymentTransactionAcceptFormGraph`2.CheckPaymentTransaction(TPrimary doc) in C:\build\code_repo\WebSit

Hi,I added 2 new fields to Inventory Adjustment, both decimal UsrQtyThirdParty and UsrQtyUSN. I added them to the extended endpoint.I created an adjustment, the 2 fields are inserted correct, I retrieve the record and change the values of the 2 new fields and do a PUT, the values stay the same, not updated.Get the adjustmentUpdate the adjustmentResult after update 

I retreive a list of shipment numbers that i need to confirm in Acumatica I created an import scenario that accepts a csv file with “Shipment Nbr.” as the header. I created a web service endpoint mapped to Import By Scenario Screen I created an action called prepareImport The action has a parameter called Name which is the Import Scenario name Is it possible to send a list of shipment numbers in JSON format instead of csv through postman? What would the payload look like? Ive tried: {     "entity" : {         "ShipmentNbr" : {"value": "SHIP-0000002"}     } } {     "entity": {         "Name": { "value": "LA - Confirm Shipments" },         "parameters": {             "Shipment Nbr.": {                 "value": "SHIP-0000003"             }         }     } } Ive tried changing the url to pass the Name as a filter How can I acheive this? Thank you.

Hello. Im trying to remove image file from stock item using api.Trying to process DELETE request to url /entity/Default/20.200.001/files/85c85649-8fbc-4a31-b8ce-5380ac3730fbbut getting an error “You are not logged in.”. But there is access token in request present and all other requests work fine. Could you help me with it? Thanks.

Hello,We are implementing Shiphawk WMS and having trouble with inventory adjustments.  Our stock items are valued as FIFO method, so I believe it is because the “Receipt Nbr” field in the IN303000 screen is not able to populate from Shiphawk.  Is there a workaround for this error so that we can make inventory adjustments from the WMS?

Hello,I have a custom field called “Cheque Generado” in Transactions screen, this field is a check box type, I tried to override the CAAdj_RowSelected event but it does not work.This is my code: protected void CAAdj_RowSelected(PXCache cache, PXRowSelectedEventArgs e, PXRowSelected InvokeBaseHandler)    {      InvokeBaseHandler(cache, e);      CAAdj row = (CAAdj)e.Row;      if (row != null)      {          Base.CAAdjRecords.AllowUpdate = true;          Base.CAAdjRecords.Cache.AllowUpdate = true;          PXUIFieldAttribute.SetEnabled<CAAdjExt.usrChequeGenerado>(cache, row, true);      }    } Could you help me with this?