Develop Integrations with Web Services | APIs

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?

There seems to be a bug with the Set as Primary button on an Opportunity.Here are the steps to produce:Create an Opportunity Create a Project Quote. Ensure you set its Opportunity ID to be the Opportunity ID of the Opportunity we created in step 1 Create another Project Quote and also set its Opportunity ID to be the Opportunity ID of the Opportunity we created in step 1 Use some mechanism to fetch both project quotes, I just use Postman. Note their LastModifiedDateTime’s… Click the Set as Primary button on the Opportunity for the Project Quote that is not presently the Primary one (we specifically choose this Project Quote as this is a data change and should -- at least, in theory -- update the LastModifiedDateTime of the Project Quotes) Repeat step 4. Note both of their LastModifiedDateTimes remain unchanged.Is this a known bug or planned to be fixed? Our company uses the LastModifiedDateTimes for DB syncs and this is a major problem for us. I’m aware of workarounds and plan to addre

Hi, Executing the InventoryAdjustment in Postman I get the following known error:"error": "Inserting  'IN Transaction' record raised at least one error. Please review the errors."And in the details:"LotSerialNbr": {                "value": "--MFP73565",                "error": "Lot/Serial Nbr. '--MFP73565' cannot be found in the system."            },Creating the InventoryAdjustment using the RestClient also gives an error, but it only gives me this error “Inserting  'IN Transaction' record raised at least one error. Please review the errors." when catching an ApiException. If I check the ErrorContent it is null. How can I get the same result in the RestClient as in Postman where it returns the Lot/Serial Nbr error?I am using version 4.1.0 of the RestClient client nuget package in c#.

We set up a REST API integration with our Acumatica account using Zapier and it works fine. We then tried connecting it to our sandbox account as well and it stopped working after a day. The error is that the connection timed out. We cannot connect from Zapier or web based Postman. Interestingly, we can connect from Postman desktop. The version on our sandbox account is 2022 R1.Is there some sort of setting on the sandbox that is blocking the requests?

