Hello,
I’m trying to retrieve Data using Odata from Sales-order with Expand Payment
Can anyone help ? thanks :)
Solved
Odata issue when retrieving Payment
Best answer by Naveen Boga
Hi Sadok,
That is Sales Order number - SO005367
+19Hi Sadok,
Please use below URL to get the Sales Order details along with payment detils. Please find the screenshot for reference.
URL: http://InstanceName/entity/EndpointName/EndpointVersion/SalesOrder/SO/SO005367?$expand=Payments
Hope this helps!!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Hi Sadok,
Please use below URL to get the Sales Order details along with payment detils. Please find the screenshot for reference.
URL: http://InstanceName/entity/EndpointName/EndpointVersion/SalesOrder/SO/SO005367?$expand=Payments
Hope this helps!!
SO005367 this value refers to ?
thanks
+19Hi Sadok,
That is Sales Order number - SO005367
Hi Sadok,
That is Sales Order number - SO005367
Works Fine, Thanks Naveen
Can u explain to me why it’s not working with my method?
+19HI Sadok,
To get the particular Sales Order payment details, we need to pass the OrderType and Ordernbr to fetch the payment details of that Sales Order.
OrderType and Ordernbr fields are Key fields of the SOOrder table, to uniquely identify we need to pass these details.
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.