Develop Integrations with Web Services | APIs

I'm looking for a way to manage a tenant's configuration as code — declarative files in a git repo I can review in a pull request, version, and re-apply to rebuild a tenant reproducibly.By "configuration" I mean setup data, not customization code: enabled features, company/branch structure, chart of accounts, ledgers, GL preferences, currencies, credit terms, financial calendars, and the like.The workflow I want is basically infrastructure-as-code — capture a tenant's setup into source files, edit them in git, apply to another tenant, then diff to catch drift.Customization Projects cover code but not this setup data. Snapshots are reproducible but are whole-database blobs — not human-readable or diffable in a PR. The REST API can push data, but it's a building block, not a desired-state workflow.Is there an existing tool or established pattern for this — a community tool, an ISV product, or something people have built in-house? Curious how others handle it.Thanks!

Hi everyone, I have created a community n8n node for the Acumatica REST API.n8n-nodes-acumatica - npmlekker-solutions/n8n-nodes-acumatica: Acumatica n8n NodeThere are 3 nodes you can use: Default / 25.200.001 Default / 24.200.001 Custom (You enter the Name / Version)On each defined resource on the endpoint, the following operations are allowed:Get List (GET) Get by ID/Keys (GET) Create/Update (PUT) Delete by ID/Keys Invoke Action Attach File Download File Custom API CallOther Notes:Custom fields are not handled yet on the DEFAULT endpoints, so just use the Custom Endpoint node.   For auth, only OAuth Authorization code flow is supported, but setting up a credential is very easy (There is a built in ‘Acumatica Credential’)If you are unsure how to use a community node:Using community nodes | n8n DocsHopefully this helps speed up your integrations using n8n! 

In 25R2 I have an admin user account that has access to the AR Invoices and Memos, yet when I try to access the odata for the DAC, I get a 403 after entering my credentials.https://url.acumatica.com/t/tenant/api/odata/dac/ARTaxTran?$top=1The same user works on other DAC level odata endpoints. I also tried the odata4 url string:https://url.acumatica.com/ODatav4/tenant/ARTaxTran?$top=1I assume I’m missing something simple :-)

Hi all,I'm trying to create a prepayment invoice via the Acumatica Contract-Based REST API. I'm POSTing to:/entity/BDP/24.200.001/SalesOrder/CreatePrepaymentInvoiceOKWith payload:{  "entity": {    "OrderType": {"value": "SA"},    "OrderNbr": {"value": "0001170"}  },  "parameters": {    "PrepaymentPct": {"value": 100.00},    "CuryID": {"value": "GBP"}  }}I'm getting a 500 error: "The Create button is disabled" (PXActionDisabledException). The SO status is fine — I can create the prepayment invoice manually without issue in SO301000 and SO501000.My understanding is that the Acumatica commerce connector creates prepayment invoices via the API successfully — so there must be a way to do this. Has anyone solved this, or can point me to how the commerce connector achieves it?Thanks, James

We are an engineer to order environment with an external, non-Acumatica product configurator. The output of the configuration tool is a JSON collection of operations, phantom sub assemblies, and materials. We are looking for an API based solution to create Production Orders linked to a Sales Order Line with a custom BOM. We're able to create the Production Order, but are running into difficulties identifying the correct method of providing the Operation collection along with their associated Materials [Stock Items]. We’ve tried using ProductionOrder, ProductionOrderDetail, and the CreateProductionOrder/CreateProductionOrderProcess[All] Action and have not had any success getting the Operations collection to populate.For example, in ProductionOrderDetail, we’ve supplied the Operations like below:{        "AllowPreassigningLotSerialNumbers": {        "value": true    },    "Branch": {        "value": "PRODWHOLE"    },    "CostingMethod": {        "value": "Actual"    },    "Hold": {     

According to this article, /entity is the way to get a site’s build number from the API. When will this also include the patch segment (e.g. 26.100.0175.2)?

For building an ETL pipeline to warehouse Acumatica data, are there any approaches to detect deleted records besides the traditional primary key comparison method?

Hi everyone,I'm currently working with Acumatica Cloud ERP 2024 R1 and using the REST API to manage file attachments on various documents (e.g., Sales Orders, Invoices, etc.).What I can already do:I’m successfully attaching files to entities using the files endpoint like this:PUT /entity/Default/24.200.001/files/PX.Objects.AR.CustomerMaint/BAccount/{entityID}/{filename}This works well — the file is successfully attached and visible under the Files tab on the customer screen.What I want to do next:I would like to add a comment to this file — just like you can do manually in the UI by entering a comment when attaching a file.My assumption so far:From what I understand, this may require two separate REST calls: PUT — attach the file (already working ✅) Some second request to update the file record and add a comment (❓) But I haven't found a working REST example for that.My Questions: Is it possible to attach a comment to a file via REST API in Acumatica 2024 R1? If yes — what is the r

