Develop Integrations with Web Services | APIs

Wondering if anyone has tried the following before:Step 1) Web service call (REST) to create a Drop Ship Purchase OrderStep. 2) Web service call (REST) to create Sales Order, including Drop Ship PO information at the SO Line level in the PUT request. Has anyone tried to update the PO information on the SO Line via REST API call? Below are my two API calls – first for creating the PO, second for creating the SO.  I am trying to populate the “POOrderNbr” on the Detail record directly (which is essentially what it looks like the PO Link functionality does).  Assuming that the PO Link has some extra logic baked in that allows this field to be written to as needed. Purchase Order API call: {   "Details":[      {         "InventoryId":{            "value":"ITS-002687"         },         "LineNbr":{            "value":1         },         "OrderNbr":{            "value":"400080001"         },         "OrderQty":{            "value":1.0         },         "UOM":{            "value":"EA"       

Hi i am looking for help with creating a receipt for a transfer order via API.I created a 2 step transfer as seen in the image. Now i need to create a Receipt for this order using the API. I have tried to follow this post without any success. https://help-2021r1.acumatica.com/(W(10))/Help?ScreenId=ShowWiki&pageid=24c68cc6-6985-4421-86c9-e29156f3c150This is a sample of what i have tried.Endpoint : https://<baseurl>/entity/Default/18.200.001/PurchaseReceipt{    "Type": {        "value": "Transfer Receipt"    },    "Warehouse": {        "value": "DP@RAM"    },    "Details": [        {            "TransferOrderType": {                "value": "TR"            },            "TransferOrderNbr": {                "value": "INRDP000002"            },            "TransferOrderLineNbr": {                "value": "1"            },            "TransferShipmentNbr": {                "value": "INRDP000002"            },            "ReceiptQty": {                "value": "1"            },    

Hi Experts,II’m trying to test Acumatica’s OAuth Authorization flow using Postman. I already created a Client in the Connected Applications screen, and set the flow to Authorization Code. Also I got the access token after I called the authorize api.I can call the OData service successfully as below.But when I call the web service to get sales orders with the access token, I always get a message “You are not logged in.” Here is the screenshot.Do we still need to call LogIn api again when we call the web service with access token?Thanks in advance!

I’m looking for some general direction.  I need to create 3 or 4 forms to be embedded on our public website where users can submit and it goes directly into Acumatica (possibly kicking off a workflow).  The form might also contain the fields to upload specific documents.  Any suggestions?

Good day.I am trying to create new leads via an API call.I have the following settings configured inside postman:URL: https://localhost/MyStoreInstance/entity/Default/20.200.001/LeadHTTP method: PUTParameters:$expand: Contact,Address$select: Contact/FirstName,Contact/LastName,Address/CountryHeaders:Accept: application/jsonContent-Type: application/jsonBody:{"Contact":[{"FirstName":{"value":"NewTest"},"LastName":{"value":"NewTest"}}],"Address":{"CountryID":{"value":"ZA"}}}This is just a basic PUT method to make sure that it is working. I will later add it with correct and more values.Any help would be greatly appreciatedI am receiving the following internal server error:{"message": "An error has occurred.","exceptionMessage": "The given key was not present in the dictionary.","exceptionType": "System.Collections.Generic.KeyNotFoundException","stackTrace": " at System.ThrowHelper.ThrowKeyNotFoundException()\r\n at System.Collections.Generic.Dictionary`2.get_Item(TKey key)\r\n at Microsof

Hello,I created a bill in Acumatica 2020/R1 and am trying to retrieve it via the Contract-Based REST API. I’ve tried with and without parameters like this:GET https://acumatica-dev.psfc.coop/entity/Default/18.200.001//Bill?$select=Date,Amount,ReferenceNbr,Vendor,VendorRef,Details/Description,Details/UnitCost,Details/Qty,Details/Amount,Details/Account&$expand=Detailsand this:GET https://acumatica-dev.psfc.coop/entity/Default/18.200.001//BillI get back a 200 response and empty array [] in the body.Can anyone please help me with this?

Hello,Maybe related to a problem I posted earlier about not being able retrieve a bill created in the Acumatica 2020/R1 gui:I tried to create a bill with the Contract-Based REST API, based on an http request in the integration guide:PUT https://acumatica-dev.psfc.coop/entity/Default/18.200.001/Bill?$select=ReferenceNbr,Details/POOrderNbr,Details/POOrderNbr,Details/InventoryID,Details/Qty&$expand=Detailsbody:{    "Vendor": {        "value": "V100958"    },    "VendorRef": {        "value": "123"    },    "Description": {        "value": "Bill for particular lines of a purchase order"    },    "Details": [        {            "POOrderType":            {                "value": "Normal"            },            "POOrderNbr":            {                "value": "000001"            },            "POLine":            {                "value": 1            },            "Qty":            {                "value": 5            }        }    ]}I get a 500 response and this body (edited):{ 

Hello, We’re publishing Acumatica push notifications to a Kafka topic as part of our system integration. It would help us greatly to identify push notifications that result from user actions in the Acumatica UI as opposed to actions that are performed via the API. One way to do this, I thought, would be to identify the user performing the actions, since actions performed via the API are always carried out under the same user account. Is it possible to include the name or ID of the user associated with an action in our push notifications?Thank you, Dave

Good morning, We are integrating with Acumatica via its API, and have run into a situation w/regard to postal code. In the Acumatica UI, I can create a business account without entering a postal code. It doesn’t matter which country I specify in the address fields. Via the Acumatica API, I can create a business account without entering a postal code if I specify the country as France. But if I set the country to US and don’t enter a postal code, the response is a 422 error code specifying a problem with postal code. So it seems the postal code is required by Acumatica API if country = US, but there’s no similar requirement in Acumatica UI. Can any one please shed some light on this? I don’t know where requirements like this might be configured or if there’s a way we can work around this. Thank you, Dave

Hi,Interested in knowing how I can use Acumatica API to upload data from C#. I’m looking for any step-by-step document which can explain me from the scratch like how to configure API, how to check it is ready to use or not and then how to use it. I tried to add API’s wsdl in VS project as a service reference but it gave me an error: There was an error downloading 'https://mycompany.acumatica.com/entity/Default/18.200.001/_vti_bin/ListData.svc/$metadata'.The underlying connection was closed: An unexpected error occurred on a send.Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host.An existing connection was forcibly closed by the remote hostMetadata contains a reference that cannot be resolved: 'https://mycompanyt.acumatica.com/entity/Default/18.200.001'.An error occurred while making the HTTP request to https://mycompany.acumatica.com/entity/Default/18.200.001. This could be due to the fact that the server certificate is not

I have a DAC MySOInfo defined as Child of SOOrder and another DAC MySODetail as Child of MySOInfo.If a SOOrder is deleted in Screen SO301000, I would expect that the linked MySOInfo entries are deleted and MySODetail entries, too. In fact the first Children MySOInfo are deleted but the Children’s Children MySODetail are not deleted.The DAC’s are defined like this: [Serializable] [PXCacheName("MySOInfo")] public class MySOInfo : IBqlTable { #region RecordID [PXDBIdentity(IsKey = true)] public virtual int? RecordId { get; set; } public abstract class recordId : PX.Data.BQL.BqlInt.Field<recordId> { } #endregion #region OrderNbr [PXParent(typeof(SelectFrom<SOOrder>.Where<SOOrder.orderNbr.IsEqual<orderNbr> .And<SOOrder.orderType.IsEqual<orderType>>>))] [PXDBString(15, IsUnicode = true, InputMask = "")] [PXUIField(DisplayName = "Order Nbr")

For a newly created Sales Order I want to add positiv or negativ discounds, on document and line level.Discounts by percentage work find. On document level I create a new SOOrderDiscountDetail, set Type = ‘B’, IsManual = true and DiscountPct. On line level I just set SOLine.DiscPct.But I have problems to set discounts by amount. If I set SOOrderDiscountDetail.DiscountAmt or SOLine.DiscAmt, it is set back to 0,0.The lines and discount details are created any persisted like this.SOOrderEntry.Transactions.Insert(new SOLine{...});SOOrderEntry.DiscountDetails.Insert(new SOOrderDiscountDetail{...});SOOrdeEntry.Actions.PressSave(); What is the correct way to set a discount amount on document and line level code?

Hi community,Where I work we have been using the REST API quite a lot to automate redundant tasks in Acumatica and tie some of our in house software in to it. However, I do not have a lot of experience using “Actions” aside from the “Release” button and so have come to you for help. Objective: Add a PO Receipt to an existing Bill. The Bill has already been created and is on “Hold”. I have added the “AddPOReceipt” action to my extended web service endpoint. When I POST to “AddPOReceipt” endpoint I get a 204 response to which I follow up with a GET to check the status of the request and I get a 200 response. When I look at the bill there is no receipt added to it though. What am I doing wrong? myurl = "https://4iiii.acumatica.com/entity/ManleyEndpoint/17.200.001/Bill/AddPOReceipt"jsonUpdate = { 'entity': { 'Type': {'value': 'Bill'}, 'ReferenceNbr': {'value': '006357'}, }, 'parameters': { 'ReceiptNbr': {'value': '003341'}, '

I’m following the example in Lesson 3.1 of the I310 training course.  But instead of retrieving attachments of a Stock Item, I want the attachments of a Purchase Order.  In Postman, I’m performing a GET to:https://localhost/PhoneRepairShop/entity/Default/20.200.001/PurchaseOrder/000001?$select=OrderNbr,files&$expand=files The response is: Operation is not valid due to the current state of the object. This happens for both open and closed purchase orders.   Am I missing something? 

Hello , i need to check this  default value "mode de reglément"  in customer with API.thank you for help. 

Hello Team, I hope things are going well. Could you please help me with the following question.Acumatica has the Customer Summary module. Link to the description - https://help-2017r2.acumatica.com/Wiki/ShowWiki.aspx?pageid=4d224cd8-6553-4930-872b-d667ddff891e I want to receive all Customers from this summary and their Currency Ending Balance column.But I cannot find the API to receive these Customers and their Currency Ending Balances. Could you provide a link to the API?Of course, if it is possible.

Hello Team,Could you please provide an example of the request how to update the Customer’s credit limit?Or could you provide a link to the API that describes how to update the record at the customer level?Regards,Andrew

Can you please forward me the doc link where you mention all the native rest API and its schema and all details. if we have custom fields on Sales Order like Amazon ID , how can i get same on invoice creation automatically 

Hello,I have a problem getting the value of auto-incremented field of a new inserted record.In my DAC the Id field has [PXDBIdentity(IsKey = true)]. It is the only key field.Here’s some code.MyDac newDac = graph.MyDac.Insert(new MyDac()) ;int? tempId = newDac.Id;graph.MyDac.Cache.Persist(PXDBOperation.Insert);int? newId = newDac.Id;tempId is negativ as expected. But newId is alway 0, I’d expect the real value of the newly created entry like in DB. NewDac is still in Cache.Inserted and in DirtyCashes.If I call graph.Actions.PressSave() instead of Cache.Persist() newDac.Id is updated and it moves to Cache.Cached. But I have entities in other views that should not be saved at this time.I am sure, that with other Dac classes the Id is updated after callling Persist(). Does the system check relations to other entities and and therefore may not give back the new Id in my case?How can I get the real Id of the newly inserted record without PressSave()?

Hi, I have 4 APIs, The first is POST method that posts the credentials to the CIS system and accessToken is generated(the token changes daily) which is used in the GET methods. The rest are GET methods that gets the data and imports into Acumatica. So far my code retrieves the data successful and they are in json format.How can I import this data into Acumatica?N/B The integration is permanent, not a one time thing. Data is Customer Data, Invoices and Payments.

Hi, I have extended Default/18.200.001 endpoint to include Construction SubContracts like this http://localhost/test/entity/Subcontracts/18.200.001/Subcontracts I can filter by a field from the summary like thishttps://localhost/entity/Subcontracts/18.200.001/Subcontracts?$filter=SubcontractNbr eq 'SC-000002' However, can I filter on a field in a details table?Example, Is it possible to filter by the Project field in Document Details tab in SubContracts end point? 

I have several detail grids with one master. Each detail has its own tab. The problem is the grids that are in a tab, that is not in view, are not updated when the master record changes.I’ve already done in aspx and code:MasterGrid: <px:PXGrid SyncPosition="true" KeepPosition="true" <AutoCallBack Command="Refresh" Target="tree" ActiveBehavior="True">      <Behavior RepaintControlsIDs="DetailGrid1, DetailGrid2View"               BlockPage="True" CommitChanges="False"></Behavior> </AutoCallBack> (I am unsure about Target in this case)   DetailGrid_n: <px:PXGrid SkinID="DetailsInTab" SyncPosition="True” <CallbackCommands>         <Refresh SelectControlsIDs="MasterGrid" ></Refresh> </CallbackCommands>   Graph: public SelectFrom<DetailDAC_n> .Where<DetailDAC_n.Id.IsEqual<MasterDAC.Id.FromCurrent>>             .View Details_n; BLC: _(Events.RowSelected<MasterDAC> e) {            Details_n.V

I’m looking at Endpoint version 20.200.001 and specifically the Customer endpoint. The settings indicated that this endpoint is connected to screen AR303000. Under Customer is a field defined as:BillingContactOverride, Financial → Financial Settings, OverrideBillContactBut that field isn’t on that tab. OverrideBillContact is Billing → Bill-to Address → Override, OverrideClicking Validate Entity returns a message that says it validated.Am I missing something on understanding the field mapping or is the mapping incorrect?

Hello,I need a configure screen that contains also password and store them to DB.I set the TextMode to “Password” to hide it.    <px:PXTextEdit ID="edPassword" runat="server" DataField="Password" TextMode="Password" /> But the web browser (Chrome and Firefox) fills-in the login password into this field.Is there a possibility to prevent that in code? Thanks,Michael

Hello All,I am trying to create a POAddress record from C#.But I get exception after insert that “CustomerID' cannot be empty.”This is very confusing because Customer ID Is not empty, as seen in the sample screenshot.Please tell me what I am doing wrong here?