Develop Integrations with Web Services | APIs

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

URL: https://esquared.acumatica.com/entity/Default/22.200.001Payload:{    "CustomerID": {        "value": "T99999"    },    "custom": {        "baccount": {            "AttributeCWCID": {                "value": "Sample123"            }        }    }} I’m getting 200 response but the AttributeCWCID is not updating

When we create a new check for a bill  i found that FinePeriodId error.How To fix It.I have already passed the FinePeriodId property In checkRequest 

I am trying to use the endpoint to update an employee Payment instructions & getting this exception for the records LocalizedMessage, Message, MessageNoNumber, MessageNoPrefix. The exception is trigerred after the PXWait.LongOperation tried to check PXAction. I have checked the locales table & it has data.  

Hello everyone, hope you all good.How can I include a button on a web service Endpoint?i.e.I need to add this button to web service endpoint. Endpoint:  Will really appreciate for any kind of responseThank you.

Good day,I’m trying to create a Normal PO which has lines that are linked to a Blanket PO via the REST API. The request I’m sending through is successful, however the line item in the Normal PO is not linked to the Blanket PO as expected. When using the UI to link the Blanket PO Line, all works as expected.From my understanding, we would need to pass through the OrigPONbr & OrigPOType fields, which should link them to the blanket PO, am I perhaps missing something else?API Request & Response:{ "Type": { "value": "Normal" }, "Branch": { "value": "FTNHQ" }, "Date": { "value": "2023-03-08T00:00:00+02:00" }, "Hold": { "value": true }, "Owner": { "value": "FTNHQ-1009" }, "PromisedOn": { "value": "2023-03-15T00:00:00+02:00" }, "VendorID": { "value": "10079" }, "Description": { "value": "Test Blanket PO Creation" }, "Details": [ { "BranchID": { "v

Hi guys,I am currently developing an integration to pull data from Acumatica ERP. I am trying to implement an OAuth 2.0 flow using the Authorization Code Flow.From reading through the resources, I have gotten this flow to work for my local Acumatica ERP instance. However, I am struggling to understand how to expand this to other Acumatica ERP instances, such as those used by our clients.I understand that a key part of the OAuth flow is creating a record in the Connected Applications form, and being issued a Client ID and a secret. I’ve seen that I can export this Connected Applications form as part of a Customization Project, but when I import this Customization Project in another Acumatica ERP instance, it loses the record in the Connected Applications form. I suspect this may have to do with the tenant name being different in the other instance, but I am unsure how to get around this.Even if I do get this Customization Project approach to work, it doesn’t seem logical to me to have e

How to call a check delete action endpoint through rest api​​

Hi, what is the last Acumatica endpoint version ?For  Acumatica 2022R2 it was 22.200.001What endpoint for 2023R1 ?

hello folks so i have a service which is supposed to create an InventoryIssue using IN302000, with the help of an API call on a custom endpoint:I didn’t find an existing Contract , so I created an custom one named InventoryIssue, quite similar to InventoryReceipt.different actions and details:And I tried this PUT call in Postman:put inventoryIssue request: The response is what I expected, with a ReferenceNbrbut when I try the POST for ReleasingFromHold with this ReferenceNbr as parameter, it does not remove the hold of that specific ReferenceNbr, rather it creates a new Issue,POST req with the ReferenceNbr, response is 204.this is what the necessary actions look like  I have been following the integration development guide till now to create the different entities and details. So if anyone can help me figure out why me calling the ReleaseFromHold does not removes hold from the previous PUT request, but rather create a new InventoryIssue?

Dears, Kindly need your helpCould I remove (id, rownumber and note  ) from response? How?Could I return InventoryId:Ac316 direct not like object? How? 

Hello everyone, I am trying to add allocations through the REST API but I am having problems adding the Source and Destination Accounts. I was trying to extend the endpoint but I couldn’t find an object for these two.Has anyone done this before and can show me the setup of the endpoint? Regards,Nick

Which end point can be used to add a new inventory transfer for the screen IN304000 through the Web-API.