Develop Integrations with Web Services | APIs

We can easily import sales order with Acumatica REST APIs but we cant get TaxOverrides to work during the api call.  We did create a Manual Tax zone and Tax ID  and both comes in but when the order gets created but the tax amount comes in at zero and not the values we send in.For example this below JSON  crates the order but tax amount comes to zero instead of $2{  "OrderType": {  "value": "SO"  },  "CustomerID": {  "value": "AMAZONG"  },  "Details": [ {"InventoryID": {  "value": "SKU1"   },        "OrderQty": { "value": 1 },        "UOM": { "value": "EA" },      "UnitPrice": { "value": 10.0 } } ],  "FinancialSettings": { "OverrideTaxZone" : { "value": true },"CustomerTaxZone" : { "value": "MANUAL" } },  "TaxDetails": [ { "TaxID": { "value": "MANUAL" },        "TaxableAmount": { "value": 10.0 },        "TaxAmount": { "value": 2.0 }  } ],  "TaxTotal": { "value": 2.0 }} Once the order is created, users can go through the UI and open the order and in the taxes TAB, update the Tax amount.

Hi,I’m getting the following error after adding a field and controls to a screen. The fields is just a checkbox (boolean) with a checkbox ui control. There is a control on another form that has the same name’ I didn’t expect it to cause an issue however now it doesn’t compile and gives the following error: Building directory '\WebSiteValidationDomain\App_RuntimeCode\'.\App_RuntimeCode\PX_Objects_CR_BAccount_extensions.cs(45): error CS0579: Duplicate 'PXDBBool' attribute\App_RuntimeCode\PX_Objects_CR_BAccount_extensions.cs(46): error CS0579: Duplicate 'PXUIField' attribute\App_RuntimeCode\PX_Objects_CR_BAccount_extensions.cs(45): error CS0579: Duplicate 'PXDBBool' attribute Does anyone know how to resolve this issue? I’ve looked in the file specified and only see a single entry for the boolean field I added.

Hi All,My observation     Please understand below one of the scenario is causing error.  Actual Staring time : 7:30 PM (UTC Time is 11:30 PM) Actual Ending time:  8:00 PM (UTC Time is 12:00 AM)  In that scenario causing issue "WorkOrder.Labor[0].ActualEndTime: The times are invalid. The end time cannot be earlier than the start time.\nWorkOrder.Labor[0].ActualStartTime: The start time cannot be later than the end time. Correct the values.\nWorkOrder.Labor[0].StartDate: The start time cannot be later than the end time. Correct the values." Even though we pass time along with the date , these Actual start time and end time not considering Date in the request format We tried below accepted format already Local time format with time zoneActual Start Time : 2022-10-21T19:30:00-04:00Actual End Time : 2022-10-21T18:00:00-04:00  UTC FormatActual Start Time : 2022-10-21T23:30:00Actual End Time : 2022-10-22T00:00:00 Both format system not getting accept and throwing the error.  Below is the samp

Hi,  Trying to get customer data out via API request and am having an issue when the key data I’m including has an &.  Specifically trying to get customer and/or customer contact information and the endpoint for customer works fine for IDs with no special character, but a bunch of customers on this implementation have an & in the customer code and when I execute the same command via postman using those customer IDs an error is returned.  I did some digging and did try a few workarounds, etc. I found on the web most involving using %26 in place of the &, but everything I’ve seen on the web I’ve tried and still get the same error returned.  Has anyone encountered this and is there workaround or specific syntax I need to use?  Thanks, pasting the URL, just using the ‘base’ endpoint that comes with the system, engaging the customer endpoint (and eventually contact information as well). Works fine and customer data is returned  Returns errors  

The data pulled is -3hours. Will appreciate any help here

I have an issue when trying to place a SalesOrder via the Rest API. For this scenario, I am getting an error 422 - Unprocessable Entity. The error message is:   "error": "Unit conversion  is missing.; Unit conversion  is missing.", This particular order has a quite a few items, so if the issue is related to one of the products, how could I find that out.Any thoughts on how I could find the offending entity? Thank you! 

Is it possible to attach file to scenario while executing a task  using API ?  

Hi Team,I am trying to pull the payments from Payment Rest API with below filter but I am getting an error in response. This may be because of datetime format. Can you please look into this?https://sandboxxyzxyz.myobadvanced.com/entity/Default/20.200.001/Payment?$filter=LastModifiedDateTime ge 2020-01-01T23:59:59.99Z Response: {    "message": "An error has occurred.",    "exceptionMessage": "Syntax error at position 31 in 'LastModifiedDateTime ge 2020-01-01T23:59:59.99Z'.",    "exceptionType": "Microsoft.Data.OData.ODataException",    "stackTrace": "   at Microsoft.Data.OData.Query.ExpressionLexer.ValidateToken(ExpressionTokenKind t)\r\n   at Microsoft.Data.OData.Query.UriQueryExpressionParser.ParseFilter(String filter)\r\n   at Microsoft.Data.OData.Query.ODataUriParser.ParseFilterImplementation(String filter, IEdmType elementType, IEdmEntitySet entitySet)\r\n   at PX.Api.ContractBased.OData.Helpers.FillRestQueryOptions(IEdmModel edmModel, EntityImpl entity, String filter, String selec

I'm having a hard time integrating Okta into Acumatica. Do you people  this is possible because I can't find the relevant documentation?. If you did, could you please give can i guide? Thanks a lot THiNGknghĩđộng từnghĩ, nghĩ ngợi, suy nghĩ, tưởng tượng, ý định

I am trying to execute a query against a GI using OData. I have been struggling in the fact that I need to make multiple round trips to retrieve data. My question is, is there a way to query a GI and pass in a list of InventoryIDs? This is what I am using now...and pulling one at a time. For a few thousand updates a night, this takes a long time./IN-InventoryBalance?$filter=InventoryID eq ‘MyInventoryID’&$format=json Is there a way to pass is a list of InventoryID’s where I can get back multiple results? I could at least do this in a batch type of format. Maybe 20 at a time? Thanks for your help!

I am trying to find a way to change SQL server from using UTC time to Local time. This is because I need to be getting Local time when I pull data using ODATA via excel. Is there a way to configure the SQL server from UTC to local time?

Hi, Our solution features an extended endpoint (v 18.200.001 Default, System Contract 3) that has grown over the years to contain a lot of crucial elements not expoed in the standard endpoint.We are wanting to stay with the times and derive from a newer endpoint version (22.2) and we've tinkered with the project.xml file a bit only to get an endpoint that 'sort of' works but not well enough to use. Specifically, the resulting endpoint can't export the swagger definition for building a client.So my question: Is there an automated means of migrating an extended endpoint to a newer version, or will we have to just export it to Excel and build the new one manually?Understandably we would prefer, if at all possible, to automate this and mitigate the human element and several cycles of fixing errors.Thanks! Mike

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