I have created a move transaction using moveentry in the manufacturing endpoint. The transaction is still open, I need to update the amount produced and update some of the attributes with additional information. When I send json through postman, I receive the response below.  The error states that “Line 2 of Move Transaction  requires Attribute ADDLSCRP”, the attributes are being sent in the proper order. Request:{ "BatchNbr": { "value": "MI000623" }, "Details": [ { "TransactionAttributes" : [ { "rowNumber": 1, "AttributeID": { "value": "OPER2" }, "Value" : { "value" : "2" } }, { "AttributeID": { "value": "ADDLSCRP" }, "Value" : { "value" : "8" }

I am trying to follow the examples for the screen based soap api services, I am able to generate the wsdland insert it in the console app but I have no Screen Class, I cannot do apitest.Screen context = new apitest.Screen();I am using VS2022 and there are no errors, but I cannot find this Screen class,What am I missing?

Trying to ship with FedEx, however, when ever we refresh rates, we get the error “Object reference not set to an instance of an object". Any idea what could be causing it and how to fix it?

Which web service end point should I access in order to do a Move transaction?Move Entry seems to be incorrect? 

Hello, I’ve been trying to expose the Access RIghts of a Role by extending the Web Service Endpoint and adding the Access Rights by Role (SM201025) Screen ID to an endpoint named “AccessRightsByRole”. I’ve populated the fields n AccessRightsByRole with the Role Information mapped object. As you can see I’ve inserted a new field named AccessRights which should hold the detail of 0 to many Access RIghts, which is an object mapped from RoleEntities. Following the Acumatica Universities Advanced Data Retrieval with REST API 2024 R2 instructional video (19:39), I expected to see these Access Rights expanded for a role that was queried.Example: GET {baseUrl}/AccessRightsByRole/Administrator?$expand=AccessRightsNo matter which role I query, the AccessRights field is always an empty array. {    "id": "{some GUID}",    "rowNumber": 1,    "note": null,    "AccessRights": [],    "RoleDescription": {        "value": "{some role description}"    },    "RoleName": {        "value": "{some role name}

Hi Community team, Is there any API available to Validate Bill Entry “json data”?We would like to validate Bill entry data before call to create bill api entity/Default/xx.200.001/Bill.  

Hi All, I wanted to know how to retrieve as much information as possible for a stock item.  At the moment I am using the StockItem end point, but it only returns the QtyonHand which is only partially useful. When I go to Inventory Summary I see the following fields.   This is great because I can see the full picture of the item’s allocation. I can also see if the Item is already on a PO.  Unfortunately this screen does not tell me which PO’s the item is on.  The Inventory Allocation Details screen will tell me PO’s the order is on.  The goal here is that when orders come in a quick way to analyze if we have the part in stock.  If we dont what is the ETA.Are there other end points besides stockitem that will get me more of this information for an inventory item?  

We are using the nuget package Acumatica.RESTClient.ODataApi version 4.1.0.  We are trying to call a generic inquiry via OData v3 using ODataApi.GetOData().  However, the $orderby parameter is not listed as a parameter for this method.The method includes the following parameters:select, filter, expand, skip, and top - but not $orderby.Is there a way to make an OData v3 call using an $orderby parameter?

I have been trying to send a token via API Key Authorization method but I've been getting an unauthorized error: {StatusCode: 401, ReasonPhrase: 'Unauthorized', Version: 1.1, Content: System.Net.Http.NoWriteNoSeekStreamContent, Headers:{  Date: Wed, 23 Oct 2024 16:35:03 GMT  Transfer-Encoding: chunked  Server: Microsoft-IIS/10.0  Content-Type: application/json; charset=utf-8}}This is my code:using System;using System.Collections;using System.Collections.Generic;using System.Linq;using System.Text;using PX.Common;using PX.Data;using PX.Data.BQL;using PX.Data.BQL.Fluent;using PX.Objects.CM;using PX.Objects.CS;using PX.Objects.GL;using PX.Objects.Common.Extensions;using PX.Objects;using PX.Objects.IN;using RiverlandDesarrolloV231;using System.Net.Http;using System.Threading.Tasks;using Newtonsoft.Json;using PX.Concurrency;namespace PX.Objects.IN{    public class INReceiptEntry_Extension : PXGraphExtension<PX.Objects.IN.INReceiptEntry>    {        #region Event Handlers        public

We have a custom publicly available filter. public PXFilter<ShipperTankFilter> showShipperTanksFilter;The filter is defined as follows: [PXHidden] [Serializable] public class ShipperTankFilter : IBqlTable { #region TankSerialNbr [PXString(20)] [PXSelector(typeof(Search<SOShipLineSplit.lotSerialNbr>))] [PXUIField(DisplayName = "Tank Serial Nbr", Enabled = true)] public virtual string TankSerialNbr { get; set; } public abstract class tankSerialNbr : PX.Data.BQL.BqlString.Field<tankSerialNbr> { } #endregion }We have an action called createBoxes.  We’ve exposed this action as a REST API endpoint named CreateBoxes, mapping the TankSerialNbr parameter. When we call the CreateBoxes action via Postman, we receive a 422 Unprocessable Entity error. By way of troubleshooting, we create another field TankSerialNbr2 on the filter as shown: [PXHidden] [Serializable] public class ShipperTankFilter : IBql

Hello! Is there a way that we can get a status changed date into a report not viewing by the Audit History? Amanda

I made a custom endpoint:  I added the PrimaryQuote action:  I send a POST request to set a Sales Quote as primary:  I get a server error: {    "message": "An error has occurred.",    "exceptionMessage": "Object reference not set to an instance of an object.",    "exceptionType": "System.NullReferenceException",    "stackTrace": "   at PX.Api.ContractBased.EntityService.Invoke(ISystemContract systemContract, String version, String name, EntityImpl entity, ActionImpl action, CbOperationContext operationContext, Boolean throwOnError)\r\n   at PX.Api.ContractBased.AspNetCore.CbEndpointFeatureServiceExtensions.Invoke(IEntityService entityService, ICbEndpointFeature feature, EntityImpl entity, ActionImpl action, CbOperationContext operationContext)\r\n   at PX.Api.ContractBased.WebApi.Controllers.ActionController.InvokeAction(String objectName, String actionName, ActionInvocation invocation)\r\n   at lambda_method(Closure , Object , Object[] )\r\n   at Microsoft.AspNetCore.Mvc.Internal.Acti

Hi guys I am trying to make a report based on today’date, payment method and status open. This is going to be on payment screen. Any one please guide me with any reference. When we select these fields in parameters It should return all the payments with customers in report. It will have customer relation with payemtns . Any one please guide me on how to start 

Hello,On Acumatica Cloud 2024 R1I’m using the end point Default/23.200.001/Payment (also tried with Default/22.200.001/Payment) After creating a SaleOrder, I’m trying to add a Payment for it using the web service, but I’m stuck in error returning from the API with this message:{ "message": "The request is invalid.", "modelState": { "": [ "An exception occurred during input parsing" ] }}I’m not sure what is invalid, I’m using the same JSON format I used to create the sales order, here is my payment POST request: { "Type": { "value": "Payment" }, "CustomerID": { "value": "1047204" }, "ApplicationDate": { "value": "2024-10-18T11:00:51" }, "PaymentAmount": { "value": "439.22" }, "PaymentMethod": { "value": "ONLINE" }, "PaymentRef": { "value": "86561" }, "CashAccount": { "value": "11140_____" }, "AppliedToDocuments": [ { "Type": { "value": "SO" }, "ReferenceNbr": { "value": "86561" },

hi, All. We have one screen name bank deposits. I am trying to put data in ths screen using API. I have extended the endpoint and add this screen in webservices. But when I am calling put method it returns an error.Can any one please guide me on this 

Here is the URL that has been working for well over a yearhttps://companyx.acumatica.com/ODatav4/companyx/PX_OBJECTS_AR_ARADDRESS?$format=jsonStarting on October 8th, 2024. the Azure Data Factory pipelines started failing with the error ”ErrorCode=RestCallFailedWithClientError,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Rest call failed with client error, status code 404 NotFound”I am hunting for a change notification or something regarding the URL needing to be updated or something, but I am not having any luck. Thoughts? 

Hi, I have created a new endpoint in acumatica and then entity of payment in it, Then i tried to create a record using the API but the payment Tab is null and the main summary is created.My query is :http://localhost/PR00000009/entity/Bank/22.200.001/BankDeposit?body: Entity : Below is the screen shot of the screen. The summary is created by PUT API but payment is null. What should i do in this case ?  Response: