Skip to main content
Question

filtering by SalesOrder

  • Aug 3, 2022 9:09 AM UTC
  • 3 replies
  • 119 views
  • Translate All

Hello,

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

Forum|alt.badge.img+8
  • Semi-Pro I
  • Aug 3, 2022 11:42 AM UTC

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.

Translate

  • Author
  • Freshman I
  • Aug 3, 2022 3:06 PM UTC

yes but what will give ARAdjust?

Translate

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • Oct 28, 2022 11:06 PM UTC

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

Translate