Question About Payment Issue

  • 11 February 2022
  • 1 reply

Hi there! We have been facing an issue related to Myob Advance (Accumatica) Payment.
When api is called with query parameter '$expand=OrdersToApply,ApplicationHistory', which gives us the error:

"Optimization cannot be performed.The following fields cause the error:
 \r\nOrdersToApply.AppliedToOrder: View SOAdjustments has BQL delegate\r\nOrdersToApply.OrderNbr: View SOAdjustments has BQL delegate\r\nOrdersToApply.OrderType: View SOAdjustments 
 has BQL delegate\r\nApplicationHistory.LineNbr: View Adjustments_History has BQL delegate\r\n"

Is there any solution/api/help available to get information/list of SaleOrders or Invoices on which the payment is applied.





Best answer by praveenpo 12 February 2022, 07:46

View original

1 reply

Userlevel 6
Badge +3

Hi @junaidbasit ,

We will get this error when we are trying to get All the Payment records and if any of the Expand section view contains view delegate.

We have to pass particular Payment RefNbr as filter to fetch the required details using expand.We can not fetch all the payment records with expand .



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