Develop Integrations with Web Services | APIs

https://{myendpoint}.acumatica.com/entity/{myentity}/v1/SalesOrder/CreatePurchaseOrderI am attempting to invoke the webservice endpoint here (created by me): I have created another request where the mapped action is the createPurchaseOrder@replenishment to attempt that as well: I want to simulate the conditions of this buttonhere is the postman request (screenshot 3)I am unable to find anything anywhere to understand what parameters may be required, and the reponse is downright confusing.The error returns this-     "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "Purchase Order '{0}' created.",The ambition is to process the order below, but i have zero feedback from the api’s themselves on missing required parameters or other oversights.Any assistance would be appreciated,Chris

When I go to https://xx-xx.acumatica.com/ODatav4/myCompany/PX_OBJECTS_IN_INSETUP I get the error You don't have the user rights to view this page. HTTP ERROR 403. I get the same error for table PX_OBJECTS_CR_BACCOUNT. I don’t have any trouble with the other CR tables like contact, location, or the IN tables like INSITE, or INITEMCOST. I do have CR and IN viewer roles enabled for the user. Do these tables have a relation or something to a table I don’t have access to.So where else do I need to grant access? Also, is there a location in Acumatica to see what roles the tables are bound to? Thanks! 

I am investigating different integration options and wondering if others have utilized Azure Data Factory as their ETL tool or have any insight into this tool.

I was able to implement a custom screen with an action button that when clicked, it open an external url which is basically a UI which works with the acumatica RestApi and perform specific actions and AI analysis on it. It working perfectly. But I want to try something else, to reduce the delay - in fact the user has to click on the button to open the web application inside acumatica frame. I want to execute 2 actions:   when I open the custom screen it automatically loads trigger the URL redirection and load the web application.  to pass the user role in the query : “http://webapplication.com?role=’role of the user’ 

Hi Community,I am trying to add One Line item in Appointment Details tab having Line type as "Non-Stock Item" through Acumatica.RESTApi using PutEntityAync from C#. But when I try to insert any value for ActualQty field I am getting an error as "exceptionMessage": "An error occurred during processing of the field Qty: Specified cast is not valid.." But the datatype of that field is decimal and I am trying to insert same as Decimal.If I keep ActualQty as Null then the remaining fields are inserting as expected.And while updating any Non-Stock Item if I give ActualQty any input then I am getting same error.Here if I keep ActualQty as Null then I am getting "exceptionMessage": "Nullable object must have a value". But If I remove ActualQty filed from the request, then the update is working fine.Remaining Decimal type fields are updating but facing this issue with ActualQty.Also while adding a new line in details, I’m unable to insert AcutalQty thorugh Postman or API PUT call.If I pass Actu

'{"error":{"code":400,"details":[{"@type":"type.googleapis.com/google.rpc.ErrorInfo","metadata":{"action_name":"CreateAttachment","cause":"Invalid input for attribute Content to operation CreateAttachment.rsb, only InputStream is allowed.","connection_type":"Acumatica"}}],"message":"Unable to execute the specified action.","status":"FAILED_PRECONDITION"}}' We have been trying to pass CreateAttachment action, but it displays the following error. What kind of InputStream shall we provide? Any Ideas?

Hi Everyone.Is it possible for me to add a second statement in Acumatica? The first statement type would be the open statements. The second would be the balance brought forward. The open balance statement would be the default. I would then want to be able to generate a second balance brought forward statement and send both to the customer.Any ideas on how I could set this up?

I want to create a custom button and call it using the postman. I tried it with the "CreatePayment" button. But it doesn't work  Is it possible to do this? 

Good day. We’re having a bit of a struggle determining the naming of entities in order to extract the relevant information via api calls. Example: We are trying to expand/extract the Ecommerce Data tab field “description”. Where exactly can we look to find the naming of this entity to expand? Will appreciate any guidance.Thank you     

I am trying to get the Purchase Receipts and Purchase Orders filter by Date using RestAPI in postman, please provide me some example.

