Develop Integrations with Web Services | APIs

Perhaps this information will help someone with a similar issue. The issue stemmed from an inability to create a sales invoice via the Acumatica REST API, resulting in the persistent error: "Taxes cannot be calculated via the external tax provider because the address is missing." Initial Problem The user was unable to create an AR Invoice using a single POST request, even with a minimal header-only payload that included the CustomerID, CustomerLocationID, and Hold: true. Cause of the Error: The active Avalara (External Tax Provider) integration was configured to perform strict address validation on the initial POST request for new documents. API Limitation: Acumatica's internal data-defaulting logic failed to populate the required Origin Address (from the Branch) and Destination Address (from the Customer) fast enough (or correctly) before the strict Avalara validation check ran, causing the API call to fail every time.  Eventual Resolution The root cause was identified as a missing

Has anyone integrated ACU billing to SAP Ariba?

Hey Looking for any insight on this, I am currently trying to Prepare the Data for integration on the Import by Scenario screen of about 40,000 entries, but whenever I prepare the data before import I receive an error as it is processing. The Error is “Ticks must be between DateTime.MinValue.Ticks and DateTime.MaxValue.Ticks. Parameter name: ticks” Thanks! 

Hello Support Team,I’m working on a Generic Inquiry named “DB-StorageDetails” (Screen ID: IN408050) and trying to rename the column currently showing as “Site Last Modified Date” to “LastModifiedDateofWarehouseQty.”However, when I attempt to rename it, I receive the following error:“A field with the name LastModifiedDateofWarehouseQty cannot be found.”Additionally, the Caption / Display Name field does not appear anywhere in the column editor. The column is based on the field INSiteStatus.LastModifiedDateTime (and may be part of a calculated field), so I’m unable to edit its visible label.Could you please advise how to properly rename this column in the Generic Inquiry results grid or through customization?If this limitation exists for calculated or expression-based fields, please confirm whether it can be done via the Alias property or through a customization project.Thank you,Namrata  

Does anyone know how to get past the below? I had a customization, removed it and tried another feature I wanted to add but am getting the error below. I am unsure where to navigate to find the problem to correct it. Thanks   

Is there any way to call the PrintInvoice action on an SO Invoice and specify the printer to get a paper copy?  I’ve made an entry in our custom endpoint to call the PrintInvoice action on an invoice, but when I submit the PUT, I’m getting an error “Invalid URI structure”.I’m supplying this JSON in the body of the call:{ "entity": { "DocType":{"value":"Invoice"}, "ReferenceNbr":{"value":"AR006006"} }, "parameters":null}Any ideas on how to accomplish this?

Hi all, I update Project task Status completion from our builder software. Sometime the Project number gets entered incorrectly into that app.  Whe I run a put to the ProjectTask endpoint and the project does not exist it give a 500 error with "exceptionMessage": "Object reference not set to an instance of an object."I am logging these, but it is not a very friendly message. I do not want to hit the API first to see if the project exisits. We are going to automate the Project creation so they are all in Sync, but not till next year. My questions is how are you dealing with this type of issue?  My concern is the generic Error my not always mean the project does not exists.

Hi Community,I’ve been working on resolving the Outlook Add-in issue related to the February 17, 2025 change (legacy authentication tokens being turned off). I have carefully followed all the steps outlined in the knowledge base and community posts, including: How to resolve the issue when users are unable to sign in to Acumatica Add-In for New Outlook on Windows Known issue: Starting 17th February, 2025, Acumatica Outlook Add-in may stop working Steps I’ve already completed: Upgraded Acumatica instance to the correct supported build. Enabled OpenID Connect in Acumatica. Registered the application in Microsoft Entra with redirect URI, API scopes, and permissions. Created the OpenID Provider in Acumatica with the correct Tenant ID, Client ID, and Client Secret. Installed the new Outlook Add-in using the updated manifest. Problem: Despite all of this, the add-in still does not work. I either get [describe your exact error: blank screen, token error, redirect loop, etc.].Questio

I would like to manually assign a Production Order ID to a specific line item on a sales order.  Can I do this via the API?  If so, how?  The SalesOrder endpoint does not seem to have these fields available.Thanks!

Hello team,Shopify customers are linked to the primary contact in Acumatica, and I think I need a customization to change that link to the general contacts in the customer profile instead. Our goal is to be able to link multiple contacts as customers for the same account. Currently, we are limited to one.  Under the entity mapping tool, I do not have the contacts section as an option to map to.Kindly share your suggestions on this.

Hi ,I have set up Google Workspace for email in Acumatica. I’m required to log in several times a day, otherwise emails sharing getting failed. I noticed that there is an expiry set on the Authentication token under the external applications. How can I extend this expiration or set this not to expire?Thank You,Dulanjana

Yesterday, we had severe performance issues due to multiple running processes on a single user (import orders) that didn’t stop until we manually killed the processes:Here’s the task that I want to implement on processes that have run longer than a minute or two:Is there anything I can call in the RESTAPI to achieve this? Thanks,Brian

I’m looking to create a custom webservices endpoint that will take in a request with a custom format, extract Ids from some of the objects in the request, retrieve data on stock items and some related tables based on the Ids provided then put that data into a specific json format to return it.Is this possible and how would I go about doing this?

I’m experiencing a performance issue with the OData endpoint in Acumatica. After an app pool recycle or idle period, the very first call to an OData resource takes a noticeably long time, then subsequent calls are much faster. I wanted to post here to check if this is expected behaviour, and gather tips on how to reduce this delayEnvironment:Acumatica version: Build 25.101.0153IIS app pool: default settingsDatabase on same server/SQL Server 2019No customizations affecting INLocation OData endpoint (basic table, exposed via DAC)ExampleGET http://<server>/AcumaticaERP/t/Company/api/odata/dac/INLocation?$select=LocationID,SiteID,LocationCD,DescrFirst call in postman: And second call: Is it expected that the first OData call after idle is significantly slower?Are there recommended best practices (warm-up scripts, Application Initialization in IIS, etc) specifically for the OData endpoint?

