Develop Integrations with Web Services | APIs

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?  

I have an authentication problem with oauth2 during I did the steps well (client id, secret code ....) but when I authenticate the postman display this error in the image.thank you for help 

Hello Team, My company integrates with Acumatica, and I have a few questions:1. Could you provide a link to API on how we can send a request to Acumatica so that to update data in Acumatica.For example, we want send a request to Acumatica to update the Credit Limit.2. Can we update the Credit Limit if the Credit hold is On.Thank you,Andrew

Hello Team,Could you please provide a list of errors that the Acumatica back-end can return during the record updating request?We are going to use the API to update the Customer's Credit Limit in Acumatica.And It would be perfect if you could provide the list of back-end errors that Acumatica can return during the request.Thank you!

Hello Team,Could you help me with the following question?I try to create a payment.But receive the following error:Response: {"message":"The request is invalid.","modelState":{"entity":["The Entity field is required."]}}An error has occurred.","exceptionMessage":"Inserting  'CA Transaction' record raised at least one error. Please review the errors.\nFinPeriodID: 'Post Period' cannot be empty.","exceptionType"Could you provide a correct example of the request?

Error when I update the Customer Credit Limit Request:PUT https://{Base_URL}/Customer?$select=CreditVerificationRules&$filter=CustomerID%20eq%20'0e31e8a5-08e3-ea11-a828-000d3ab2c384' Response: {"message":"An error has occurred.","exceptionMessage":"Syntax error: character '%' is not valid at position 10 in 'CustomerID%20eq%20'0e31e8a5-08e3-ea11-a828-000d3ab2c384'Team, could you help me with this error?What I should do to eliminate the error?