Skip to main content

Develop Integrations with Web Services | APIs

Technical discussions focused on Web Services and APIs for developers

  • 796 Topics
  • 3,153 Replies
796 Topics
A
AxsysInvest
asked in Develop Integrations with Web Services | APIs
Create PO linked to SO from PO505000 via API

Hi All, I’m trying to generate Demand PO’s linked to SO’s from the PO505000 screen but am finding it will only generate a PO for one line item at a time, rather than the multiple items available for Purchase from the one supplier or multiple suppliers. I’ve created a Custom Endpoint via Web Services linked to the screen, added the ProcessAll button as an Action with OrderNbr and OrderType as parameters: I call via HTTP using Postman and the below Body: I get a 202 back saying its successful. What seems straight forward and works in the GUI with the above filter options, will only ever generate one PO for the first line, no matter how many lines there may be meeting the criteria. Not sure what I’m missing and this seems like a process many people would want to use via API?? Is there something required in the Entity that I am missing?? Any help appreciated :-)

131
Dmitrii Naumov
Acumatica Moderator
asommer
Jr Varsity III
asommerJr Varsity III
asked in Develop Integrations with Web Services | APIs
Create ARInvoice from Webhook

Good day, I’m working on a webhook for integration with a third party. The webhook runs find until I try to create an ARInvoice and add an ARTran to the InvoiceEntry. The error I’m getting is in the SM_ARInvoiceEntry.cs file IsLineCreatedFromAppSO method. The base.Base.Accessinfo.ScreenID is null. We have a separate integration using a custom screen with a custom Action, but using webhooks will be much better for our purposes. Is there a way I can set the ScreenID from a webhook in order to create the ARInvoice with ARTran items? Here is the webhook code: namespace EcrsWebhook{ public class EcrsWebhookHandler : PXGraph<ARInvoiceEntry>, IWebhookHandler { private static readonly Newtonsoft.Json.JsonSerializer Serializer = new JsonSerializer(); decimal INFRA_DISCOUNT = (decimal)0.15; public async Task HandleAsync(WebhookContext context, CancellationToken cancellation) { ECRSConfigs MAXIO_KEY; using (JsonTextReader reader = new JsonTextReader(context.Request.CreateTextReader())) { // Creat

208
asommer
Jr Varsity III
F
FatgalahTimothy
asked in Develop Integrations with Web Services | APIs
Upgrading SalesOrder API from 18.200.100 to 20.200.100

I have an api that pushes salesorders and it works if I set the version to 18.200.001. When I move it to 20.200.001 it fails with the error [message] => An error has occurred. [exceptionMessage] => Sequence contains no matching element [exceptionType] => System.InvalidOperationException [stackTrace] => at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source, Func`2 predicate) at PX.Api.ContractBased.EntityExportContextBuilder.ExtractFieldMappingKeyForDetail(String mappingKey, EntityField field, EntityMappingProjection[] entityFields, IMetadataProvider metadataProvider, IEntityMappingKeyService entityMappingKeyService, String endpointName, String version) in C:\build\code_repo\NetTools\PX.Api.ContractBased\EntityExportContextBuilder.cs:line 1343 The only information I can find about changes is on page 55 of https://www.acumatica.com/media/2020/09/AcumaticaERP_IntegrationDevelopmentGuide.pd Where it says‘• The type of the Payments field is changed. • Mapping has changed‘ After I g

101
D
Captain II
M
Freshman I
Mikemedved21Freshman I
asked in Develop Integrations with Web Services | APIs
Customize Time Entry to Save Notes

Given the issue with the Time Entry Webservice and form, can a user implement in interim fix by customizing the form, or building a new web service endpoint. Our deployment won’t be able to upgrade to 2025R1 in the near future. Thank you Pushing Notes for time activities, and auto completing time activities when creating | Community

130
M
Freshman I
P
pemith30
asked in Develop Integrations with Web Services | APIs
SMS gateway integration with Acumatica

Has anyone done an SMS gateway integration with Acumatica ? Can you integrate any Bank’s SMS gateway as long as they have the right APIs ?

80
P
R
Freshman I
ryanmiterFreshman I
asked in Develop Integrations with Web Services | APIs
Pushing Notes for time activities, and auto completing time activities when creating

Hi everyone. I’m trying to pass a “notes” field in when creating or updating Employee Time Activities. Below is an example of my request: PUT "/entity/Default/22.200.001/TimeEntry" { "note": "Some notes", "BillableTime": { "value": "01:00" }, "Date": { "value": "2024-02-16T06:00:00-08:00" }, "Summary": { "value": "Hours from Timesheet" }, "EarningType": { "value": "RG" }, "Employee": { "value": "EP00000002" }, "LaborItem": { "value": "CONSULTSR" }, "ProjectID": { "value": "X" }, "TimeSpent": { "value": "01:30" } } The Time Activity gets created, but the notes do not get passed through. Also, I’m trying to run the CompleteTimeEntry action on the PUT "/entity/Default/22.200.001/TimeEntry", but I always get the “Invalid uri structure” error even though I have this as a mapped action: Any ideas what’s happening?

11010
M
Freshman I
G
Freshman I
geoffatsourceFreshman I
asked in Develop Integrations with Web Services | APIs
Purchase Order API: Bug when placing a PO on Hold

When I attempt to release a purchase order from hold via the API, sometimes I get the following error: Operation failed: At least one line is not present in the cost budget of the project. Either add the corresponding budget lines to the project or select the Allow Adding New Items on the Fly check box on the Summary tab of the Projects (PM301000) form I get the same error when try to do so from the user interface: Oddly, if I try a second time, either via a repeating the API request, or by pressing the button again, the error does not occur. What could be going on?

222
A
Jr Varsity I
M
Freshman II
mvinesFreshman II
asked in Develop Integrations with Web Services | APIs
Add Default Salesperson to Customer using API

I am adding customers with the ERP api. Part of this process is assigning the default salesperson to the customer. For things like the MainContact/Address, I can just $extend the customer entity being saved, but this does not seem to work for Salespersons, How do I attach a default salesperson to a customer with the api? PUT /20.200.001/Customer?$expand=Salespersons,MainContact/Address {..."Salespersons": [ { "SalespersonID": {"value": "SALEPERID"}, "Default": {"value": true} } ]...} This will result in 200 OK, but no Salespersons will be assigned to the customer. {..."Salespersons": []...} What do I need to do to get this salesperson assigned to the customer?

333
jinin
Pro I
S
Freshman II
shuangFreshman II
asked in Develop Integrations with Web Services | APIs
Acumatica OAuth: Per-Tenant Client Credentials Required for multi-tenant Integration?

Hello Acumatica Developer Community, I'm currently working on implementing an integration with Acumatica and have a question about the best approach for handling multi-tenant authentication. Authentication Challenge For OAuth authentication, we need to store and manage client ID and client secret credentials. Since Acumatica supports multiple tenants, I'm wondering about the best practice for handling authentication in this context. For multi-tenant support, we need to determine if Acumatica requires separate client credentials per tenant: Does each tenant instance require unique client ID/secret pairs in Acumatica, or can a single set of credentials work across multiple tenant instances with the same base domain? Thank you!

191
Samvel Petrosov
Jr Varsity II
G
Freshman I
geoffatsourceFreshman I
asked in Develop Integrations with Web Services | APIs
Purchase Order, adding a Detail changes an existing detail unit cost

I have a Purchase Order with three line-items (Details). I create the PO and there’s no problem, but when I do to add a Detail, it randomly updates a different Detail. The new detail has no id (because it is new) and has a LineNbr of -1. Here is the PO details when I first create it: Here is the payload which I PUT to the PurchaseOrder endpoint { "id": "bdb7e18e-5300-f011-8368-065d7e32b4d5", "Details": [ { "AlternateID": { "value": "8b974d0f-5f8a-b586-5e1a-a3d3900830ed" }, "Account": { "value": "Accounts Payable (A/P)" }, "BranchID": { "value": "SOURCE" }, "OrderNbr": { "value": "24-TST2-024" }, "InventoryID": { "value": "OTHER" }, "LineType": { "value": "Service" }, "LineNbr": { "value": -1 }, "LineDescription": { "value": "Measure & Install Trip" }, "UOM": { "value": "EACH" }, "OrderQty": { "value": 1 }, "UnitCost": { "value": 3500 }, "ExtendedCost": { "value": 3500 }, "Description": { "value": "COGS Contra - Fees" }, "Project": { "value": "24-TST2" }, "ProjectTask": { "value": "PURC

785
RohitRattan88
Acumatica Moderator
M
mjjoachim
asked in Develop Integrations with Web Services | APIs
REST API Not Returning Error for an Invalid Account on Bill Detail

I am using the Acumatica REST API to create vendor bills. I am using the "Default" endpoint, version 24.200.001. I see the same behavior in older versions of the API too. When I submit a bill with an invalid account number on a bill detail line, the vendor's default expense account is used and no error is returned unless there is also an error with another field. The bill is successfully created and the response code is 200. Other bill detail line fields do not behave this way. For example, if I pass an invalid value for the Branch or Subaccount fields the bill is not created and the response code is 422. If I submit invalid values for both Account and Subaccount, the call fails but only the error for the invalid Subaccount value is returned. If I submit invalid values for both the Vendor field at the header level and Account the bill is not created. The response code is 422 and the body indicates both that the vendor could not be found and that the account could not be found: { "id":

150
M
K
Freshman I
kkrausFreshman I
asked in Develop Integrations with Web Services | APIs
How to Extend Endpoints to an older version?

We’re trying to connect Acumatica to Power Automate, however, the program requires version 17.200.001. I’ve been trying to extend the default endpoint to 17.200.001, however, whenever I do, I get the error: “Versions of the contract for a system endpoint cannot be created. Create a custom endpoint and give its contract another name.” However, if I try to name the extension something else, it just doesn’t create anything. Is there a way to access Power Automate this way?

283
Yuriy Zaletskyy
Jr Varsity I
N
Freshman II
nickacfieldFreshman II
asked in Develop Integrations with Web Services | APIs
Get Unbilled Quantity per line in a POReceipt via API

Hi, I am needing to get the Unbilled Quantity left on a Receipt.I can only get the total of all lines, but not the breakdown. Is there a way to do this? /entity/Default/22.200.001/PurchaseReceipt/?$expand=Details&$filter=VendorID eq 'V000000001' and ReceiptNbr eq '000092' here is my API Call URL. I have expanded details. there is nothing in custom etc

323
N
Freshman II
N
Freshman II
nickacfieldFreshman II
asked in Develop Integrations with Web Services | APIs
GET PurchaseReceipt Can i filter api response by any containing Details/POOrderNbr = ' certain value'

Hi, How can i GET PurchaseReceipt - List of Lines that are for a certain PO number?I cannot seem to filter by expanded objects. Otherwise to get all Receipt Lines against a certain PO I will need to dig out all receip[ts for a supplier and loop through all returned lines to get my filtered list. here is my API call returning a 500 - "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=VendorID eq 'V000000001' and Details/POOrderNbr eq '000018' or is there a way to query ReceiptLines seperately?

717
N
Freshman II
G
Freshman I
geoffatsourceFreshman I
asked in Develop Integrations with Web Services | APIs
Reopen a Purchase Order via the default API?

Is there a way to reopen a purchase order that was set to “completed” via the API? I have some tests that are cancelling line items and some of the POs are being closed automatically and I can’t delete them when I run my cleanup script.

4910
G
Freshman I
G
Jr Varsity III
grillevanJr Varsity III
asked in Develop Integrations with Web Services | APIs
Acumatica - Avalara Integration; Is it set up to pass Latitude/Longitude to calculate Sales Tax

Good day, Avalara has the ability to calculate sales tax by entering the Latitude/Longitude manually. My question is does the Acumatica - Avalara integration set up to pass this information from the Project Address tab. Some of our projects have a state/city/ postal code but not actually address just a location on a pipeline. I have seen any documents or announcements. Thank you

272
G
Jr Varsity III
jinin
Pro I
jininPro I
asked in Develop Integrations with Web Services | APIs
Unable to make Customer Contact as primary except for the First record through API call

Hello Everyone, I am trying to make a customer contact as primary through API call. But it is working for the first entered contact. Unable to set another contact. Could you please review and share your feedback?

2928
abrunner78
Jr Varsity III
B
Freshman I
BEXJensFreshman I
asked in Develop Integrations with Web Services | APIs
Get ID of ERP system from push notification

Hi folks, i’m looking for an possibility to identify the system that sent a push-notification. The notification body looks like that: { "Inserted": [ { .... } ], "Deleted": [], "Query": "<my_query>", "CompanyId": "<my_company>", "Id": "8d6d670d-86e0-477f-a8cc-343b578ba3dd", "TimeStamp": 638775642732888022, "AdditionalInfo": { "PXPerformanceInfoStartTime": "03/14/2025 15:51:12" }} However, if i receive push notifications from different systems (different domains) i can’t figure out which system sent the notification. I only have the company id but I don’t think that the companyid is unique. Does anyone know how to solve this problem? Thanks in advance.

152
B
Freshman I
H
Semi-Pro II
HarrySemi-Pro II
asked in Develop Integrations with Web Services | APIs
Login Syntax for OData

Hello community, I have been trying to use a GET method to login to my Acumatica instance using Postman, but it displays 404 error or sometimes 401 unauthorized error. i have created a user account and have given the account as Admin & Access to OData roles. I have been using the following syntax in the postman: https://site URL/AcumaticaERP/OData Is this the correct syntax that I have been using? If yes then why I am facing the issue? Thanks in advance.

70115
R
Freshman II
M
Varsity I
matthewgerdanVarsity I
asked in Develop Integrations with Web Services | APIs
REST API: Sequence of field defaulting causing errors

Hi Everyone, MYOB customer updating from 23R1 to 24R1. Having an issue where the Payment endpoint in the API is returning an error that the cash account cannot be found. This error is also experienced in the UI and is due to the Branch that is defaulted from the customer record being a different branch than the cash account (fair enough). The request body has the correct value for the branch so that if all values of the API request were entered in the correct order, then the payment would be valid. Is there a way to control the sequence that values in API requests are entered so that defaulting happens in the correct order?

373
M
Varsity I
P
Jr Varsity II
PBSAJr Varsity II
asked in Develop Integrations with Web Services | APIs
Production Order Details API Scheduling (Time Zone Problem)

​TLDR; How can I avoid time zone issues with Plan dates on Production Order Details when they are created via API? Due to the long JSON blocks, this question split over the first few comments as well. Configuration: My Site Preferences ‘Login Time Zone’ is blank My logged in UI user is also set to a blank Time Zone My API user’s Time Zone is blank I am using infinite scheduling with a Finish On Constraint The Work Calendar is M-F 11 hour days in UTC-08:00 Request: I log in via Postman to the API user for my local Acumatica instance. Then I PUT a Production Order (entity/MANUFACTURING/23.200.001/ProductionOrder?$filter=ProductionNbr eq 'DATETEST'): { "OrderType": { "value": "RG" }, "ProductionNbr": { "value": "DATETEST" }, "InventoryID": { "value": "018954" }, "OrderDescription": { "value": "test product" }, "Warehouse": { "value": "PBNW" }, "Location": { "value": "*MFG" }, "OrderDate": { "value": "2025-01-03T00:00:00-08:00" }, "QtytoProduce": { "value": 31 }, "UOM": { "value": "EA" },

819
Chris Hackett
Community Manager
S
Freshman I
sclassingFreshman I
asked in Develop Integrations with Web Services | APIs
$select after API action returns empty body

We have defined an action on SOShipment and exposed it via the REST API. When we call the action for the API we define a query string param $select=ShipmentNbr. The action succeeds, but the the return body is empty. We expected to see an SOShipment, with the ShipmentNbr specified. How can we fix this? Here are the details On SOShipmentEntryExt, we define an action named AddShipmentNbr. public PXAction<SOShipment> AddShipmentNbr; [PXUIField(DisplayName = "Add ShipmentNbr", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select)] [PXButton()] public virtual IEnumerable addShipmentNbr(PXAdapter adapter) { ... } We exposed this action as an Action on the Shipment REST API, naming it LockShipmentMutex. We construct a call in Postman POST {{PackingEndpointURL}}/Shipment/LockShipmentMutex?$select=ShipmentNbr BODY { "entity": { "id": "6B4E9A21-78F6-EA11-96A4-000D3A610F1B" }} The action succeeds, but we receive an empty body in the response. We expected to receive a SOShip

233
Dmitrii Naumov
Acumatica Moderator
B
Semi-Pro I
bpgravesSemi-Pro I
asked in Develop Integrations with Web Services | APIs
REST API: retrieving CustomerPaymentDetail from CustomerPaymentMethod

When I use the following, I am able to get everything except the Details (CustomerPaymentDetail): entity/Default/22.200.001/CustomerPaymentMethod/?$filter=CustomerID+eq+'C10987654321'+and+PaymentMethod+eq+'CC Visa'+and+ProcCenterID+eq+'procID'+and+CustomerProfileID+eq+'12345678901' The Details are in the Web service endpoint. Is there a specific URL parameter I need to pass to see it?

151
Dmitrii Naumov
Acumatica Moderator
amitr70
Semi-Pro I
amitr70Semi-Pro I
asked in Develop Integrations with Web Services | APIs
Exposing Inventory Summary Available to Ship field to StockItem endpoint

Hi , I wanted to extend my stock item end point to include Available to Ship value of Inventory Summary screen. To do so, I Create a custom view and tried to populate the field from DAC level only. So that when called from API it will resolve the BQL and fire the data to the API. I want this field for API only so I dont have any screen level events attached to this DAC field. Below is my code public class TSInventoryItemNIExtension : PXCacheExtension<PX.Objects.IN.InventoryItem> { public static bool IsActive() => true; #region UsrAvailToShip [PXDBDecimal] [PXSelector(typeof( Search<TSViewGetAvailToShip.qtyHardAvail, Where<TSViewGetAvailToShip.inventoryID, Equal<Current<InventoryItem.inventoryID>>>>))] [PXUIField(DisplayName = "Avail To Ship")] public virtual decimal? UsrAvailToShip { get; set; } public abstract class usrAvailToShip : PX.Data.BQL.BqlDecimal.Field<usrAvailToShip> { } #endregion } In the above DAC TSViewGetAvailToShip is a Sql view that return a list all StockItems with Q

416
Chris Hackett
Community Manager
S
Varsity III
safetynetwebVarsity III
asked in Develop Integrations with Web Services | APIs
creating payment for custom sales order cause error

We are using end point to create payment for our sales order, the default Sales Order Type is “SO”, when creating payment record it works and get added correctly. We added a new Sales Order type “CL” with a separate sequence. But when sending the payment to it it returns this error: An error occurred during processing of the field Order Nbr.: The order cannot be applied, the specified combination of the order type and order number cannot be found in the system Although in the request the order NBr is correct and OrderTYpe, here is the payload of the payment creation request: $data = [ "Type" => ["value" => "Payment"], "CustomerID" => ["value" => "CUST001"], "CashAccount" => ["value" => "MAIN"], "PaymentMethod" => ["value" => "CHECK"], "PaymentAmount" => ["value" => 100], "OrdersToApply" => [ [ "Type" => ["value" => "CL"], "OrderNbr" => ["value" => "CL00000001"], "AppliedToOrder" => ["value" => 100] ] ]]; When doing the same call for sales orders of the type “SO” and orderNbr with the s

544
S
Varsity III

Go to

Discussion Forums
Financials
Distribution
Manufacturing
Construction
CRM
Field Service
Retail
Payroll
Professional Services
Low Code | No Code Customizations or Integrations
Develop Customizations
Develop Integrations with Web Services | APIs
Other Developer Topics
ISV Solutions
Configuration and Installation
Reports and Generic Inquires
Import and Export Scenarios
System Health and Performance
Community site discussions
Community Introductions
Everything Else
Technology Partners and Customers
News & Announcements

Tags

Most helpful members this week

Badge winners

Show all badges
Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved