Develop Integrations with Web Services | APIs

 I will return this purchease receipt

Hello Team,I am not able to access GI data in JSON format in 25R2 by odata using postman by using following URL format, it was working in 24R2{Acumatica instance}/OData/{Tenant}/{GI title}?$format=jsonPlease help me

I am working with a dev team and they are connecting a website to Acumatica.  We are trying to get to the Related Items data on a Stock Items.I created a new endpoint named RelatedItems.  I have created other endpoints this way and they have worked, but the dev team is reporting this one is not working.  What is different about this one? Testing this in Postman generates an error.   I also had the dev team try the web service on the screenI created a new endpoint named RelatedItems.  I have created other endpoints this way and they have worked, but the dev team is reporting this one is not working.  What is different about this one?Web Service for RelatedItems  Fields that are available for RelatedItems The web service attached to the Related Items screen also generates an error when called.This is from the Web Services Link on the Acumatica Related Items screen 

client want to show live stream in custom screen

Good afternoon, I’m looking to see if anyone has had any experience with setting up an integration with Alteryx, and if there were any unexpected hurdles or tips needed to make them work. We’re currently looking at just establishing a generic ODBC connection to capture data, which should be pretty straight forward.

Could I get some details on how and who to contact for EDI development for our customer. They have specific Vendors that require EDI, and we need to set it up for them. Thank you in advance! - Johanna

The Sales Order screen has an option to “Recalculate Prices”, which displays a dialog box containing several options including “Set Current Unit Prices”. I’d like to invoke this functionality using the REST API. I’ve discovered the /SalesOrder/AutoRecalculateDiscounts API action, which seems to be the correct endpoint. However, I’m not sure how to pass a parameter indicating that ‘current unit prices’ should be set.A payload like this does not cause the unit prices to be updated: POST /entity/Default/22.200.001/SalesOrder/AutoRecalculateDiscounts HTTP/1.1{    "entity" :    {        "OrderType" : {"value" : "SO"},        "OrderNbr" : {"value" : "002215"}    },    "parameters": { }}(EDIT: I’ll note that “DisableAutomaticDiscountCalculation” is set to false for the SO in question.)What’s the correct parameter to supply this endpoint for unit prices to be updated? The swagger.json file doesn’t appear to contain any information about parameters for this action. Any assistance is appreciated

Hi. Currently, I’m having some issues by expanding the following item of the endpoint (in order to retrieve the Email of a Contact related to a Project’s Address): The Tab, DAC, View and wanted field to retrieve in the endpoint (Project - PM301000)The wanted field to retrieve in endpoint, mappedThe error I got by trying to retrieve the field I would like to add, that the the View (Billing Contact) does not have any ContactID field to map, and also fails the endpoint even if I add it manually (and Validate the entity, which is valid, yet the error persists)The currently available fields in Billing_Contact viewDo any of you have some ideas of how to solve this topic?

We are using the “entity/Manufacturing/23.200.001/MoveEntry/ReleaseMoveEntry” REST API Endpoint to release the move entry at the end of the process.  We get a 202 Accepted response even when the release was unsuccessful.  A couple of reasons for the release being unsuccessful is duplicate serial numbers being received and backflush not being setup properly in the BOM.  In both of these scenarios, we still receive the 202 Accepted response with no body.  How can we “trap” these errors so we can report them to users to make the corrections?  Is there a different API call to use?  Any thoughts would be appreciated.Thank you in advance.

As far as I know, Acumatica only allows you to PUT one entity at a time. Is there any way to do a bulk upload of entites (eg. Stock Items, Journal Transactions etc)?If it’s not possible to do it within Acumatica, can it be done with a custom API or a wrapper and what would that look like?

Hello,We are using the Acumatica native BigCommerce connector, and we’ve noticed that several sales orders created directly in Acumatica have been pushed to our BigCommerce portal, creating corresponding sales records there.We want to stop this, meaning that no sales orders created in Acumatica should be exported to BigCommerce. BigCommerce should only receive orders that originate from the website.Is the sync direction the cause of this issue, since it is currently set to bidirectional?If so, why are only some Acumatica-created sales orders being exported to BigCommerce, and not all of them? We have screenshots of the import and export mappings available for review. 

Inserting 'AR Invoice/Memo' record raised at least one error. Please review the errors. Error: 'Exchange Rate' cannot be empty.

