Skip to main content
Solved

Location is empty

  • October 28, 2025
  • 2 replies
  • 33 views
S
Freshman II
Forum|alt.badge.img

So, I have created this GI. I added my parameters to pull locations. After publishing to the UI, my locations field is empty. Please anyone help.

 

after i publish

 

Best answer by bwhite49

If you join to the INLocation table on INTran.LocationID = INLocation.LocationID, you can use the LocationCD field as your schema field. That should fix it. 

 

So replace INTran.LocationID with INLocation.LocationCD

 

      2 replies

      bwhite49
      Captain II
      Forum|alt.badge.img+12
      • bwhite49
      • Captain II
      • Answer
      • October 28, 2025

      If you join to the INLocation table on INTran.LocationID = INLocation.LocationID, you can use the LocationCD field as your schema field. That should fix it. 

       

      So replace INTran.LocationID with INLocation.LocationCD

       

        S
        Freshman II
        Forum|alt.badge.img
        • SandyA
        • Author
        • Freshman II
        • October 28, 2025

        ​@bwhite49 thanks a lot. this worked

          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