Develop Integrations with Web Services | APIs

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 ?

Hi,This issue was discussed in this topic here - “Created looped method in customization Project”I describe what I am trying to achieve : I need to define a code which will be always executed, without any user actions,One important moment - is should work if Acumatica IIS process is running, so even if we have not authorized in Acumatica the code inside package that was imported to Acumatica customization must work. The logic is very simple - it will just generate files in specific directory all time.It was advised to perform to following steps in order to achieve the required result Create a new processing screen Written a logic in processing screen graph schedule this screen for every 10/20/30 minutesI need to clarify some momentsThe first one : during creating new screen - is it enough to generate new one screen without adding anything here (fields, other elements) at stat step (I do not need to use anything from this entity, no new fields, I just need to create independent code as

Hi, I need to synchronize the product stocks with our website through API and I would like to trigger the application on product stock change so I have 3 questions:Is it possible to add a business event trigger on product stock change? If point nr 1 is possible can a business event trigger start an application from ‘Run application’? If point nr. 2 is possible, can we send arguments(parameter) based on event? I would need to send the inventoryID as the parameter in this case.     

Hi,I need to implement such logic that is executed eternally and without user’s actions, after I will deploy my project package for client’s Acumatica.Previously, the extension of functionality was achieved via events, which required the user interaction (By pressing SAVE button).Now, I need to define a code which will be always executed, without any actions,One important moment - is should work if Acumatica IIS process is running, so even if we have not authorized in Acumatica the code inside package that was imported to Acumatica customization must work.Can you. please, provide instruction, where I must locate my code in order to work at any time ?

Hi,I have two methods that extend functionality of 2 UI elements1)Release from Check and Payments tabProcess from Release Payments tab  Unfortunately, when I press process from Release Payments tab, it calls persist methods which is responsible for Release button in Checks and Payments and executes it’s logic, that I have wrote. I tried to omit this by using static class , checking if the flag was set to true in class which responsible for Release Payment tab, but it’s not working as I expected due to method is called arbitrary  How to prevent calling of Persist method of Release button when  Processed button is pressed ?