Develop Integrations with Web Services | APIs

Have been trying to retrieve the data from the Details tab of the Sales Orders(SO301000) screen using the below link with GET request and have been getting the attached screenshot in the response. The requirement is to retrieve the data from the Details tab for all the Sales Orders. URL: /entity/Default/20.200.001/SalesOrderDetails?$expand=Details Kindly let me know how shall I get the list in the Response.Thank you in advance

Hello Everyone,Am trying to add Sales Order line item Image using the REST API.Tried like below but it's not working. (Checked with LineNbr and the InventoryID)[AcumaticaBaseUrl]/entity/Default/20.200.001/SalesOrder/[OrderType]/[OrderNbr]/[LineNbr]/files/[Desired filename in Acumatica] Referred the below links.acumatica - Add Files to Salesorder line item - Stack OverflowAttach Files with Rest API - Acumatica Developers Blog . .Can anyone please assist here?

Postman request: {{base_url}}/Invoice?$orderby=LastModifiedDateTime Orderby is not working. 

Hi I looked over the API documentation for the Accumatica API, but I could not find anything on clicking the AP Bill button for a purchase order. Can you please tell me how to do this.

Hello,I have a design question. I am trying to download/sync all of our invoice/invoice line item data to our front end eCommerce application so customers can view their invoices. At the moment, I have it working using the Rest API endpoint but its very slow and I keep hitting our license limits. I have been porting all my RestAPI calls to using oData on top of a GI. This is MUCH faster and has relieved the pressure on the API calls. The invoice sync is the last one I need to do. I am struggling to figure out how to “find” that data. I do have all the invoices downloaded via these entities.  I can’t figure out how to get the invoice line items. What entities should I query?For my sales order sync, I download all the sales orders, and then download all the line items. My sync process joins the data together in my eCommerce app DB. Its very fast. I am looking to do a similar approach here.I am open to tapping into the oData4 endpoint if that is a better option. Any help would be greatly

What would be the best approach to get real-time inventory updates to an external system. Right now I am using push notifications and subscribing to the the “In-InventoryBalance” GI. This gives me the SKU and Quantities across the various warehouses.My issue is that the payload for these notifications are often too large (ie: too many rows) and my destination is unable to accept the message (Azure Service Bus).The threshold is only occasionally reached...most of the time its OK. There are some instances where the outbound payload is too large. I thought maybe there is a more reliable method Any tips would be appreciated! Eric

Hi Everyone,     Hope you are doing well.    I am new to Acumatica. I have a few questions regarding the data validation, hoping someone can help me out on this.    When I tried to test creating / updating records through API service, I noticed a few issues. For instance:When creating an invoice with an invalid type value in the payload. The application doesn’t response with error message, like “the invoice type is wrong”. Instead, an invoice with bad data is created. See screenshot #1. Once it happened, all other request of updating / creating invoice will fail. When creating an invoice with invalid details. For instance, if I create an invoice record with two items in “Details”, The first item has an invalid inventory id, then the second item has the valid inventory id. Acumatica will accept with this request, then create an invoice. But the details in the created invoice, the first item will have empty value in the “Inventory ID” value. When updating a closed invoice through API. Ac

Hi, hoping someone can provide some guidance and clarity with an enhancement to our customization package.To generalize, We have a custom class Widget that we use to track the status of entities being processed in an outside system. The Widgets are stored in the DB have a Widget Maintenance screen, and we use the REST endpoint to work with Widgets as needed.To enhance performance, we would like to start batching requests to update Widgets. At present it seems the options are,a) Send a text string to an action or class and deserialize it into Widgets.b) Create a second DataSource that defines the Widget collection as a Details group so that Widgets are submitted in an array.c) Re-architect so that Widgets are always a details collection and never accessible as a top-level object.My gut is telling me that 'a' would violate best practices and that 'b' would as well for allowing deadlocks/collisions if the existing path were to update records at the same time as the batch process.So, would

Our integration creates order in Acumatica via APIs and we override and fill in the ship to address as part of the order creation process.  We get an error when we send the country name instead of country code.  For example if we use CANADA instead of CA, Acumatica will not accept it.   Our commerce system does not have country codes and all we have are the country names.  While we can create our own table lookups in the origin system, this shoudl not be required.   As a workaround we can use a GI and manage a custom endpoint but this shoudl also not be needed.The question is why is country table not available in the default end point so we can lookup country codes using full names or are we missing something?

We are passing work order time fields in api getting error:{  "OrderNbr": {    "value": "W-222231"  },  "Labor": [    {      "note": "",      "EmployeeID": {        "value": "1083"      },      "ActualStartTime": {        "value": "2022-10-17T18:00:00-04:00"      },      "ActualEndTime": {        "value": "2022-10-17T23:59:00-04:00"      },      "StartDate": {        "value": "2022-10-17T18:00:00-04:00"      }    }  ]} Error:WorkOrder.Labor[0].ActualEndTime: The times are invalid. The end time cannot be earlier than the start time.\nWorkOrder.Labor[0].ActualStartTime: The start time cannot be later than the end time. Correct the values.\nWorkOrder.Labor[0].StartDate: The start time cannot be later than the end time. Correct the values. Can anyone know what wrong with this?

I am creating an integration with Acumatica and I would like to give the user an option on which of their companies they would like to connect.However, when I query any data endpoint (such as a list of ledgers or journals), I receive the information for all the companies that belong to that user. This means it was irrelevant for the user to select which companies they wanted to connect.Is there a query param that I can pass to the endpoints that will return only the data for the company I specify? I have not been able to find such a thing in the documentation. If not, what is the best approach for getting around this?Any advice would be appreciated.

Hi, thanks for any help - rather new to integrating against the Acumatica API and to date have done so only against existing endpoint to create, retrieve and update invoice line details.  This is a first attempt to use a Generic Inquiry and expand the web service endpoint.I have followed the same steps outlined in Accessing Data in Generic Inquiries using Contract Based API’s - Acumatica Cloud ERP to expand the Rest API endpoint with a generic inquiry that provides employee leave balance.The inquiry has no required parameters so simply have {} in the body.The API PUT call fails with  "exceptionMessage": " The given key was not present in the dictionary."I am not very sure where to start to address the error.Note the inquiry uses payroll related and other tables that are not exposed anywhere else in the rest api - if any fields listed in the inquiry mean extending further the web service endpoint to add the objects, please help explain how to know what to add.Please see the screen captu

Good day,I used this import scenarios a number of time.  Now I am getting the below message.  I can’t seem to figure out what the problem is now.  Attached is the HTML.   Any suggestions?  Need help.  Operations needs these orders upload ASAP.Thank you@Naveen Boga  Your help is always spot on. =The system failed to commit the shipmentlist row. Field: Unit Price, Value: 0, Warning: Unit price has been set to zero because no effective unit price was found.

Hello everyone! I have a custom field on Shipments Screen telling me the status of the order in a different system, the code is given below:declaring UsrRWSStatusthe shipments screen for a visual representationNow I have a service which will update its status to Pick Created , with the following request:POSTMAN PUT requestBut I get this error in response,"String or binary data would be truncated in table 'AcumaticaDB.dbo.SOShipment', column 'UsrRWSStatus'. Truncated value: 'P'.\r\nThe statement has been terminated.", this as the exception message, I am confused here, am I sending the request correctly, or do I have to change something else in my customization of the DAC? If any more context is required please let me know. Cheers,Jdeol

Hi All,When we try to fetch the date and time through an endpoint, we always receive the UTC time. We have attempted to send the date and time as a string format, but we are still receiving the time in UTC.How can we retrieve the Eastern Standard Time (EST) in the response? 

Help! We are updating to 2022 R2 and therefore will no longer be able to use the imbedded Acumatica shipping integration with WorldShip. We have created an EasyPost account, followed the steps in the EasyPost configuration guide and still have unresolved questions / issues which our VAR is struggling to get answered from Acumatica.Has anyone made the transition from the Acumatica Smart Shipment integration with UPS WorldShip to the EasyPost integration? Below are our questions and the partial answers which we have received.“End of Day”: WorldShip includes an “End of Day” function which created a consolidated scan ticket for the driver, a Daily Shipment Detail Report and triggered the emails from UPS with the tracking numbers.Will WorldShip show the shipments which are confirmed in the EasyPost integration? (If so we would then be able to do End of Day in WorldShip and the three functions above would be completed.) If we can’t do End of Day in WorldShip then how do we get a consolidated

Please help me out from this exception Message. I don’t understand why this happen.All API working fine, but in some API occurred a error.Please suggest me a solution for this issue.

Hi,I’m trying to add inventory allocations to a shipment order, but I’m getting an error. I’m able to create a Shipment without including the Details and Allocations entities, but when I include them I get an error. I’m trying to follow the steps here.The following JSON results in a successful call: But this JSON doesn’t: Is there something that I’m missing that’s preventing me from creating the Allocations?

Hi,My application generates REST request which is used for creating BillsThis is my request for creating BillURL : https://mcicj.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/BillBody :{  "VendorRef": {    "value": "1ABL-217i941"  },  "DueDate": {    "value": "3/2/2023"  },  "Vendor": {    "value": "V-06702"  },  "Date": {    "value": "1/31/2023"  },  "Terms": {    "value": "PWP"  },  "PostPeriod": {    "value": "01-2023"  },  "Details": [    {      "Description": {        "value": "Line 001 - Gypcrete"      },      "Qty": {        "value": 1      },      "UnitCost": {        "value": "34573.2"      },      "ExtendedCost": {        "value": "34573.2"      },      "Account": {        "value": "5430"      },      "SubcontractLine": {        "value": "1"      },      "SubcontractNbr": {        "value": "234567"      },      "rowNumber": {        "value": "1"      }This request is fully workable.Bill is successfully created, however these 2 fields are missedI can add them only via “

Hi,I am using such request for creating Bills{  "VendorRef": {    "value": "2134"  },   "Hold": {        "value": false    },  "DueDate": {    "value": "3/2/2023"  },  "Vendor": {    "value": "V-02366"  },  "Date": {    "value": "1/31/2023"  },  "Terms": {    "value": "N30"  }}Console shows that request is successful and it’s status is “Balanced”However in Acumatica it is in “Closed” stateI tried lots of vendors, lots of another combinations, but result remains the sameWhat I should check ?Kindest regards

Hi,My application generates REST request which is used for creating BillsThis is my request for creating BillURL : https://mcicj.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/BillBody :{  "VendorRef": {    "value": "1ABL-217i941"  },  "DueDate": {    "value": "3/2/2023"  },  "Vendor": {    "value": "V-06702"  },  "Date": {    "value": "1/31/2023"  },  "Terms": {    "value": "PWP"  },  "PostPeriod": {    "value": "01-2023"  },  "Details": [    {      "Description": {        "value": "Line 001 - Gypcrete"      },      "Qty": {        "value": 1      },      "UnitCost": {        "value": "34573.2"      },      "ExtendedCost": {        "value": "34573.2"      },      "Account": {        "value": "5430"      },      "SubcontractLine": {        "value": "1"      },      "SubcontractNbr": {        "value": "234567"      },      "rowNumber": {        "value": "1"      }This request is fully workable.Bill is successfully created, however these 2 fields are missedI can add them only via “

Hi,Previously, I had experience with default actions for Bill that are depicted at screenFor using them it was enough to send such request Our client is using custom entity named SubcontractsI need to send new fields from this entity to Bill, these fields are SubcontractNbr and SubcontractLineClient’s Acumatica already contains such actions for this entityI assume that I need to use addSubContractLines action as I need to add these fields to Bill’s columns in DetailsHowever this action does not contain any parametersMy question is : how to use action for adding these custom fields : SubcontractNbr and SubcontractLine to Bill and how to form such request ?This is my request for creating BillURL : https://mcicj.acumatica.com/entity/ARTSDocAlphaEndpoint/20.200.001/BillBody :{  "VendorRef": {    "value": "1ABL-217i941"  },  "DueDate": {    "value": "3/2/2023"  },  "Vendor": {    "value": "V-06702"  },  "Date": {    "value": "1/31/2023"  },  "Terms": {    "value": "PWP"  },  "PostPeriod": {

Hey All,I have been working with the following API’s to look for LotSerial# and expiration of products to no availI’ve added Lot/Serial Nbr. as a returned field to:StorageDetailsInquiry.StorageDetailsStorageDetailsByLocationInquiry.StorageDetailByLocationAnd all seem to return "LotSerialNumber": {},Despite being present in  InventoryAllocationInquiry.Results.LotSerialNumber.Any tips for requesting this information?Chris

Hello All!I was looking to collect the content from page IN615000 via a REST Api call.In the past, i had extended the webservice endpoints list to make a new route, and add the screen ID of choice to collect the information typically returned there.This time however, when clicking “Okay” to produce the route - I get the error : Error: The view  doesn't exist.Has anyone else successfully asked for the data on this page?Cheers, Chris