filtering by SalesOrder

  • 3 August 2022
  • 3 replies


I have push notification for Payment adding. Payments could be invoiced or added directly to sales order and in both cases I need to filter it by SalesOrder external ref.

3 replies

Userlevel 7
Badge +9

Hi @Leo05 Please elaborate on your requirement.

Based on my understanding, In order to filter payments by Sales Order’s ext refnbr you have to left join the DACs(tables) of SOOrder, SOAdjust and ARAdjust using the BQL in your code.

yes but what will give ARAdjust?

Userlevel 7

Hi @Leo05 - were you ever able to find a solution? Thank you!


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 — 2023  Acumatica, Inc. All rights reserved