Develop Integrations with Web Services | APIs

Hi, Community!We are using Procore’s synchronization with Acumatica and would like to see the logs in Acumatica for Procore synchronization processing as input to the decision to increase synchronization frequency. Where do we find the API logs?Procore does not have any logs that are client-facing outside of the change history on the individual items within Procore. As far as anything logging specifically within Acumatica, the Procore dev team doesn't write any logs to the Acumatica server and there is no known journal of activity.Thank you,Dave Z

Good day, everyone.We are attempting to update the Commitment tab details in the change order screen using the REST API, but we are encountering problems when updating the Commitment type and Commitment nbr values from the API.Commitment type is set to Purchase order by default, and if we assign PO transaction values to Commitment nbr. from API, it works fine because PO values are already loaded into selector. However, when we assign "Subcontract" type to Commitment type and subcontract # to Commitment nbr via API, we receive an error stating that the subcontract was not found in the system. The JSON and URL for this call are shown below. Can anyone suggest a solution to this problem?PUT: {{SiteURL}}entity/DefaultEx/18.200.001/ChangeOrder{ "RefNbr": { "value": "000020" }, "COMMITMENTS": [ { "ACCOUNT": { "VALUE": "51250" }, "AMOUNT": { "VALUE": 600432.0000 }, "CostCode": {

 Response error :Inserting  'Sales Order Line' record raised at least one error. Please review the errors.; Inserting  'Sales Order Line' record raised at least one error. Please review the errors.; POLinkActive: The sales order line has no active link to a line of a purchase order. I tried staging it went well, I tried it live this problem occurred.how to fix this error?

What API can I use to insert longitude latitude for customer location, I found in customer location api but I don't find longitude latitude field? 

Currently using WhatsApp Beta APP Multi-device feature, I need to link my business account with Acumatica.Which  API can I use to provide an interface between WhatsApp Business beta and Acumatica.

Regarding Acumatica APII am developing an app with Sales Order update functionality, I’m appending customer order number with P.O number provided in ecommerce site upon order.The problem is every time I try to update the Sales Order it is not updating. Upon searching for documentation and reference, I read a comment on one forum that PUT request will not work if Order type is not SO. With this I just want to verify if this is correct or if it is, is there a way to update it? Thank you!

Hi,Previously my request perfectly worked and Purchase Receipt was generated in Acumatica systemURL of the request : https://tdocs.acumatica.com/entity/AEndpoint/18.200.001/PurchaseReceipt?$expand=Details&$select=Branch,ReceiptNbr,CurrencyID,Details/InventoryID,Details/POOrderNbr,Details/POOrderType,Details/ReceiptQty,Details/TransactionDescription,Details/UnitCost,Details/UOM,Details/WarehouseBODY : {  "VendorRef": {    "value": "byIvan"  },  "Details": [    {      "POOrderType": {        "value": "Drop-Ship"      },      "POOrderNbr": {        "value": "PO0017612"      },      "TrackingNumber": {        "value": "9999"      },      "ReceiptQty": {        "value": "1"      },      "POLineNbr": {        "value": "1"      }    }  ],  "VendorID": {    "value": "0000004444"  },  "PostPeriod": {    "value": "11-2022"  },  "Location": {    "value": "MAIN"  },  "CreateBill": {    "value": false  }}Now I receive such error Here is full stack trace{    "message": "An error has occurred.", 

Hi,I need to send these values for new Bill, which I am creating via such request{  "entity": {    "VendorRef": {      "value": "Test"    },    "DueDate": {      "value": "05/15/2022"    },    "Vendor": {      "value": "0000000018"    },    "Date": {      "value": "10/3/2022"    },    "Description": {      "value": "docID \"1004\""    },    "ReleaseBill": {      "value": "True"    },    "PostPeriod": {      "value": "10-2022"    },    "Details": [      {        "InventoryID": {          "value": "3050"        },        "Description": {          "value": "Landed Cost Accrual"        },        "UOM": {          "value": "EACH"        },        "Project": {          "value": "X"        },        "Branch": {          "value": "4011"        },        "ExtendedCost": {          "value": "829"        },        "POReceiptNbr": {          "value": "R0662"        },        "POReceiptLine": {          "value": "1"        },        "Subaccount": {          "value": "000-00"        },        "Accou

​We are trying to use the new oData v4 to integrate with an Dataself, but when trying to pull metadata there are no keys for the ARInvoice table, as shown below in the screenshot.  We can make direct calls to the table using queries similar to the following and get results.  Is there a reason there aren’t any keys listed in metadata for ARInvoice?MetaData showing ARRegister, ARInvoice & SOInvoiceAll of the following requests return results with both the DocType and RefNbrThanks,Kurt​

How to check Process in  Process Payments/Print Checks Using Rest Api. 

How to pass NextCheckNumber in Process Payments/Print Checks Using Rest Api.when I call processAll entity show that message-- Next Check Number is required to print AP Payments with 'Payment Ref.' empty. 

I have successfully updated the value for an attribute called PHOTOURL on a Stock Item via the REST API using the Default Endpoint.  I did this using Postman and also wrote my own standalone app which works without problems.  I am now trying to do the same for a Template Item.  As there seems to be no Default Endpoint set up for Template Items I created my own.  This works fine for updating the description field but fails when I try to update the Attribute value for AttributeID PhotoURL.  I am using the same method as I used to update Stock Items and have recreated the same Attributes Entity in my own Stock Items endpoint as a test.  The same body text that works to update the Attribute using the Default StockItem endpoint doesn’t update using my endpoint.As far as I can tell I have set it up in the same way. Does anyone have experience of setting these up and can shed some light on where I’m going wrong?See images below:Default endpoint which updates attribute valueMy endpoint which d

Hello Team,I found the following error with payments.1. I have created a payment via API. The payment is being created successfully.2. Then I use a payment to allocate with invoice or credit memo via API to pay it.3. Send the payment with allocation to the invoice or credit memo to Acumatica via API.Acumatica returns the following error message:Payment update request returns the error message - "exceptionMessage": "An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR.......' cannot be found in the system.\nPX.Data.PXOuterException: An error occurred during processing of the field Reference Nbr.: Reference Nbr. 'AR......' cannot be found in the system."When I repeat the same Payment update request after a period of time (in 1,5,10,20 minutes), Acumatica creates a payment successfully.Could you clarify what is the reason of this behavior?

Hi, Previously my request successfully worked with another acumatica instance for creating purchase receipts, now throws the following error : Here is my request : URL : https://test.acumatica.com/entity/ARTEndpoint/18.200.001/PurchaseReceipt?$expand=Details&$select=Branch,ReceiptNbr,CurrencyID,Details/InventoryID,Details/POOrderNbr,Details/POOrderType,Details/ReceiptQty,Details/TransactionDescription,Details/UnitCost,Details/UOM,Details/WarehouseBODY :{  "Location": {    "value": "MAIN"  },  "CreateBill": {    "value": "false"  },  "VendorID": {    "value": "PT"  },  "VendorRef": {    "value": "PP414-kkk"  },  "PostPeriod": {    "value": "11-2022"  },  "Details": [    {      "POOrderType": {        "value": "Normal"      },      "POOrderNbr": {        "value": "PO001200"      },      "ReceiptQty": {        "value": "1"      },      "POLineNbr": {        "value": "1"      }          }  ]}Please suggest how to troubleshoot itI attached stack of the error {    "message": "An error ha

HiI’m wanting to do a carrier integration for a client and I need help finding where to start.Main consideration: Should I be sending POST API calls from Acumatica directly to the freight software or should I be using a third-party application to send GET requests to Acumatica then POST calls to my freight software. If I send POST API calls from Acumatica:Would be the Shipment Screen be the best endpoint to look at?  Can I trigger a POST call from this Shipment Screen? And If so can I send all the information from these endpoints? If I set up this POST, can I edit how the JSON is formatted in the API body? Should I be looking at the Carrier Label screen instead (SO645000)?  If I did it this way, would the customisation need to be written in a complex C# customisation project? (It’s hard to write custom C# with the online hosted version of Acumatica (MYOB Advanced) used in Australia and New Zealand). Any suggestions, experience or success stories anyone has on this topic would be apprec

Does anyone know of an import scenario of API integration to convert approved Expensify expense claims into AP Bills in Acumatica?

I am not that experienced with Acumatica so this may be a straight forward task.I have about 2000 guest user accounts that I need to assign a new role to. After a few hours, I couldn’t find a great way to do it in either the UI or via the Rest API. Can someone point me in the right direction? I appreciate it!!!

If I already Login but My token has been expired .How to refresh token get. or Any other way to get token through rest API. 

Greetings folks, We are on the Cloud version of Acumatica, not yet through our first year. We had a user inadvertently leave Migration Mode on after performing a task that required it, and now the business would like us to find a way to detect if it’s on. Any suggestions for how to go about this? We interact with Acumatica via Serverless lambda functions in AWS, but I’ve not located an API for this. Thank you, Dave

I’m looking to use the REST API to create Project Quotes - is this possible? I’m not seeing the Entity in the webservices view

Sorry I should have inspected the response, it contains an element `expires_in` which is 3600 seconds

{ 'client_id': "xxxxxxx@company", 'client_secret': "xxxxxxxxxx", 'grant_type': 'client_credentials', # 'grant_type': 'password', 'scope': "api", 'username': 'xxxx', 'password': 'xxxx',}This is the body I am sending, but I am getting `{'error': 'unauthorized_client'}` what am I missing?Secondly, the documentation says the grant_type must set to `password`, but if I do that, I get `invalid_grant`

Does the ‘Multiple Warehouse Locations’ feature need to be enabled, no matter which inventory transfer method (1-Step or 2-Step) you were to use, in order to successfully create an inventory transfer through the REST API? If I have that feature enabled I am able to create Transfer documents successfully through the REST API but if that feature is not enabled my REST API call fails.  When that feature is not enabled I receive an ‘locationID cannot be empty’ error no matter which type of transfer I attempt to create, 1-Step or 2-Step.

I’d like to be able to make one of the web endpoints read-only.  Is that possible without going through security/roles?There are some other web endpoints that I would like to make specific fields read-only as well. Is there a way to do that?  I could make a non-persisted field that mirrors the value of the field I want to display and expose that in the endpoint. I’m wondering if I’ve overlooked something. 

I’m trying to create a new Customer using the PUT Method in Postman, and I’m receiving the following error message."error": "Inserting  'Location' record raised at least one error. Please review the errors.","SalesAccount": {     "error": "'Sales Account' cannot be empty."},Here’s what I’m sending through the Body.{ "CustomerName": {"value":"TEST TEST"}, "Location":[ {"SalesAccount": {"value": "60040"}} ]}I copied this Sales Account value from another record, so I’m not sure why it’s not recognizing the value.