Hi Everyone,I'm trying to override the currency rate on a payment via the REST API.I can do this no worries in the UI however I'm struggling to get the API to do it.I've attempted to extend the endpoint to add the CurrencyRate field however this isn't making a difference, the payment will still create however it will just use the regular exchange rate.Does anyone know how to get this working? 

Hi everyone,I recently set up a new instance in MYOB Advanced and extended a new endpoint specifically for managing Purchase Orders. I'm trying to complete a purchase order through this endpoint, but I keep encountering an error. I'm hoping someone might be able to shed some light on this issue.Endpoint and Request: I'm sending a POST request to:POST http://localhost/MyStoreInstance7/entity/Default/1.1/PurchaseOrders/CompleteProcessingCategoryWith the following JSON body:{  "entity": {    "OrderNbr": "PO001326"  }}Response: However, I'm receiving a 500 Internal Server Error with the following details:{    "message": "An error has occurred.",    "exceptionMessage": "Operation failed",    "exceptionType": "PX.Data.PXInvalidOperationException",    "stackTrace": "...",    "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "The Complete Order button is disabled.",        "exceptionType": "PX.Data.PXActionDisabledException",        "stackTrace": "..." 

Hi Forum, I recently created a Generic Inquiry and then Created an Entity on the Web Services panel extending the default endpoint. I followed the steps on this link: https://www.acumatica.com/blog/contract-based-apis-in-generic-inquiries/. The Guide works perfect, I could create the entity, I could retrieve the data using a Put method on Postman and everything seems fine, But, Now if I tried to filter the data using the information from one of the fields in the Results (The ProjectID). I can not filter the information. I tried to use the next query but it gives me the error shows in the image below: Query working:  Query not working:  My intention is not to just get the information in the Generic Inquiry, I can do that very easy with the Generic Inquiry directly, my end goal is to be able to update data on the Generic Inquiry. I want to update one field from the table I’m using in the Generic Inquiry. Please your help to know if I’m doing something wrong on my Query on Postman that I

Hello Community,I have been searching out for APIs related to Emails. Can anyone guide me out where can I find one? or any references.Thanks in advance.

I have a datetime field in Stock Item, this is the last time that I have exported the Stock Item Data to an external system.Is there a way that I can filter StockItem by comparing LastModified with the Exported date?Something like $filter=LastModified ge Exported. There are many examples using datetimeoffset buy in this case, the date to compare is in the stock item. 

I want to list the roles for a specific user. I have modified the webservice endpoints to include “Roles: ContactRoles” under Users.I am able to get the user information, but I am unable to get the Roles. I have tried the $expand in the URL. 1) Setup for endpoint.Acumatica Setup2) Call in POSTMANPostman Call 

HiAs mentioned in https://help.acumatica.com/(W(5))/Help?ScreenId=ShowWiki&pageid=c5e2f36a-0971-4b33-b127-3c3fe14106ffits possible to operate with odata uri conventions when querying entities (predefined or customized as well).however no odata metadata is available for all entities, which make it impossible to work with .Net OData clients packages, and require to build the HttpRequest parameters by myself.Am I correctly understand this, or there is a convenient way to do so ? (I do not want to define a GI for all entities I need)Thanks

Hi-I'm trying to add a PUT request to my payment screen (AR302000). However, when I test it using Postman, I encounter the following error, and I'm a bit stuck on where to find the issue and fix it. Here's the error message and the JSON data. If anyone could assist me in identifying what's wrong, I'd greatly appreciate it.Thanks a bunch!Error: JSON:{    "Type": {        "value": "PMT"    },    "ReferenceNbr": {        "value": "PAY0001"    },    "Status": {        "value": "Balanced"    },    "ApplicationDate": {        "value": "2023-12-28T00:00:00+00:00"    },    "PaymentRef": {        "value": "nugsl - INTEGRATED_ATM - 2023-12-28"    },    "CustomerID": {        "value": "C0001660"    },    "PaymentMethod": {        "value": "ATM"    },    "CashAccount": {        "value": "INTATMDSWC"    },    "Description": {        "value": "API Test."    },    "PaymentAmount": {        "value": 1400    },    "BranchID": {        "value": "01-DSWC"    },    "DocumentsToApply": [        {         

