Skip to main content
Question

25R1 Tying Proj# to AR Payments

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

"In 25R1 how do I get Cash Received by Project in a GI? AR Payments have no Project ID field. Do I join through ARInvoice?"

      2 replies

      BenjaminCrisman
      Acumatica Employee
      Forum|alt.badge.img+4

      ​@swhitley Yes you’ll need to link the payment to the invoice and the invoice to the project. You can use the DAC Schema Browser (add a table to the GI and click on it to open that table’s schema) or you can use the Merged DAC Relation screen to find the best joins for the tables to make sure they are linked on key linking fields

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

        ​@swhitley You can link ARPayment to ARInvoice via ARAdjust

         

         

        Nick - If we helped give us a Like. If we answered your question, select the Best Answer option.
          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