Skip to main content
Question

filtering by SalesOrder

  • August 3, 2022
  • 3 replies
  • 55 views
L
Freshman I

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

    C
    Semi-Pro I
    Forum|alt.badge.img+8
    • ChandraM
    • Semi-Pro I
    • August 3, 2022

    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.

    Chandra M
    Chris Hackett
    L
    Freshman I
    • Leo05
    • Author
    • Freshman I
    • August 3, 2022

    yes but what will give ARAdjust?

    Chris Hackett
    Community Manager
    Forum|alt.badge.img
    • Chris Hackett
    • Acumatica Community Manager
    • October 28, 2022

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

    Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
    Terms & ConditionsCookie settingsAccessibility statement
    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