Develop Integrations with Web Services | APIs

Hi Guys, i am trying to process a purchase receipt of a purchase order but i keep getting this error below. Can you kindly help? I have followed the Acumatica example found here : https://help-2021r1.acumatica.com/(W(61))/Help?ScreenId=ShowWiki&pageid=81e5ec25-09f7-421a-8f80-01b6b71d38c9 EndPoint: baseURL/entity/Default/18.200.001/PurchaseReceiptRequest{  "VendorID": {"value": "DIG001"},  "Location": {"value": "MAIN"},  "Details": [    {      "POOrderNbr": {"value": "PODP003483"},      "POOrderType": {"value": "Normal"}    }  ]}Error:        "innerException": {            "message": "An error has occurred.",            "exceptionMessage": "PO line number, PO type, and PO number must be filled in for the system to add the purchase order to the details.",

Hi,I faced with strange Acumatica behavior, while creating new PaymentI am using the following PUT requestURL : https://arts.acumatica.com/entity/ARTSEndpoint/20.200.001/PaymentBody : {  "LocationID": {    "value": "MAIN"  },  "PaymentRef": {    "value": "byIvan"  },   "Type": {    "value": "Payment"  },  "CustomerID": {    "value": "ABCHOLDING"  },  "CashAccount": {    "value": "10200"  },  "ApplicationDate": {    "value": "02/17/2019"  },  "ApplicationPeriod": {    "value": "01-2019"  }}The Payment ref field value is “byIvan”However, Acumatica replaces it with another valueSame behavior repeats with other fields, for example Description column value in DocumentstoApply table was also replaced by another value, not what have sent.Is there something that I do wrong and is there ability to fix it ?

Hello I have been using such PUT request for creating Purchase ReceiptURL : https://tprocess.acumatica.com/entity/ARTSEndpoint/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": "123"  },  "Details": [    {      "POOrderType": {        "value": "Drop-Ship"      },      "POOrderNbr": {        "value": "PO00164327"      },      "ReceiptQty": {        "value": "1"      },      "POLineNbr": {        "value": "1"      }    }  ],  "VendorID": {    "value": "0000002346"  },  "PostPeriod": {    "value": "03-2022"  },  "Location": {    "value": "MAIN"  },  "CreateBill": {    "value": false  }}After performing this request, purchase receipts appeared at this tabWhile testing application which do same for another client I faced with such error I did not found something inform

Currently, we are facing an issue with a push notification webhook in our QA and PRODUCTION Acumatica environments that is unable to be sent out (the same flow works in our DEV Acumatica environment).The function of the webhook is to refresh a purchase order (PO) cache after certain events have occurred such as: PO creation, PO updating, PO deletion, and PO status changes. More specifically, we are having trouble triggering the webhook when a PO’s status is changed (e.g. from “On Hold” to “Open”).I will attach a few screenshots of the error messages associated with the webhook below, and can upload more information if requested.System Monitor screen: Process Push Notification screen: Push Notification screen:Again, the exact same webhook flow works perfectly in our DEV Acumatica environment, and I have verified that the Address used inside the Push Notification webhook is 100% working. I’ve also confirmed via https://webhookinbox.com that the webhook is able to send data in that scenar

Hi,Previously I sent documents to Acumatica files for bills with the help of such requesthttps://myacumatica.com/entity/ARTSEndpoint/20.200.001/Bill/INV/002272/files/MicrosoftTeams-image (3).pdfNow I need to do the same for this tabInstead of Bill in request I need to use Payment, but what I must write instead of inv ?https://myacumatica.com/entity/ARTSEndpoint/20.200.001Payment/???/002272/files/MicrosoftTeams-image (3).pdf

Fail to   get customer address via Api ,  when i checked the endpoind I found entity properties “Address” has yellow exclamation point .Please help. 

Hi,Is there ability in Acumatica to add custom payment methods to customization project packages ?If it is possible how can I add custom payment methods to package ? 

We want to send the customer email address to Auth.net so that Auth.net can send out the credit card receipt to the customer.  We are using the Authorize.net API plugin with v2021 R2.  The Email Receipt flag at Authorize.net has been turned on.  Is sending the email address native to the API plugin?

Hi Everyone, I am testing our customization project that integrates with our WMS system. We have two Acumatica instances set up on the latest 2022 R1 release. We are using one for development and the other to simulate production. I have tested everything in the development instance and everything is working as expected. After verifying transaction downloads and uploads were working correctly, I exported the customization project and imported it into the “production” instance. I am running into issues uploading transactions to the production instance, receiving errors that fields cannot be empty when calling PutEntity(). Issues and Receipts are specifying that PostPeriod and Branch cannot be empty when calling PutEntity().Sales Orders specify that BaseCurrencyID and CuryID cannot be empty when calling PutEntity(). We had fixed the PostPeriod and Branch errors in the development instance, but we are getting this error in the production instance, even though we set these fields when updat

Hi communityIn our CI/CD implementation we’re publishing the customization package through   https://someUrl/api/ServiceGate.asmxby using PublishPackagesAsync(new string[] { LastPackage.Name }, true) methodthe customization package get published without any issues but the plugin in the customization package not get executed, if we try to manually publish the same project via Customization Projects screen (SM.20.45.05) then everything goes well.The plugin use UpdateDatabase() to call the bussines logic.Is this behaviour due to the limitation of service gate…? any suggestions will be highly appreciated.  

Hi,I’m using Acumatica API in a C# project. I wrote following code to access all the Purchase Receipts:if (InitAPI() == false) { return ""; }                PO302000Content POReceipt = context.PO302000GetSchema();                #region Fields                List<Command> cmdSelect = new List<Command>();                cmdSelect.Add(POReceipt.DocumentSummary.ReceiptNbr);                cmdSelect.Add(POReceipt.DocumentSummary.VendorRef);                cmdSelect.Add(POReceipt.DocumentSummary.Status);                cmdSelect.Add(POReceipt.DocumentSummary.ExternalNbr);                cmdSelect.Add(POReceipt.Other.Branch);                cmdSelect.Add(POReceipt.Other.BillDate);                cmdSelect.Add(POReceipt.Other.INRefNbr);                cmdSelect.Add(POReceipt.Details.InventoryID);                Field lmd = new Field                {                    ObjectName = POReceipt.DocumentSummary.ReceiptNbr.ObjectName,                    FieldName = "LastModifiedDateTime

Hi, My goal is to investigate opportunity to store in Acumatica credentials which will be used for FTP server authorization. Currently, the credentials are written inside customization project, but it is required to provide ability to change them. Is it possible to implement such scenario : 1)Create custom entity 2)Add URL, login, password fields for this entity3)Extract  these values inside code of Customization projectIf there exist more proper way to resolve it, suggest please

Hi, I always used such POST request for releasing Purchase Receipts in AcumaticaURL : https://testacumatica.com/entity/Endpoint/18.200.001/PurchaseReceipt/ReleasePurchaseReceiptBody : {  "entity": {    "VendorId": {      "value": "0000000170"    },      "Type": {      "value": "Receipt"    },    "PostPeriod": {      "value": "12-2021"    },    "VendorRef": {      "value": "1139273"    },    "ReceiptNbr": {      "value": "000402"    }  },  "parameters": {}}But know I get 202 response AcceptedAnd purchase receipt remains in balanced status instead of being releasedWhat can cause such problem ?

Hi everyone, Is there API where it can return the list of Discounts applicable for a specific customer given the Customer ID? And also the discounts applicable for a Customer price class, item class, item id, etc? Thank you 

Hello,Could we get more clarity on what this options do, when setting up Avalara connection?Sorry, couldn’t find any specifics in Acumatica and Avalara wikis.Thank you!

Hello Everyone,One of our client configured the InventoryID segment key like below.When we try to create an order through API with this product, getting the error “The record has been deleted”.  It's not considering the “-” while syncing the order.If provide the value without the “-” It's working fine.And also we noticed that if added only one segment key with “_” or “-”  worked fine.Is it any possible way to sync the product with this Segment Key configuration?.   

I have Budget with line items as follows (simplified):{ "account": "4100000", "subaccount": "ADMIN" "amount": 123.45}, { "account": "4100000", "subaccount": "CAPWRK" "amount": 567.89}, { "account": "5555555", "subaccount": "ADMIN" "amount": 1000.00} If I `PUT` to `/entity/Default/20.200.001/Budget`  but mark `”Delete”: true` on only the first item, both the first two items are deleted - ie: both items with 4100000 as the `account` are deleted, not just the ADMIN subaccount line item.Am I missing something obvious??

Hi All, Where can I see/educate myself on all the API's that are available from Advanced?  I.e. I need to provide mapping from Acumatica to third party product. Cheers,Laura

how upload file from REST API when add new customer?

Hi, I am successfully now creating a check payment BUT when there are multiple bills it does not seem to pay the one needed, is there a way of paying directly against a specific bill ? How do I pass this in the payload for Check, documentation is quite lacking. Thanks

I am trying to update a Budget via the REST API… The inner exception I am getting is: Error: Another process has added the 'GLBudgetLineDetail' record. Your changes will be lost.Full response is below: { "message": "An error has occurred.", "exceptionMessage": "Operation failed", "exceptionType": "PX.Data.PXInvalidOperationException", "stackTrace": " at PX.Api.ContractBased.EntityService.Put(ISystemContract systemContract, String version, String name, EntityImpl entity, CbOperationContext operationContext, Boolean throwOnError)\r\n at PX.Api.ContractBased.Soap.SoapFacadeBase.PutImpl(EntityImpl entity, Boolean throwOnValidationError)\r\n at PX.Api.ContractBased.SystemContracts.V2.RestController.PutEntity(EntityImpl entity, String select, String filter, String expand, String custom)\r\n at lambda_method(Closure , Object , Object[] )\r\n at System.Web.Http.Controllers.ReflectedHttpActionDescriptor.ActionExecutor.<>c__DisplayClass6_2.<GetExecutor>b__2(Object insta

Good day,  we use the 2020R1 API version 18.200.001 to integrate a cloud-based program called Jitterbitt/Postman..  We use to the API to send payloads with ACM data (address, items, etc)  One situation that has occurred was we had about 6 orders to send; only one payload was transmitted.  Everything was exactly the same on the mapped fields.  Anyone know why the API would only transmit one order but left the others.  The log in Jitterbit/Postman had only one record in the log.  Another question,Iis there a way for me to look at the API transmission?  a log or something that I can go into so I can check activity on the API transmissions?I know this is vague but we can figure out why one of many payloads would be passed.Thank you.Evan

We currently use microsoft flow to catch and transform webhooks/data from 3rd party services and post back into Acumatica. However, we would prefer to use Zapier. I know it is a bit more complicated than your standard https rest api, but does anyone have any guidance as to what might be possible with Zapier and how to do it?

I have a user that always displays their name as the contact whether trying to Log Activity for Inbound or Outgoing email. The rest of the company displays the Recipient for sent mail and the Sender for incoming mail.We have tried to uninstall and reinstall the Outlook add-in manifest and have checked a user with identical roles.Does anyone have any other theories on what may be causing this? An option in outlook that doesn’t identify outgoing messages or something?Any help greatly appreciated

Hello Everyone,We are trying to make a get call for checks and payments screen to get all the checks along with application history tab details within a date range.I have provided the lastmodifieddatetime for date range filter and it is working fine but when i add the history object to the API URL, I’m getting optimization cannot be performed error in the GET call.I have used below URL.http://localhost/MyInstance/entity/Default/20.200.001/Check?$filter=LastModifiedDateTime ge datetimeoffset'2022-02-08T23:59:59.99Z' and LastModifiedDateTime le datetimeoffset'2022-02-13T23:59:59.99Z'&$expand=History Error details:"message": "An error has occurred.",    "exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nHistory.AmountPaid: View APPost has BQL delegate\r\nHistory.Balance: View APPost has BQL delegate\r\nHistory.CashDiscountBalance: View APPost has BQL delegate\r\nHistory.CashDiscountTaken: View APPost has BQL delegate\r\nHistory.DocType: View