Introducing Acumatica Cloud ERP: 2026R1
Technical discussions focused on Web Services and APIs for developers
Recently active
Hello,I’m currently trying to set up a webhook or similar functionality in Acumatica, where I can receive data to my custom page URL whenever specific events occur, such as an inventory update or sales order creation.I’ve looked into Business Events and adding Subscribers, but I couldn’t find an option to directly specify my page URL to receive a webhook response. Am I approaching this the right way, or is there another recommended method for achieving this?Looking forward to your guidance.
Hello all, I am trying to Reverse an invoice and apply credit memo via the API. I have extended the endpoint and added the action ReverseInvoiceAndApplyToMemo. I am not sure where to find the correct payload to pass to it. If I pass the below I get “ "The Reverse and Apply to Memo button is disabled."Does anyone know or where do I find the correct payload to send? Thank you { "Entity": { "RefNbr":{"value":"AR000003"} }}
Hi Team hope you are doing well, POST /Release i’m trying to release refund type in the payment object using rest api { "entity": { "Type": { "value": "Refund" }, "ReferenceNbr": { "value": "000077" } }}the response is { "statusCode": 202} but when i check the page in Acumatica the refund the release button is still there Thanks
I am trying to create a Sales Invoice with a Payment but i get the following error: "An error occurred during processing of the field CuryAdjdAmt: Nullable object must have a value.."I am using the /Default/23.200.001/SalesInvoice endpoint and this is my request:What am I missing or do i need to create first the Sales Invoice, then the Payment and then apply it? { "ReferenceNbr": { "value": "<NEW>" }, "CustomerID": { "value": "ABAKERY" }, "ExternalRef": { "value": "801PM00000DhqGnYAJ" }, "Type": { "value": "Invoice" }, "IsSpecialOrder": { "value": false }, "Date": { "value": "2024-04-22" }, "ShipToAddressLine1": { "value": "Test" }, "ShipToOverrideAddress": { "value": true }, "ShipToOverrideContact": { "value": true }, "ShipToCity": { "value": "Test" }, "ShipToCountry": { "value": "US" }, "ShipToPostalCode": { "value":
How to Create SalesOrder with Shipping and Payment details using REST API in node js
Does anyone know if there are efforts to create an Authorize.net module that is community supported? The depreciation of this module seems like a may have an adverse affect on many businesses. If anyone is developing an alternative module I would like to assist. Thanks,
Hi All,Is there a way to retrieve the Supplier Balance, Prepayment Balance, and Retained Balance details (as shown in the attached image) for a particular supplier through a Postman call?Any guidance or suggestions would be greatly appreciated.Thanks,Lalith
Hello! While developing a customization project to extend a webservice to migrate data from our legacy ERP into Acumatica, I have discovered that while there is a standard ‘CustomerLocation’ object where we can access and modify customer location entries, there is no equivalent VendorLocation object. I tried to create a VendorLocation endpoint by mimicking how the Customer Location fields were all mapped, but there do not appear to be equivalent mappings in order for me to accomplish this. Additionally, if I just select all fields from the Vendor Location Summary, it corrupts things so badly that we start getting stack overflows when trying to push a Sales Order into Acumatica:And when we try to pull the VendorLocation data via Postman, it would throw errors relating to the Address information we had mapped directly from the Vendor Location Summary (here’s a small snip of that error):"message": "An error has occurred.", "exceptionMessage": "The multi-part identifier \"BAccountID!Add
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 = n
I have a scenario where I need to programmatically invoke the delete action on AR Documents in specific scenarios. however, I am not finding the correct action to invoke in the api.I have verified this AR Document exists, is in status ‘Balanced’, and the Delete action is available from the UI.POST <host>/Payment/DeleteBODY { "entity": { "ReferenceNbr": { "value": "<refNum>" } }}RETURNS 204: No ContentWhat am I missing?
Making a POST request to the endpoint /entity/Default/22.200.001/Payment/VoidPayment with the body like "Entity": {"id": payment_id,"Hold": false,"Branch": “branch_name”,}returns a 204. We expect that this will actually void the prepayment, but the prepayment is still active. Is there any changes that should be made to this request to make it succeed or at least return an error
The following error occurs when I try to create an expense receipt using the REST API. Could anyone help with this?Error: error: "Inserting 'Expense Receipt' record raised at least one error. Please review the errors.; TranDesc: 'Description' cannot be empty.".Body:{ "Date" : {"value" : "04/17/2025"}, "ExpenseItemID" : {"value" : "MEAL"}, "Details": [ { "Description" : {"value" : "Team outing"}, "Quantity" : {"value" : "2"}, "UOM" : {"value" : "PIECE"}, "Amount" : {"value" : "175"}, "Currency" : {"value" : "USD"} } ] }
Can you please demonstrate, or point me to documentation for the addition of Cash Transactions programmatically?Accounting is currently appending credit card fees to their ledger by manually (UI) adding a Cash Transaction (CA304000) at the end of the period for the sum of all fees collected.I have been asked to create this same transaction through the api. Usually, between the screens, and the api documentation, I can come up with the end points, but so far I have been unable to figure out what these are.I have noticed that JournalTransactions can be created directly from the api, but only in the GL module. When accounting releases these existing Cash Transactions, they result in CA module JournalTransactions. These can not be added through JournalTransactions, but it’s the only way I have found to affect the transactions directly at all.
Hello,I’ve created a custom endpoint in Acumatica, but I’m encountering issues when trying to retrieve or manage the approval mapping details, specifically the approval steps and associated rules. Despite setting up the custom endpoint, I am unable to retrieve the step and rule details.When I perform a GET request to the Approval Maps (EP205015) screen, I receive the following response:{ "id": "3bdd9e49-3ae5-ef11-8220-a0481c0a4b38", "rowNumber": 2, "note": { "value": "" }, "ApprovalMap": { "value": 3 }, "Conditions": [], "EntityType": { "value": "Purchase Orders" }, "MapEntityType": { "value": "PX.Objects.PO.POOrder" }, "MapId": { "value": 3 }, "MapName": { "value": "Purchase order" }, "Name": { "value": "Purchase order" }, "Steps": [], "custom": {}, "_links": {
Hi Everyone,Can anyone help me provide the Json request to insert the Payment Instructions details in the Vendors → Default Payment Settings → Payment Instruction details?
Hello - I would like to import some forecasting data into custom DAC’s using the API. I’ve worked with parent/child data before and imported via the API but I’m finding this situation difficult because the forecasting data consists of 3 levels of data. I’m not sure how to configure the graph or the API to get this working. Here is a cut down version of the DAC’s, in the code I’ve included PXParent and PXDBDefault to link the DACs.DAC 1 - ForecastHeaderForecastNbr (key)CustomerDAC 2 - ForecastLineForecastNbr (key)LineNbr (key)ProductCodeDAC 3 - ForecastScheduleForecastNbr (key)LineNbr (key)ScheduleNbr (key)ForecastDateForecastQty With this type of DAC structure I would like to submit json in the following structure.{ "ForecastNbr": {"value": 1}, "Customer": {"value": "Customer001"}, "ForecastLine": [ { "LineNbr": {"value": "1"}, "ProductCode": {"value": "Prod001"}, "ForecastSchedule": [ { "ScheduleNbr": {"value": "1"}, "ForecastDate": {"value": "2025050
How to get Check and payment screen in Type dropdown value rest api endpoint .i want to get all doctype in check and payment which return doctype array.
Hi Team, When putting a bill/adjustment i am specifying my tax catagory, but its just defaulting to the default tax cat set on the tax zone id on the vendor. No matter what i do.if i set the vendor tax zone id’s default taxcat to nothing, i get no taxcat on the bill lines.Working with overheads for now, with no inv code on lines! (PO is fine because you select tax cat on the line items in the PO.)ive tried adding these to the header also; "IsTaxValid" => [ "value" => false], "TaxZoneID" => [ "value" => "MYWANTED ZONE ID"],confirmed my tax catagories exist in the tax zone used...and my detail lines as follows;"InventoryID" => ["value" => null]"LineType" => ["value" => "MiscCharge"] - was told to add this by GPT, no effect"UOM" => ["value" => "EA"], - UOM mandatory for tax apparently"TaxAmount" => ["value" => number_format((float) $InvoiceLine['TaxItemAmount'],5,".","")] - tried with or without this"TaxCatagory" => ["value" =
Hi everyone. I need to create a webhook, but I'm having trouble accessing AccesInfo.BranchID. I tried using PXContext.GetBranchID(), but it doesn't work. Does anyone know the best way to implement this?
Hi,I been trying to use the Process Bank Transactions (CA306000) screen via API to be used by 3rd party app, how can I make a correct call on the extended API endpoint for Process Bank Transactions? as I have tried, I cannot find any solution on how I can make it work. Web Service Endpoint Method: POSTJSON body: { "CashAccount": { "value": "CA2000" }}Error: "The record was not processed because of an error during processing of the previous record" METHOD: GETParam: $filter=CashAccount eq 'CA2000'Error:"Optimization cannot be performed.The following fields cause the error:\r\nCashAccount: View TranFilter has BQL delegate\r\n"
I’m currently working with the Acumatica API and noticed that some REST services typically return a totalCount field or include the total count of records as part of the metadata in their responses. However, I couldn’t find any documentation or examples indicating that Acumatica supports this feature, in fact the opposite from the links i pasted below.Specifically, I’m looking for a way to retrieve the total number of records in a dataset (e.g., total orders or customers) alongside a paginated response. I don’t see a totalCount in the response body, nor have I found any mention of it in headers like X-Total-Count.My questions are:Does Acumatica support returning the total count of records in the API response? If not, is there a recommended approach or workaround to efficiently retrieve the total count of records? Should I rely on a separate API call to count the records? Are there any best practices for handling this in Acumatica? Any insights or suggestions would be greatly appreciat
Last Read Message: The NONMEMBER price list could not be exported because at least one item in it does not exist in the BigCommerce store. Synchronize all the items in the price list, and then process the price list again.We have 4 Price Lists, and all are reading the same error.Price Lists: PREMIER, NONMEMBER, PRACTICON, WHOLESALEWe have no sync errors on the finished products. The only thing I can think of, is new products not yet ready to be installed in BigCommerce are on the Price Lists, so that may be stopping it. Is anyone familiar with this?
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
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 1343The only information I can find about changes is on page 55 of https://www.acumatica.com/media/2020/09/AcumaticaERP_IntegrationDevelopmentGuide.pdWhere it says‘• The type of the Payments field is changed.• Map
I've built out an Acumatica Webhooks project. I've successfully got it reading the incoming POST, and figuring out what to what to do. So far I can successfully insert Customers, Customer Locations and Projects without an issue. Honestly, from someone who does a fair amount of integration work, this is basically magic. These integrations are as close to real-time as is practical, so amazing work Acumatica.That said, using nearly the same code, I'm trying to insert AP or AR Invoices and I get bizarre or meaningless errors.I’ve stripped that code down to the most basic version, and when running the code that lives in the webhooks dll from a button on a graph it works exactly as expected. When it runs within the webhooks environment itself I get weird errors.For what it’s worth I’m running in 22R2, but I moved the code over to 23r1 and I get the same issues.My case in “in engineering review” so I thought I’d field it here to see if anyone has thoughts on what it is about the AR/AP graphs
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.