Develop Integrations with Web Services | APIs

I'm trying to fetch the user-defined-field that I added in Customer Entity but it's not working. I'm getting this error: "message": "An error has occurred.", "exceptionMessage": "The column 'Document_AttributeCWCID' is not found in the data set.",It is working in Contact entity and SalesOrderMy sample parameter in Contact $custom = Contact.AttributeCWCIDIn SalesOrder: $custom = Document.AttributeSOID

Hi,I’m trying to integrate Cybersource Secure Acceptance as a new Processing Center in Acumatica,My problem is that after creating the processing center and after adidng payment method, when I go to pay a sales order , it’s not showing authorize or capture option and work as if it’s offlice payment method, see this screenshothere is what I did in creating my paymen pluginCreated a customization project in that project I created a class that implment ICCProcessingPlugin and I added all the settings and based on it I was able to create the payment processor and ad dpayment method attached to it. I created another class that implement ICCHostedPaymentFormProcessor , this is where I’m adidng the form that will be used to implement the payment form where the user enter his card details , I implemented the method “HostedFormData GetDataForPaymentForm” I created class to implmenet ICCTransactionProcessor but I’m not sure if it’s required or notWhat I expected when I go to create payment for S

Is it possible to notify a user with an on screen message when a business event’s condition is met? The use case is to display a message to the warehouse receiver when receiving an item that has a attribute set for special storage conditions such as Allergen, SDS, COA.

I have a custom button on a grid and want it to be enabled only for certain rows.Therefore I implment the RowSelected event and use SetDisabled(false).That seems to have no effect. Pressing the button after selecting a row where the action should be disabled is still possible but causes an error message saying the button is disabled.What do I have to do to get the button shown correctly as disabled? Some Code:ASPX:<asp:Content ID="cont1" ContentPlaceHolderID="phDS" Runat="Server">    <px:PXDataSource ID="ds" runat="server" … >        <CallbackCommands>                     <px:PXDSCallbackCommand Name="Discard" DependOnGrid="grid" ><asp:Content ID="cont2" ContentPlaceHolderID="phL" runat="Server" RepaintOnDemand="false">    <px:PXGrid ID="grid" runat="server" DataSourceID="ds" SkinID="Details" >…       <ActionBar >            <CustomItems>                <px:PXToolBarButton Text="Discard">                    <AutoCallBack Command=

Hi,I used the screen “Web Services Endpoints” then menu “… > Service Definition > Open API 2.0” to generate the swagger.json file.This is for the Acumatica: "/entity/Default/23.200.001" collectionI then processed that through the openapi-generator to generate a java client:java -jar openapi-generator-cli-7.8.0.jar generate -i [domain]entity/Default/23.200.001/swagger.json?company=[company] -g java --api-package [mypackage].finance.acumatica.openapi.client --model-package [mypackage].acumatica.openapi.client.model -o testoutput --skip-validate-specThat generates the java client .java files.  These all compile to .class files without any errors.So this all looks good so far.  This is industry standard for generating a client from swagger.json data.  However when I run the client I get an error.  The client makes a request to acumatica for data like:                        VendorApi va = new VendorApi(apiClient);                        List ids = new ArrayList();                    

Hello all, I need to Nightly update 200-500 Projects Tasks to Completed and then Run the Allocation through the REST API. Works great for 1 project 1 task. But I will need to many each night. Is there a way to batch them in instead of 1 call to ProjectTask and 1 to run the Allocation?  IS the REST API not the best way to do it? Thank you

Hi,I’m trying to filter out Project Tasks via my API query but so far haven’t been able to get this to work correctly. So far, I’ve tried filtering like this:“VisibilitySettings/TimeEntries eq 'true'”and“VisibilitySettings/TimeEntries eq true” For both of these filters, I will still get back ProjectTasks whose TimeEntries Visibility settings are equal to “false”. Is this possible to do?

My company has implemented integrated for UPS, however, we find that our discount with UPS is not applying. What could be causing this glitch and how can it be fixed?Acumatica’s Integrated Shipping Cost Our Expected Rate

I use $expand to examine an existing Sales Order:https://sandbox.com/entity/Default/22.200.001/SalesOrder/WB/WB00162584?$expand=FinancialSettings,BillToContact,BillToAddress,ShippingSettings,ShipToAddress,ShipToContact,Details,TotalsHowever, the Details JSON doesn’t include Subaccount.  Do I need to expand something else to see it?  I want to be able to create another details line and include the Subaccount but I’m not sure what to use.