Hi Acumatica Community!I’m releasing Acumatica Knowledge MCP, a free, read-only knowledge server for AI tools that support MCP.It gives AI assistants searchable Acumatica reference context across Help Wiki documentation, DACs and fields, OData entities, Contract-Based REST API entities, and Generic Inquiry XML examples.It does not require an Acumatica tenant connection. It is safe to use because it is read-only and does not write anything back to Acumatica.Setup is simple: add a single MCP URL to any agent or AI tool that supports MCP.Website with connection details and how it works:https://knowledge.acutools.netThis is the first public release, so feedback is very welcome. I’d especially appreciate hearing where the search results are useful, where they miss, and what Acumatica knowledge areas or tools you would like to see added next.I’m also happy to help anyone get it set up or answer questions.  

We’re having an issue where Acumatica 2025R2 is not respecting the dates that we are sending through the API (MANUFACTURING/23.200.001) when creating Move Entries.  It seems to always default to the system date.  Here is the JSON we’re sending and the date is 2026-06-01 but the resultant Move Entry in the web interface shows today’s date.  Any thoughts or suggestions?{"Document" : {"Date" : {"value" : "2026-06-01T00:00:00+00:00"},"ProductionNbr" : {"value" : "00137227"},"Hold" : {"value" : false},"ControlQty" : {"value" : 8},"OrderType" : {"value" : "RO"},"PostPeriod": {"value": "062026"}},"Details" : [{"Quantity" : {"value" : 8},"ProductionNbr" : {"value" : "00137227"},"UOM" : {"value" : "EA"},"OrderType" : {"value" : "RO"},"OperationNbr" : {"value" : "0010"},"InventoryID" : {"value" : "301238"}}]}

I am creating a Payment/Prepayment through the Acumatica Contract-Based REST API and applying it to a Sales Order using the OrdersToApply detail.The same API payload structure works for several Sales Orders, but it fails for some specific orders with the following 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.Sample request structure:{ "CashAccount": { "value": "XXXXX" }, "CurrencyID": { "value": "USD" }, "CustomerID": { "value": "CXXXXXXXXXXX" }, "Description": { "value": "Shopify Payment XXXXX" }, "Hold": { "value": false }, "OrdersToApply": [ { "AppliedToOrder": { "value": 69.08 }, "OrderNbr": { "value": "ES88832" }, "OrderType": { "value": "ES" } } ], "PaymentAmount": { "value": 69.08 }, "PaymentMethod": { "value": "SHOPPAY" }, "PaymentRef": { "val

I have created a Bill using PUT /Bill REST API endpoint and it created below data, the process also includes releasing the bill but I am encountering a “The document is out of balance” error. It seems the bill header total figures were not calculated correctly. For this bill, I created its own PO and PO Receipt with vendor’s Allow AP Bill Before Receipt unticked (3way match)On second screenshot, I checked the PO Receipt linked to the Bill and based on the Billing tab, it shows Billed Amount as 550 which is correct and matched with the Bill line’s Amount. I am not sure what needs to be added on the payload when calling /Bill API endpoint but when I used UI to create Bill from PO receipt, I don’t encounter the “The document is out of balance” error.Thanks! 

I'm trying to download JournalTransaction data. I'm following the documentation to Retrieve the List of Records in Batches, using the $top and $skip parameters. I've tried different values for those.But I can see that as the $skip parameter grows each request take increasingly longer to finish.Finally, after ~1 hour of processing, it fails with a ReadTimeout. Even if I retry, after 60 secs or more, it keeps failing with ReadTimeout. It is not a session expiration issue: I tried with logout/login.Besides it is not consistent. For example with a $size of 500 it typically fails on $skip=115500. But sometimes I get up to the next page ($skip=116000) until it fails.And I can't get over that.Any ideas?

Hi, I would like to clarify a limitation I encountered when working with the Paycheck entity (Screen ID: PR302000 - Paychecks and Adjustments) via Web Services. While reviewing the entity, I noticed the following warning on certain fields:"Do not include fields of this object in a request that retrieves a list of entities. To retrieve those fields, request entities one by one by specifying key fields."From my understanding, this means that some fields (such as detail-level fields like Taxes or similar sub-objects) cannot be retrieved using a standard list request and instead require querying each record individually using its key fields. I would like to ask:Is there any supported way to retrieve these fields in a single list request (e.g., via $expand, endpoint configuration, or other approaches)? Are there any recommended alternatives to avoid multiple per-record API calls, especially for large datasets? Would using a Generic Inquiry (GI) or custom endpoint be the only viable workarou

I'm building an integration that creates Sales Orders and Drop-Ship Purchase Orders via the Acumatica REST API (endpoint version 24.200.001 / a custom endpoint based on it). Once the SO and PO are created, the integration then links the PO and SO line via the API. Everything works correctly when the PO vendor matches the item's default vendor in Acumatica, but fails when using a non-default vendor.What works: After creating the SO and Drop-Ship PO, I release the SO from Hold, then send: PUT /SalesOrder?$expand=Details,Details/PurchasingDetails{ "OrderType": { "value": "SO" }, "OrderNbr": { "value": "SO-000123" }, "Details": [{ "id": "<soLineId>", "PurchasingDetails": [{ "POOrderType": { "value": "Drop-Ship" }, "POOrderNbr": { "value": "PO-000456" }, "POOrderLineNbr": { "value": 1 }, "Selected": { "value": true } }] }]}When the PO vendor is the item's default vendor, SOLineSplit records are auto-created by Acumatica when the PO is sav

Hello, I am trying to extend my endpoint to include the AttributeValue0 data fiend in the MatrixInventoryItem data class. I am doing this to try to pull the default column attribute value for the matrix item. However, Acumatica says that the endpoint is not mapped correctly. How would I correct this, or alternatively, is there a workaround for this? Thanks!

Hi,We are trying to filter a field in an Acumatica dashboard through the URL, but we do not see any possibility of achieving this. Could you please confirm if there is a way to accomplish this? Example: We have a custom dashboard called Production Status with a parameter Work Center. Through the URL, we would like to filter the dashboard to show only WC100. Is there a supported method to apply such parameter-based filtering via URL? Thanks

    Hello， happy 2026.  I noticed that Acumatica officially released AI Studio with their 2025 R2 version, but it's not a true AI agent yet—it can't create detailed order information. I'm wondering if anyone has used AI agents (like Manus and similar ones) to operate Acumatica. How was the experience? Could you share your feedback?

Best approach for integration — Web Service Endpoints (Generic Inquiry) vs OData?Hi all,I'd like some advice on the best way to build an integration with Acumatica. What's the recommended approach — going through standard Web Service Endpoints (via Generic Inquiry or standart endpoint) or using OData?What I need to retrieve:Account balances as of a given date Transactions (including base currency) for a specific period Currency exchange rates for a specific periodWhat I've tried so far:I created several Generic Inquiries and exposed them through a Web Service Endpoint.When I tested it by pulling transactions(via standart JournalTransaction)  for a single month (to get the line details I had to pass $expand), execution time was around 14–60 seconds. Our demo instance originally had 16 GB of RAM; after bumping it up to 64 GB, performance improved to around 5–15 seconds — but that's still pretty slow for demo ~155 transaction per month.2019-01 [2019-01-01 -> 2019-02-01]: 359 transactio

Hi everyone,I'm new to Acumatica and currently working on integrating Certificate of Analysis (COA) data. However, I'm having trouble finding any custom endpoints or relevant screens that store or manage this data.I've searched through the default APIs and screens, but nothing related to COA has come up. I wanted to check if anyone here has worked with COA data in Acumatica before.Does Acumatica have a built-in module or screen where COA data is typically stored?Any guidance or best practices for handling COA data in Acumatica would be greatly appreciated.Thanks in advance for your help!

Is there an existing integration with either Ceridian or Payworks, both for Canadian PR processing. 

I have created Generic Inquiry AccountBalances.Created date parameter Dateadded conditionenabled odata i see that url in $metadata. Without param that odata endpoint works fine. Found documentation that explained how to set paramhttps://help-2025r1.acumatica.com/(W(14))/Wiki/ShowWiki.aspx?pageid=7990b4d9-1f40-4654-9494-7b2f6abfd023 But when I trying to fetch data via postman/Acumatica/odata/SomeCompany/AccountBalances_WithParameters(Date=2025-01-01)?$format=jsonor /Acumatica/odata/SomeCompany/AccountBalances_WithParameters(Date=@p1)?$format=json&p1=2025-01-01 it returns 404 How I can correctly pass that Date param ?

This is more of a discussion topic than a question… I’m considering a customization that uses the REST API internally to access data stored in Acumatica.  I know that this isn’t the recommended API. I should be using the Platform API, but there is a good chance that what is being developped will eventualy move outside of Acumatica as a standalone application that talks to Acumatica.What are your thoughts on this?

Hello, I created a custom quoting software in Python for the machine shop I work for.  It auto generates a routing with set-up time, run units, and run time. As well as what material to use based on user inputs. previously we have just ran this software then just copied it over into Acumatica, so Acumatica gives a unit price.   I am trying to get this info to be pushed to Acumatica via the rest API.  I have successfully been able to put/patch the info from my software to Acumatica.  The one tricky thing I have been having problems with is Acumatica calculating everything incorrectly.  Resulting in me editing the times and reverting it back to get Acumatica to give me the correct costs. For Example:image (8) shows the data fresh from my calculator in Acumatica.  You can see it is not calculating fixed labor costs at all.  2: the variable labor cost is off..   some operations have no run time but still show a variable labor cost.  The material cost is also off.  when I go into estimate o

I am currently working with an Acumatica demo instance and planning to integrate with it via the API (Web service endpoints). Could you please provide information on the following:1. API rate limit — what is the maximum number of API calls permitted per minute?2. Concurrent calls — how many parallel API calls can be made by the same user at the same time?3. Transaction limit — is there a monthly cap on the number of transactions that can be created in the demo instance?Thank you in advance for your assistance.