I am trying to insert a vendor record using the REST API. I am met with the following error message.    "error": "Inserting  'Vendor' record raised at least one error. Please review the errors.; DiscTakenAcctID: 'Cash Discount Account' cannot be empty.; DiscTakenSubID: 'Cash Discount Sub.' cannot be empty.; TaxUseVendorCurPrecision: The Use Currency Precision flag was set because the tax report precision is equal to the currency precision", The JSON I am sending looks like this.{         "note": {             "value": "Abhijit - Testing"         },         "Cash Discount Account":{"value":"5922"},         "Cash Discount Sub":{"value":null},         "AccountRef": {},         "APAccount": {             "value": "2000"         },         "APSubaccount": {             "value": "000"         },         "CashAccount": {},         "CurrencyID": {             "value": "USD"         },         "CurrencyRateType": {},         "EnableCurrencyOverride": {             "value": false         },    

I’m attempting to add a new Vendor via the REST API. I receive the error:DiscTakenAcctID: 'Cash Discount Account' cannot be emptyThis is a required field located under the GL Accounts tab. However, the field does not appear when getting the list of Vendors via the REST API. How should the JSON be structured to include this field when adding a new Vendor via the REST API?

We are exporting Bills into Acumatica from our application, and I have gotten that mostly working as expected.  A new requirement to pay bills electronically inside our system has come across my JIRA board, and I was wondering if anyone else had any experience posting a payment that has been made externally to Acumatica.  Would I just use the PaymentAPI?

Does anyone know of a way to use a single Rest API PUT request to both, create an SO, and allocate serialized items to the lines?I have a call structured like this:{ "CustomerID": {"value": "C000517"}, "Date": {"value": "2022-08-28T00:00:00"}, "Description": {"value": "Postman Test"}, "Details": [ { "DiscountAmount": {"value": 10.00}, "ExtendedPrice": {"value": 2000.00}, "FreeItem": {"value": false}, "InventoryID": {"value": "TestItem"}, "OrderQty": {"value": 1.00}, "UnitPrice": {"value": 2000.00}, "UOM": {"value": "EA"}, "WarehouseID": {"value": "MAIN"}, "Allocations": [ { "SplitLineNbr": {"value": "2"}, "Allocated": { "value": true }, "AllocWarehouseID": { "value": "MAIN" }, "InventoryID": {

Hi everyone, I'm encountering an unusual issue when making an API call with the 23.202 build. I'm trying to change a sales order on hold status using the PutOnHold action, but I'm immediately receiving the following error. Once this error occurs, the subsequent GET call is also not functioning and getting the same error message.   "message": "An error has occurred."    "innerException": {        "message": "An error has occurred.",        "exceptionMessage": "A data corruption state has been detected. You cannot save the changes. Copy the data you have entered and reload the page. Date and Time: 2023-12-13T08:08:38; IncidentID: 8f01c121-fd44-4af9-bf02-6144bb6678c1; Name: Aggregate Validation: PX.Objects.SO.SOOrder+openLineCntr. You can view detailed information about the issue on the System Events tab of the System Monitor (SM201530) form.",        "exceptionType": "PX.Data.PXException",        "stackTrace": null Does anyone face this issue? 

Hello all, Just got our cloud instance up and a Second tenant  called “Demo Data Sandbox Tenant”Trying to Auth with the rest API and I get a 500 error “    "message": "An error has occurred.",    "exceptionMessage": "Current user cannot send API requests.",    "exceptionType": "PX.Data.PXException",” I am using this in my body{ "name" : "*************", "password" : "*****************", "tenant": "Demo Data Sandbox Tenant", "branch": "" } and URL is https://***********.acumatica.com/entity/auth/loginI have a local instance that I have been using for the API with no issues. Is there something I am missing for Multi Tennant?  User is an admin. Can log into the GUI no problem. Thank you