Develop Integrations with Web Services | APIs

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

Hi, My application creates Bill in Acumatica via REST request URL : https://sandbox-21r2.acumatica.com/entity/ARTSEndpoint/18.200.001/BillBody : {  "VendorRef": {    "value": "19071450-21101"  },  "Description": {    "value": ""1\""  },  "Vendor": {    "value": "0600001521"  },  "Date": {    "value": "02/22/2022"  },   "Details": [    {      "InventoryID": {        "value": "OLIES"      },      "Project": {        "value": "X"      },      "TransactionDescription": {        "value": "Ly"      },      "Branch": {        "value": "FOHIL"      },      "POReceiptNbr": {        "value": "06007974"      },      "Qty": {        "value": 1.0      },      "UnitCost": {        "value": 23609.25      },      "Account": {        "value": "68010"      },      "Subaccount": {        "value": "4000000000"      },      "POReceiptLine": {        "value": 1      },      "rowNumber": {        "value": "1"      }    }  ]}If I change only vendor on another one it worksWhat causes such behavior that it work

Hi, My application creates Bill in Acumatica via REST request URL : https://NewAcumatica/entity/ARTSEndpoint/18.200.001/BillBody :{  "VendorRef": {    "value": "byIvan"  },  "Description": {    "value": "d \"1\""  },  "Vendor": {    "value": "AAVENDOR"  },  "Date": {    "value": "2/15/2022"  },          "Terms": {    "value": "NET15"  },"PostPeriod": {    "value": "06-2022"  },"CashDiscountDate": {    "value": "1/31/2022"  },  "DueDate": {    "value": "2/15/2022"  },  "Details": [    {      "InventoryID": {        "value": "AACOMPUT01"      },      "Project": {        "value": "X"      },         "TransactionDescription": {        "value": "Lysolays"      },      "Branch": {        "value": "PRODWHOLE"      },      "POReceiptNbr": {        "value": "PR001666"      },          "Type": {        "value": "Receipt"      },         "ReceiptQty": {        "value": "1"      },      "Qty": {        "value": 1.0      },      "UnitCost": {        "value": 23      },          "POReceiptLine": {  

Hi,My PUT request : {  "VendorRef": {    "value": "by12345"  },  "Description": {    "value": "docAlpha BatchID \"1\""  },  "Vendor": {    "value": "060038345988"  },  "Date": {    "value": "02/22/2022"  },  "PostPeriod": {    "value": "04-2022"  },   "Details": [    {      "InventoryID": {        "value": "suppply"      },      "Project": {        "value": "X"      },      "TransactionDescription": {        "value": "Lysol Disinfectant Sprays"      },      "Branch": {        "value": "branch"      },      "POOrderNbr": {        "value": "06007404"      },     "POOrderType": {        "value": "Normal"      },            "Qty": {        "value": 1.0      },      "UnitCost": {        "value": 16      },      "Account": {        "value": "6234"      },          "rowNumber": {        "value": "1"      }    }  ]}return the following error however the PO is present in system According to PO History tab this PO is not used for another bill.Suggest, please, what can cause the error ?

I was following this training guide that I found on google.  Oddly enough I can’t find it via the actual website.Anyways, I’ve gotten so close on getting my program to work in VS.  I was following the example in this file for exporting warehouses starting on page 11.I keep getting this error.  I’ve tried everything I can think of.System.Web.Services.Protocols.SoapException  HResult=0x80131501  Message=System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> PX.Data.PXException: API Login Limit   at PX.LicensePolicy.PXLicensePolicy.CheckApiUsersLimits()   at PX.Data.PXLogin.PX.Data.IPXLogin.LoginUser(String& userName, String password)   at PX.Api.Services.LoginService.Login(String login, String password, String company, String branch, String locale, String prefix)   at PX.Api.ContractBased.ILoginServiceExtensions.LoginForSoapApi(ILoginService loginService, IMultiFactorService multiFactorService, String login, String password, String company, String

HiI am trying to access the WSDL  based on a endpoint version: 20.200.001has support for this been removed? Build version: 21.207.0045  

I am working on an automated Integration that picks up the products based on the last date modified and updates those products in an e-Commerce platform. but whenever the inventory is updated, it's not affecting the last date modified of the products and I am not seeing those products in my response.URL :  https://<host_url>//Entity/<endpoint_name>/<endpoint_version>/StockItem?$filter=LastModified ge datetimeoffset'2022-01-19T05:17:43'This the API and parameters I am using in order to fetch recently updated products (date will change based on the integration run time)if a Qty of a product is updated (Qty added to a product, shipment completed with a product in order) it's not affecting this last date modified.Is there a way to find the Inventory change of a product, any separate endpoint just to determine a change?Thanks,

Hello,I have an issue to export TaxDetails table to Acumatica together with bill data.I prepared columns : TaxID, TaxRate, TaxableAmount, TaxAmount. for requestRequest is received status OK, new bill Item is appeared at acumatica, but tax details is emptyIs there any special conditions, with the help of which I can send TaxDetails table data to Acumatica? 

I am attempting to create new locations using the REST Web-services Endpoint. I want to create a new location however I don't have the “CustomerID” for the location I am creating. Rather I have the Customer NoteID which is the ID returned from the Get request against the customer endpoint. Is it possible to use the unique customer identifier vs the companyID ?