When viewing a Blanket Order in the Acumatica UI, a tab is displayed which lists the children of that blanket order. Is there any way to fetch this list of orders using the REST API?Thank you.

Hello Community!!,Using SalesDemo, I am trying to add/update One Line item in Appointment Details with ActualQty, having Line type as "Non-Stock Item" through Postman PUT call using the “Appointment” EndPoint. Add Scenario: If the ActualQty is not included in the JSON request or if added as null then ActualQty is saving as 1.00 by default. But when I try to insert any value for ActualQty field I am getting an error as "exceptionMessage": "An error occurred during processing of the field Qty: Specified cast is not valid..".Update scenario: If the ActualQty is not incuded in the JSON request then the other fields are updating with out any error. If the ActualQty value is null then getting "error": "'BaseEffTranQty' cannot be empty.; 'BaseEffTranQty' cannot be empty.; BaseEffTranQty: 'BaseEffTranQty' cannot be empty.". Tried including the BaseEffTranQty but no fields are udpating. If the AcutalQty has any value such as 2, 2.0, 2.000000 or “2” then getting an "exceptionMessage": "An error

Hi, is it possible to overlap logo’s in Report Designer.  So I have a large company logo and the client wants the smaller accreditation to sit on top of the Company Logo.  Is this possible? Regards,Laura

I’ve seen the endpoint for this but not the the rest of the api.  Anyone know where we can access the full api vs. just the few examples from the integration site?Thanks!Melissa

I don’t see anywhere in Acumatica how we can link attached file in a product with Shopify to have that file visible in Shopify. I only see Media for URL, image or video link.Is there a way to have something to link pdf file like manual or spec sheet that could be set in Acumatica and be visible in shopify for customer, instead of doing it manually in Shopify?Is seems that “Files” on top of page of an article can’t be associate with Shopify,.. and I was curious to see how we could publish them because we have demand for… or if I must put it as suggestion.