Using C# and the RESTClient, is there a way to get the common tasks from the system? I see that common tasks are PMTask DAC objects without a project reference.I have a generic method to get objects from Acumatica: public ServiceResult<T> GetList<T>(string filter = "") where T : class, ITopLevelEntity, new() {     return ExecuteWithClient(client =>     {         var results = client.GetList<T>(null, null, filter);         return new ServiceResult<T>         {             Success = true,             Results = results.ToList()         };     }); }Is there a way to pass a filter which would return the Common Tasks from screen PM2083PL?Any suggestions would be greatly appreciated.Mike

I am trying to create a data view and widget to show management all AP bills that have gone into the system for employee expenses filtered by date and to show them GL expenses accounts on it. 

I set up a Powershell script to load images to customer accounts from a folder.  This is a process that will happen once per year.  I would prefer to replace the file with the same name rather than create a new version of the file on subsequent uploads, but Acumatica does not support replacement via the PUT command.  I added a delete operation for each file beforehand, but the operation always fails with a 500 internal server error.  I have the Admin role, but I believe the failure is security related based on the message “Operation is not valid due to the current state of the object” from testing the same operation in Postman and after reviewing the Access Rights tab under File Maintenance. Whether I upload a file via the Customer screen or via the REST API, file maintenance shows ‘View only’ as the access right, but I can delete the file via the screen from the customer account without any issues.  Where would the “View only” right be inherited from and why does it seemingly only app

Hi,I need to implement the following logic:Is it possible to block the Approve operation for a certain period of time?We need to allow our client to complete all actions with the Bill before it can be approved.For example, if the Bill contains 2 rows in the table and the client wants to add 3 more detail rows, is it possible to temporarily lock the Approve operation until the client finishes?If yes, how can this be achieved? 

Hi,I need to clarify how to find out which endpoint version corresponds to Acumatica 2025R2 version ?Is it 24.200.001 ?

I’m calling this RESTAPI URL: Shipment/ConfirmShipmentUsing a body:{"entity":{"Type":{"value":"Shipment"},"ShipmentNbr":{"value":"SH00788384"}},"parameters":{}} Question: how long do I need to wait between calls to this URL? I get an empty response back when successful but if I don’t wait at least 5 seconds before I call the next Shipment/ConfirmShipment RESTAPI URL, I get this response:{"message":"An error has occurred.","exceptionMessage":"Operation failed","exceptionType":"PX.Data.PXInvalidOperationException","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.Controlle

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 

Hi there, We are considering using Smarty Address Verification via API. Has anyone here had success with this integration? It would be very helpful to know if someone out there has already made this work and, if so, whether they are happy with it or not.  Thank you!Jon Hunsicker

My requirement is straightforward: I want to retrieve stock items via OData and only pull the delta records based on the Last Modified Date. However, I’ve encountered a couple of challenges.Problem 1: Time Zone InconsistencyWhen I use the old URL format: /odata/Company/MyGI?$format=json&$filter=ItemLastModifiedDateTime ge datetime'2025-09-25T18:50:05.977' Both the query filter and the response use UTC time zone - which is OK However, when I switch to the new URL format: /t/Company/api/odata/gi/MyGI?$filter=ItemLastModifiedDateTime gt 2020-09-25T12:10:41.837Z The query is executed using UTC (probably due to the Z suffix). The response, strangely, is returned in PT (Pacific Time). ➡️ I need both the query and the response to use the same time zone format with the new endpoint. Is there a way to enforce this? Problem 2: Millisecond Precision in FilteringWhen filtering by LastModifiedDateTime, millisecond precision doesn’t seem to work as expected.For example: My data has: "LastMod

Since we recently moved to an in-house database for Acumatica, creating Sales Orders using the RESTAPI is working correctly only 85% of time (instead of 100% of the time when the database was server-based).  Now the address and contact info are missing sometimes.  I am saving the JSON request and response which basically tells me that the override was nulled out even though the contact/addresses were submitted.Question: is this a bug in the REST API?  Is it being looked at?Here’s my JSON request:{"OrderType":{"value":"EB"},"OrderNbr":{"value":"\u003CNEW\u003E"},"CustomerID":{"value":"C10010471824"},"Description":{"value":""},"CustomerOrder":{"value":"666605896426-10073114154208"},"ExternalRef":{"value":"220297"},"PaymentMethod":null,"CashAccount":null,"FinancialSettings":{"OverrideTaxZone":{"value":true},"CustomerTaxZone":{"value":"CHANNEL"},"InvoiceNbr":{"value":""}},"BillToContactOverride":{"value":true},"BillToContact":{"Attention":{"value":"Test"},"Email":{"value":"test421@gmail.co

We’re integrating with a multi-tenant Acumatica (MYOB Advanced) instance. There are two companies (CompanyOne and CompanyTwo). For each tenant, I created a separate Connected App with its own client ID and secret.Setup: Using OAuth Authorization Code flow Generating an access_token for each tenant’s Connected App Using that token to call the REST API Issue: REST API calls sometimes return data from the wrong tenant. For example, calling with CompanyOne’s token occasionally still returns data from CompanyTwo. Behavior is inconsistent: if both tokens have expired and I refresh them, tenant separation works correctly for a while, but later the API “sticks” to CompanyTwo again.