Skip to main content

How to Link GLTran.ProjectId to PMProject table

  • April 29, 2026
  • 2 replies
  • 16 views
M
Semi-Pro II
Forum|alt.badge.img

I would like to create a generic inquiry to use in a Pivot Table, to display the GL transactions linked to active projects.

I am really struggling to link the GLTran.ProjectID to the PMProject table, I’m getting errors with both the ContractID and the ContractCD field.  Any suggestions?

 

 

2 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Naveen Boga
  • Captain II
  • April 29, 2026

​@MarciaW  Can you please share the XML format of GI here?

Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
    M
    Semi-Pro II
    Forum|alt.badge.img
    • MarciaW
    • Author
    • Semi-Pro II
    • April 29, 2026

    ​@MarciaW  Can you please share the XML format of GI here?

    My apologies for wasting everyone’s time, it was a mistake I made on another relation in the GI.  Please ignore!

      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