Skip to main content
Solved

Linking Company/Branch information to GLTran or ARTran

  • September 23, 2026
  • 2 replies
  • 27 views
Varsity III
Forum|alt.badge.img

Hi, I’ve created a custom GI to link GLTran table to ARInvoice table. In the GI, I want the branch/company details such as address, ABN, email, etc.

The relations I did was to link ARInvoice to Branch, Branch to OrganizationBAccount > OrganizationBAccount to Address and Contact tables, but returns nothing in the GI. I’ve attached the GI I created, can you please help identify what I’m missing here? I’ve done it this way before, but this specific GI isn’t showing the details I need. Thanks for your help!

Best answer by Dipak Nilkanth

Hi ​@MarkD,

I replaced OrganizationBAccount with BAccount in your GI, as BAccount is the base DAC for OrganizationBAccount , which is a projection DAC. After making this change, the GI started working as expected and displaying Address, City, State , Email etc.

I have also updated the GI file accordingly.
 


 

2 replies

nhatnghetinh
Captain II
Forum|alt.badge.img+13
  • nhatnghetinh
  • Captain II
  • September 23, 2026

Hi ​@MarkD 

I tried removing the filtering conditions based on GLTran.BranchID, and the results now display the data.

 

 

Best Regards,

NNT

I have devoted a great deal of my time and passion to Acumatica ! 🌐https://www.linkedin.com/in/phambaotruong
    Dipak Nilkanth
    Pro III
    Forum|alt.badge.img+14

    Hi ​@MarkD,

    I replaced OrganizationBAccount with BAccount in your GI, as BAccount is the base DAC for OrganizationBAccount , which is a projection DAC. After making this change, the GI started working as expected and displaying Address, City, State , Email etc.

    I have also updated the GI file accordingly.
     


     

    Dipak Nilkanth || 2X MVP @2025 & 2026 || https://www.linkedin.com/in/dipak-nilkanth-293591102 || Acumatica Developer
      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