I want to create a bill related to a subcontract. I am able to create bill for PO receipts but can not create for subcontract using the same steps.I have added SubcontractNbr and SubcontractLine in the Bill.Details entity like  After that if a bill is created through Subcontract via “CREATE AP BILL” button and we try to GET that bill through API, we get these fields (SubcontractNbr and SubcontractLine) in the response. But when we try to add these data while creating bill through PUT request, the items are not linked to the Subcontract. Payload:{ "Vendor": { "value": "20119" }, "VendorRef": { "value": "IX00614958-C" }, "Date": { "value": "04/06/2024" }, "VendorDocDate": { "value": "04/06/2024" }, "BranchID": { "value": "TESTCOMPAN" }, "DocDesc": { "value": "V004651-2" }, "CashDiscountDate": { "value": "04/06/2024" }, "PostPeriod": { "value": "06-2024" }, "DueDate": { "value": "02/06/2024" }, "Amount": { "value": 750 }, "Details": [

Good day,I am trying to add an invoice in the Documents to Apply tab for a Credit Memo on the Payments & Applications (AR302000) screen via the API endpoint: {{base_url}}/entity/{{endpointName}}/{{endpointVersion}}/PaymentWhen I push through the applicable payload, I get the following error message: “The document is out of the balance.; curyOrigDocAmt: The document is out of the balance.”The slight mind scratcher here is; suppose I open the credit memo on the Payments & Applications screen and then manually click the Load Documents button on the screen, let the system load the invoice, and then save. If I remove that line, save it again, and then push through the same API request, I don’t get an error and the invoice shows up on the Documents to Apply tab.What would be wrong with my initial attempt at adding this invoice line to the credit memo’s Documents to Apply detail section?Request:{ "Type": { "value": "Credit Memo" }, "ReferenceNbr": { "value": "FT

Hi Team,We have a requirement as we create a receipt via API calls and there is a User Defined Field tab in the form level on how to create and update those fields in the receipts screen through the API calls, can you please review and suggest the best way possible to achieve it.Thank you!

Hello Community!I’m researching a way to send an API call FROM Acumatica TO a third-party endpoint. I’ve read through the I310 course document and I’m not seeing what I’m looking for.Example flow: User clicks a button on a screen, API call goes out, data is returned to the screen.Could anyone please point me in the direction of the right documentation or any resource that could assist?Few quick notes:We are on 2024 R1 Build 24.108.0034Our tenant is hosted in the cloud (I do not have back-end access)I’m familiar with API and Postman, just not how to send from Acumatica Thank you,Justin Long

I have a project with two tasks on it. Both tasks are active. I am using REST API to mark the task as complete. I keep getting an error that says “The Complete Button is disabled”This message is misleading as the button is very much enabled on the UI.Please see screenshots. Call from PostmanComplete button on task. 

I’m trying to create AP Bill Payment by REST APII found that I can do it with “Check”, but it doesn’t work for me - may somebody have experiance with AP Payments and can say what I’m doing wrong.One of my API requests: PUT http://***/entity/Default/20.200.001/Check HTTP/1.1Accept: application/jsonUser-Agent: OpenAPI-Generator/1.0.0/csharpContent-Type: application/json{"ApplicationDate":{"value":"2024-09-08T00:00:00"},"CashAccount":{"value":"10011"},"Description":{"value":"Test"},"Details":[{"AmountPaid":{"value":15.0},"DocType":{"value":"Bill"},"ReferenceNbr":{"value":"TEST002"}}],"PaymentAmount":{"value":15.0},"PaymentMethod":{"value":"CHECK"},"PaymentRef":{"value":"Test001"},"Type":{"value":"Payment"},"Vendor":{"value":"V100"}}All my attemts finish with an error like: “exceptionMessage=The system failed to commit the Adjustments row.”

As part of our integration, we push time activities for the customer from our system into Acumatica. We currently are hitting this error for one specific customer, and are unclear as to how to fix it. Other customers do not run into this, so I’m wondering if it is something to do with the customer’s specific setup? Inserting 'Time Activity' record raised at least one error. Please review the errors. Employee: Employee 'E00001' cannot be found in the system. ProjectID: Project '5360' cannot be found in the system. Please verify whether you have proper access rights to this object. ProjectTaskID: Project Task 'T160LB' cannot be found in the system. I’ll note that we cannot view the “Employee Time Activities” screen on Acumatica with the user we have used to connect Acumatica to our application. Also, I’ve confirmed that the Employee ID, Project ID and Project Task ID all exist in Acumatica.

 I am trying to create a payment and apply it to a select Invoice. When I attempt it, I get the error message “The system failed to commit the Adjustments row.” Would love it if someone could help point out what I’m missing here. Below is a slightly edited version of the JSON request body...{ "ApplicationDate": { "value": "2021-01-16T00:00:00.000+05:00" }, "ApplicationHistory": [], "AppliedToDocuments": { "value": "73.07" }, "CardAccountNbr": { "value": "8888" }, "CashAccount": { "value": "" }, "CreditCardProcessingInfo": [], "CurrencyID": { "value": "USD" }, "CustomerID": { "value": "7656TSGDB" }, "Description": { "value": "" }, "DocumentsToApply": [ { "AmountPaid": { "value": "73.07" }, "BalanceWriteOff": { "value": null }, "CustomerOrder": { "value": "" }, "Description": { "value": "" }, "DocType

For General: SOAP has GeneralPrimaryContact, GeneralAccountInfo, GeneralAccountAddress, GeneralAccountInfoPhoneType1, GeneralAdditionalAccountInfoPhone1Type, GeneralAdditionalAccountInfoExtRefNbrFor Billing: SOAP has BillingBillToInfo, BillingBillToAddressFor Shipping: SOAP has ShippingShipToInfo, ShippingShipToAddressWhere are these in REST?  Do I need to $expand something to have access?  What are the names?Also, what the difference between a MainContact and PrimaryContact?

How is it possible to invoke the “Create Child Orders” action using the REST API?

Hi Acumatica community,This is more for my personal interest/because I like to understand things.  I figured a long time developer might know. In-between when I initially sat I320 and when I’m redoing it now, the guidance in the course changed.The new guidance is to send 1 request, with a double expand if you’re retrieving records from. So I have 2 questions:When did the guidance change? Why did the guidance change? (Technical perspective) I spend a fair amount of time explaining reasons for choices to implementers/developers, and while I’ll certainly follow I320 it helps to understand why the guidance changed. Screenshot of i320 Question: Suppose you need to retrieve detail lines & shipment lines of multiple sales orders.