Skip to main content
Solved

25R1 GI AdjgRefNbr is not Binding

  • June 1, 2026
  • 2 replies
  • 32 views
S
Freshman I

"In Acumatica 25R1 Generic Inquiry, what are the correct join fields between ARAdjust and ARPayment tables? Trying to link payments to invoices by project. AdjgRefNbr is not binding."

Best answer by nickcerri32

 

​@swhitley - I posted screenshots for how to do this in your other post, here 25R1 Tying Proj# to AR Payments | Community

    2 replies

    nickcerri32
    Captain II
    Forum|alt.badge.img+7
    • nickcerri32
    • Captain II
    • Answer
    • June 1, 2026

     

    ​@swhitley - I posted screenshots for how to do this in your other post, here 25R1 Tying Proj# to AR Payments | Community

    Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
      BenjaminCrisman
      Acumatica Employee
      Forum|alt.badge.img+4

      ​@swhitley You can use the following joins:

      Depending on which way you want the query to pull relevant details you may need the adjdDocType and adjdRefNbr or you may need the AdjgDocType/RefNbr\

      Are these not working?

        Terms & ConditionsAccessibility 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