Some of our items are defaulted to ‘Mark for Production’ and ‘Made to Order’.  When I manually create a sales order and add an item to it, the check box for “Mark for Production” is checked.  But when I create the order via the API, it does not mark the line item for production by default.  How can I set this correctly for each line item when creating a sales order with the API?

I am having trouble updating and adding allocations on a shipment detail.  For simple cases, everything is working fine.  I am building an integration to a warehouse system, so I am trying to update the shipment with details from the warehouse system about shipped quantities and packages.I have a detail line that is a kit, so it already has the 3 components connected to it for allocations.  If everything shipped in 1 package, then I can update those 3 allocations with the quantity shipped for each, no problem.  However, when a line like that is shipped in multiple packages, I need to expand the allocation entries to have 1 for each combination of SKU and package, with the quantity shipped in that specific package.When I attempt this, the response I get back has more allocation entries in it than what I sent in.  If originally there was 3 allocation entries, and I try to update those 3 and add 5 more (total of 8), I get back a response with 11 allocation entries and an error that “the q

We have a home brewed web app that handles some of our system's more unique and customized functions, and it needs to make various API calls, especially to the SalesOrder endpoint.We have a push notification setup to send a notice whenever a line changes on SOLine and that sends to the web app, which then makes an API call to grab order information to update the order in its system. For each call it logs in, does its thing, and logs out. We started getting the error "Sign-in limit exceeded LoginLimit:50", and at first couldn't figure out what was going on - we thought potentially we were getting so many calls that it was logging in 10 times in a row and hitting the user limit before the previous run had finished and queuing in more than 10 logins at once. Here is the flow:     Web app gets an 'OrderChanges' Push Notification from Acumatica (We have set this up so we can track various changes and then update the shipping message in our eCommerce platform). Because we need the full ord

I am reaching out regarding the API request for Bills in Acumatica. The current URL being used is:{{baseURL}}/AcumaticaERP/entity/DefaultAP/29.200.001/Bill?$count=true&$top=1&$skip=0&$filter=Type eq 'Credit Adj.'&$expand=DetailsWe noticed that the total count of records is not being returned in the response, even though $count=true has been added.

Anyone know why Landed cost is not showing up here or how i can update?

I recently started encountering this error when using the /Payment API endpoint to create new payments or sometimes the /Payment/Release action: Another process has added the 'ARRegister' record. Please try again. My requests haven’t changed, so I assume it’s something server-side. Can anyone point me in the right direction for tracking down where the problem is coming from? Thank you!

Web service endpoint: /entity/Default/22.200.001/SalesPricesInquiry?$expand=SalesPriceDetailsParams:{ "InventoryID": { "value": "SPCBSERVICE" }}Response is always the first record on the SalesPrices Inquiry and doesn’t filter for the record with the Inventory ID of ‘SPCBSERVICE’.However, when expanding the SalesPriceDetails, all 135 or so records are included.Also, the InventoryID of the record is blank. So it looks likeThere are no Inventory ID’s for any of the records so the API is returning the first created record Expanding the SalesPriceDetails of that record includes all of the Sales Price records.{ "id": "81a55625-3913-4ea8-9869-67da0acff742", "rowNumber": 1, "note": null, "EffectiveAsOf": { "value": "2025-08-08T00:00:00+00:00" }, "InventoryID": {}, "ItemClassID": {}, "PriceClass": {}, "PriceCode": {}, "PriceManager": {}, "PriceManagerIsMe": { "value": false }, "PriceType": { "value": "All Prices" },

I am having what seems to be a strange issue.We use push notifications to send product updates to an external sysem. For the most part this works well. My issue is on Stock Items.  We have various attributes on the stock item entity. When those values change, I need it to fire the push notification. It is firing, but the JSON data payload for the attrbute fields is null.   The catch is, if I make a change/update to one of the stock item fields (name, description)...it fires the same push notification. The attribute data is no longer null, it sends the correct information. My GI I subscribed to has the attributes defined in the results grid.  Any ideas on what this could be? This seems like a bug IMO. Here is what I get for the attribute updates. PreOrderDate and ReleaseDate are supposed to have date values, but you can see they are null when is triggered by a attribute change.  Again, if I update a field on the parent StockItem, this payload will contain the correct values.  Thoughts? 

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