Skip to main content
Solved

Get ApplicationHistory from Payment object

  • Jul 18, 2022 6:13 PM UTC
  • 2 replies
  • 170 views
  • Translate All

Hello,

How can I get applications for payment object with REST Api? When I try to run such a query

https://companyname.acumatica.com/entity/Sites/20.200.001.0/Payment?$filter=PaymentRef+eq+'035530'&$expand=ApplicationHistory

I got such error:

Optimization cannot be performed.The following fields cause the error:\r\nApplicationHistory.AdjustedDocType etc

Best answer by ruchikasharma23

Hi @Leo05,
        
To fix this error, you have the following options:
• If you do not need to retrieve the fields of the ApplicationHistory detail entity, you can exclude these fields and the ApplicationHistory entity from the request.
• If you need to retrieve the fields of the ApplicationHistory detail entity, you can retrieve the needed records one by one by the key fields

To learn about this error in detail and an example of the fix, you can refer to Page 18 & 28 of I320 course
https://openuni.acumatica.com/wp-content/uploads/2017/08/I320_WebServicesDataRetrievalAdvanced_2022R1.pdf

View original

2 replies

Forum|alt.badge.img+3
  • Acumatica Moderator
  • Answer
  • Jul 18, 2022 6:28 PM UTC

Hi @Leo05,
        
To fix this error, you have the following options:
• If you do not need to retrieve the fields of the ApplicationHistory detail entity, you can exclude these fields and the ApplicationHistory entity from the request.
• If you need to retrieve the fields of the ApplicationHistory detail entity, you can retrieve the needed records one by one by the key fields

To learn about this error in detail and an example of the fix, you can refer to Page 18 & 28 of I320 course
https://openuni.acumatica.com/wp-content/uploads/2017/08/I320_WebServicesDataRetrievalAdvanced_2022R1.pdf

Translate

  • Author
  • Freshman I
  • Jul 19, 2022 3:18 AM UTC