Solved

Odata issue when retrieving Payment

  • 15 March 2021
  • 5 replies
  • 83 views
SadokHanini
Rank
Userlevel 2

Hello, 

I’m trying to retrieve Data using Odata from Sales-order with Expand Payment

 

 

Can anyone help ? thanks :) 

icon

Best answer by Naveen Boga 15 March 2021, 23:47

View original

5 replies

Naveen Boga
Rank
Userlevel 7
Badge +17

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!!

Naveen B
SadokHanini
Rank
Userlevel 2

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

 
Naveen Boga
Rank
Userlevel 7
Badge +17

Hi Sadok,

That is Sales Order number - SO005367

Naveen B
SadokHanini
Rank
Userlevel 2

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?

 

Naveen Boga
Rank
Userlevel 7
Badge +17

HI 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

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved