Develop Integrations with Web Services | APIs

I’m attempting to create a Bill via the API - https://xxxxx.myobadvanced.com/entity/Default/20.200.001/Bill{ "Entity": { "Type": { "value": "Bill" }, "BranchID": { "value": "MAIN" }, "DueDate": { "value": "2023/01/31T00:00:00+00:00" }, "Vendor": { "value": "14340" }, "VendorRef": { "value": "14340" }, "LocationID": { "value": "MAIN" } }}Response{ "id": "60793d30-6698-ed11-ab3d-023a8f428f42", "rowNumber": 1, "note": null, "error": "'VendorLocationID' cannot be empty.; 'VendorLocationID' cannot be empty.; VendorLocationID: 'VendorLocationID' cannot be empty.", "Amount": { "value": 0.0 }, "ApprovedForPayment": { "value": false }, "Balance": { "value": 0.0 }, "CashAccount": {}, "CurrencyID": { "value": "AUD" }, "Date": { "value": "2023-01-20T00:00:00+00:00"

Has any one used the Acumatica connection in MSFT Power Automate? I cant get passed the login information and keep having issues. I would love help if you have done it before. First image is a few of the questions it asks, everything I have tried doesnt work.Any article I have found is only for custom APIs using power automate, nothing for the built in connector. 

I'm having a problem with customizing in openID provider page.I'm wanting to get the value of the issuer identifier then use it to concatenate my string and save it to the database when choosing save. I am using graph extension to do this but I am getting error.CS0122: 'OidcProviderMaint' is inaccessible due to its protection levelCS0122: 'OidcProviderMaint' is inaccessible due to its protection level    I'm a bit stuck on what else I can try to make this happen. Do you have any other suggestions? :) Thanks a lot  

EndpointCheck PUT Request Body{"CuryOrigDocAmt":{"value":0},"CashAccount":{"value":"10600"},"Type":{"value":"Check"},"Vendor":{"value":"AASERVICES"},"CurrencyID":{"value":"USD"},"Hold":{"value":false},"PaymentAmount":{"value":500},"PaymentMethod":{"value":"AMEX"},"FinPeriodID":{"value":"12-2022"},"Details":[{"PostPeriod":{"value":"122022"},"FinPeriodID":{"value":"12-2022"},"BranchID":{"value":null},"InventoryID":{"value":null},"OrderQty":{"value":0},"WarehouseID":{"value":null},"AmountPaid":{"value":500},"Balance":{"value":500},"CashDiscountBalance":{"value":null},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"004212"}}],"PostPeriod":{"value":"122022"}}  Response Body{"id":"00f6eadd-6293-ed11-bb54-000d3a19a590","rowNumber":1,"note":{"value":""},"error":"Inserting  'CA Transaction' record raised at least one error. Please review the errors.; FinPeriodID: 'Post Period' cannot be empty.","ApplicationDate":{"value":"2023-01-13T00:00:00+00:00"},"CashAccount":{"value":"10600"},"Currency

Good day,I have a few old backorders that need a shipment created confirmed.  it is very important to make sure the schedule shipment is based on the file date.  I think my logic is correct.  Any thoughts or modifications needed.  I have attached the xml and the data file.I always appreciate  your assistance.  Saves my time and also I am getting better.  This one is stumper.Thank youEvan 

Hi, I’m using this GET to get tue customer with the bill to and ship to addresses/entity/Default/18.200.001/Customer?$expand=MainContact,MainContact/Address,ShippingContact/Address,BillingContact/Address It works just fine, the only thing I noticed is that on each request I get the Address.id property (that looks like a guid) changes value Is this expected?What is the best way to get a unique ID of it? Thanks,Ignacio

Hi,I’m trying to get the same list I get using the AR202000 screen by using this GET:https://MYCOMPANYNAME.acumatica.com/entity/Default/18.200.001/SalesPricesInquiry When I do this in postman I get this error:"message": "An error has occurred.",    "exceptionMessage": "Optimization cannot be performed.The following fields cause the error:\r\nEffectiveAsOf: View Filter has BQL delegate\r\nPriceWorkgroupIsMine: View Filter has BQL delegate\r\nInventoryID: View Filter has BQL delegate\r\nItemClassID: View Filter has BQL delegate\r\nPriceClass: View Filter has BQL delegate\r\nPriceCode: View Filter has BQL delegate\r\nPriceManager: View Filter has BQL delegate\r\nPriceManagerIsMe: View Filter has BQL delegate\r\nPriceType: View Filter has BQL delegate\r\nPriceWorkgroup: View Filter has BQL delegate\r\n",    "exceptionType": "PX.Api.ContractBased.OptimizedExport.CannotOptimizeException",    "stackTrace": "   at PX.Api.ContractBased.OptimizedExport.NotWorkingOptimizedExportProvider.get_CanOp

Hi everyoneWe are trying to integrate data from Acumatica into another database/application.While integrating financial information we tried looking for a way to pull Payroll/PTO data using web services / API but we could not find the appropriate endpoint.Can you please point us in the right direction? We are not Acumatica developers or heavyweight users so sorry if the question is inappropriate! Thank you.

Hi, I’m tryiung to do a GET request from:acumatica/entity/Default/18.200.001/invoice?$filter=CreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and Status eq 'Open' That returns the open invoices starting one date.Now I want to add a Balance component but I cannot make it works, I tried: CreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and balance gt 0ALSOCreatedDateTime gt datetimeoffset'2021-09-10T00:00:00.000-00:00' and balance=0 With no success, I’m pretty sure it is a simple thing, but I cannot find it How can I do it? Thanks,Ignacio

I have a method, FooBar() that returns a value that I want to be made available on my web service endpoint. I display the value on a non-persisted field by setting it in the RowSelecting event, but it does not make it to the endpoint? How can I get the value of my non-persisted field to the endpoint?

I am trying to port some of my calls over from using the Rest API to using the ODATA4 interface. Using a simple call like this… http://ODATAV4_URL/PX_Objects_In_InventoryItem?$filter=InventoryCD eq 'BCWICFGBLK’&$format=json How to include a list of all the attributes and values associated to a InventoryItem. With the RestAPI, I could just $expand=Attributes and it would return that in the payload. I can’t seem to figure it out when using ODATA. Thank you all! Eric

Hello, I have a process that syncs stockitems from Acumatica for use on an external eCommerce web application. I download the images as part of the sync and store them in Azure storage. The web application loads the images from the storage accounts.I am finding that when I download a batch of images...perhaps syncing 10 products in a batch, I will get the first 3 images and then the response stops sending any content. I get an HTTP 200, but I receive no bytes in my download.If I slow down my process it seems to work better.I have seen similar issues when calling the rest API. If I download 1 product at a time, if my sync process goes too fast, Acumatica sends empty results….no error or anything like that. I was able to work around that issue by downloading batches of stock items in groups of 500 and storing the raw JSON to the DB and then doing the ETL steps after.  Is there some sort of limit in Acumatica or a better approach to fetching the images? I have my service account set to un

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