Develop Integrations with Web Services | APIs

Hi Team,After I upgrade my instance from 2022 R2 to 2024 R1, my existing webservice endpoint throw the below error. I tried to publish the customization package for this webservice, but still no luck.Please help me to check on this. Regards,Ramya Krishna

I am trying use the Login to Acumatica Rest API with Postman. ​​According to the documentation I have found in the web, I should be using http://MyCompany.acumatica.com/entity/auth/login as URL The body as detailed below:{"name":"johnd","password":"johndpassword","tenant":"mytenant"} I get an error in Postman as detailed below:{"message":"An error has occurred.","exceptionMessage":"Error: Invalid credentials. Please try again.","exceptionType":"PX.Data.PXException","stackTrace":" at PX.Data.PXLogin.LoginUserImpl(HttpContext httpContext, String userName, String password)\r\nWhat am I doing wrong?

How do I REMOVE HOLD on a Purchase Receipt with the REST API (just like the ReleaseFromHold Action in SOAP)?  I’m trying perform this same action as this button on the PO302000 screen… 

Hi, I am able to successfully create a Sales Order and all of the customer data, line item data etc. is correct except for RequestedOn date. It seems to be auto-assigning to the day before delivery based on the delivery Route assigned to the customer. Even if I put the RequestedOn date weeks in the future, it still assigns to the day before the next delivery route is scheduled. This is what my JSON Request Body looks like:  { "OrderNbr": { "value": "<NEW>" }, "OrderType": { "value": "SO" }, "CustomerID": { "value": "XXXXX" }, "note": "", "CustomerOrder": { "value": "XXXXXX" }, "Details": [ { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "InventoryID": { "value": "XXXX" }, "OrderQty": { "value": 1 } }, { "InventoryID": { "value": "XXXXX" }, "OrderQty": { "

Hello Everyone,I have requirement to pick the file from local path and attach a file using REST API from code level to the Sales Order. Can you please share the sample example for the same?

I’m attempting to use OData v4 to filter the PO collection based on the lines’ PromisedDate field: “$filter=POLineCollection/all(l: l/PromisedDate ne null)” However, I get an exception with this message:“Instance property 'POLineCollection' is not defined for type 'PX.Objects.PO.POOrder'”.What’s strange to me is that Acumatica definitely knows that POLineCollection exists; I can include it in a $select, and if I misuse the filter, such as “POLineCollection/all(l: l/PromisedDate eq 3)”, I get an “incompatible types” error.Am I missing something here?

I’m doing a PUT method in Postman but it keeps creating a brand new purchase receipt instead of adding Details to the existing PurchaseReceipt that I’ve specified.  How do I prevent a new PurchaseReceipt from getting created. URL:  /entity/Default/22.200.001/PurchaseReceiptBody:{        "ReceiptNbr": {"value": "PR00153497"},           "Details" :[            {              "POOrderNbr": {"value": "PO53472"},              "POOrderType": {"value": "Drop-Ship"},                            "TrackingNumber": {"value": "9999"},              "ReceiptQty": {"value": "1"},                            "InventoryID":{"value": "190-34563221"},               "POLineNbr": {"value": "1"}                          }            ],        "VendorID": { "value": "PU3" },        "VendorRef": { "value": "FROM_API" },                "Location": {"value": "MAIN"},        "Branch": {"value": "CM"}            } 

I’m trying to use Postman to retrieve a PurchaseReceipt but the only way I’ve been able to do this is by filtering by the ReceiptNbr.  Is there a way to filter by POOrderNbr?Here's what works successfully:/entity/Default/22.200.001/PurchaseReceipt?$filter=ReceiptNbr eq 'PR00153430'&$expand=DetailsThis returns an error ("The parent value for a property access of a property 'POOrderNbr' is not a single value. Property access can only be applied to a single value"):/entity/Default/22.200.001/PurchaseReceipt?$expand=Details&$filter=Details/POOrderNbr eq 'PO53414'  

I looked through the web service endpoints and I can’t find any to get the Campaign ID when given a campaign name.  Is there a way to get that through and endpoint? 

We have some PO’s generating from a 3rd party system. With Autonumbering off I can create a PO with API and use the 3rd party PO num. We also need to create some PO’s manually, but want to use different prefixes. Is there any way to have autonumbering on for 1 prefix but not the other?  Is there a better way to solve for this? Thank you

I have a customer who made a payment using a credit and wants to change to a different card (different payment method already associated with his account).  How can I modify the payment to reflect this?  I tried the following PUT method URL in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/PaymentHere’s the body I passed:{        "Type":{"value":"Payment"},        "ReferenceNbr": { "value": "183610" },        "PaymentMethod": {"value": "CC MASTCRD"},        "NewCard": { "value": false },        "CardAccountNbr": {"value": "Mastcrd:****-****-****-4203"}}I don’t get an error but, unfortunately, Postman just returns the existing Payment with no card change applied.

Hello everyone,First time poster here.  I have used the GitHub “endpoint model generator” solution to generate the DLL’s I need to allow my C# application to connect to our Acumatica instance with our extended endpoint and the RESTAPI dll’s (Acumatica.RESTClient.dll and Acumatica.RESTClient.ContractBasedApi.dll that get compiled along with my endpoint dll.I am using Visual Studio 2022 and C#.I have been unable as of yet to figure out why the authApi.Login() function just locks up the app.This is the content of the request (that was put together by the Acumatica code) as it looks immediately before being passed to the Client.SendAsync(request) call that hangs up.  {Method: POST, RequestUri: 'https://<ouracumaticadomain>/AcumaticaERP1//entity/auth/login', Version: 1.1, Content: System.Net.Http.StringContent, Headers:{  Content-Type: application/json; charset=utf-8}}    Content: {System.Net.Http.StringContent}    HasHeaders: false    Headers: {}    Method: {POST}    Options: {System

Does anyone know how to retrieve data in a CustomerPaymentMethod using a CustomerID, PaymentMethod name, Card Account Number, and Value using the REST API in Postman? Here’s what I have so far in my GET method:https://sandbox.com/entity/Default/22.200.001/CustomerPaymentMethod/Customer/C10010473712 I’m not sure what all the parameters are supposed to be so I just get an error using that:{    "message": "An error has occurred.",    "exceptionMessage": "No entity satisfies the condition.",    "exceptionType": "PX.Api.ContractBased.NoEntitySatisfiesTheConditionException",

Hi Team,We have a requirement as we create a receipt via API calls and insert line details with the insertion of attributes ..(using PUT request) Receipt is created with line details and released but attributes are not inserted. can you please review and suggest the best way possible to achieve it.Thank you!

Example: I need to update all the Sales Order data inputted in one instance to another instance of the same screen (screen SO301000) through an API call when I hit save. Any suggestions on how to do this? 

I am trying to get the access token using attach code but it shows error of “Invalid Client”. Error:  Connected Application:  

I have an open payment for a Sales Order in Acumatica.  Currently, Applied To Order is set to 0.00 for the payment attached to the order.  I would like to change this value to the unpaid balance.  I can easily do this in SOAP.  For REST, I am using the following URL in Postman:https://sandbox.com/AcumaticaERP/entity/Default/22.200.001/Payment However, I am constantly getting the following error:"Inserting  'AR Payment' record raised at least one error. Please review the errors.; ARAccountID: 'AR Account' cannot be empty.; ARSubID: 'AR Subaccount' cannot be empty." Here’s is the body I’m passing:{        "ReferenceNbr": { "value": "598089" },        "PaymentRef": {"value": "5006956/4/23/2024 8:18:10 AM" },        "AppliedToOrder": {"value": 200.00},        "CashAccount": {"value": "01010"},        "PaymentAmount": {"value": 200.00},        "PaymentMethod": {"value": "CASH"}}

I am trying to update Sales Price pricing via the REST API. There is no endpoint that I could see that will do this (there is the SalesPriceInquiry) – which seems to create the price if it does not exist, but it does not update. Is there a way to get it to update the price?I’m sending: SalesPriceDetails": [ { "EffectiveDate": { "value": "05/02/2024"}, "PriceType": { "value": "Customer" }, "PriceCode": { "value": "1000346" }, "Price": { "value": "12.99" }, "InventoryID": { "value": "OURSKU" }, "Warehouse": { "value": "CA" } }]But, I am getting the error:"error": "Duplicate Sales Price. This line overlaps with another Sales Price (Price: 10.990000, Effective Date: 5/2/2024, Expiration Date: )",Is there a way to tell it to update if the price exists?

I am doing purchase order integration from my platform to acumatica so i need to pass my Product items from my platform to the purchase order creation in acumatica. For example i choose the 1st , 2nd and 3rd checkbox of select products , i choose a vendor now i hit the api so i am asking how will i send these products in my Purchase order create api and where will i see these Products name in my purchase order ?  these products that are in the product name by selecting a vendor so where will be these product will be added or from where i can see these products in my Purchase Order in acumatica.

Hi just wanted to figure out on how to do filters on the StockItem endpoint? I wanted to filter to get Inactive items. What I’ve tried so far is adding this paramsItemStatus=Inactiveconditions = “ItemStatus eq Inactive”

Does anyone know the difference between default and MANUFACTURING endpoint in Acumatica OData?  

 AR302000Content ARPayment = context.AR302000GetSchema();                #region PaymentCommand                var cmdInsert = new Command[]                {                 new Value                  {                 Value = "Payment",                  LinkedCommand = ARPayment.PaymentSummary.Type                 },                 new Value                  {                 Value = "CATLX11572",                  LinkedCommand = ARPayment.PaymentSummary.Customer                 },                 new Value                  {                 Value = "MAIN",                  LinkedCommand = ARPayment.PaymentSummary.Location                 },                 new Value                  {                 Value = "USD",                  LinkedCommand = ARPayment.PaymentSummary.Currency                 },                 new Value                  {                 Value = "Balanced",                  LinkedCommand = ARPayment.PaymentSummary.Status                 },                 new V

When i try to create an Purchase Order using the REST API in the postman i am getting an "error": "'SubItemID' cannot be empty.; SubItemID: 'SubItemID' cannot be empty." How can i resolve this issue ? from where will i pass the SubItemID is it in the vendors , stock items or some other tab ? also where will i send in my Products ? How can i do it ? This is what i am sending in the Request body  This is the response i am getting  Also if i need to send the list of products where should i add it and where will it be seen ?? 

Hello all, What ID do I put in the Owner Field of a PO. When I use the Employee id it does not work. "error": "'Owner' cannot be empty."   "Owner": {        "value": "4264",        "error": "Owner 'E00003    ' cannot be found in the system."    },

I am doing the Integration with my Platform to Acumatica , Now i need to create and Update the Purchase Order and Invoice from my platform to acumatica. So someone can explain me the steps i need to do this integration. I have hit the API to create the Purchase order but I need to add Products from my platform to acumatica from this modal form that i am providing it in the below screenshot.From here i will select the Products from the checkboxes and then choose the vendor from vendors dropdown and now i will create an invoice can anyone can help me to tell how will these products will be added in my purchase order ? what would be the location where i need to add these products ? what are the APIS i would require to use to send these products in the purchase order api so that when i open the purchase order nbr then these product will be added in my Purchase order.