Skip to main content
Solved

Replace Data on filed GI

  • Oct 16, 2024 6:54 PM UTC
  • 3 replies
  • 113 views
  • Translate All
Freshman I

Hello, me again 😅

 

In the file I'm working on, I have a situation where the warehouse for some part numbers is not displayed.
I added a formula to replace the blank spaces with the selected warehouse, but it gives it to me in the form of a number.

Is there a way to change it to text?
Can this formula be defined from the table relationship?

 

Best answer by dcomerford

Join the InSite table in your GI using the SiteID and then change it to get show the SiteCD from this table.

View original

3 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Naveen Boga
  • Captain II
  • Oct 17, 2024 4:21 AM UTC

@JavierGtz Can you please export and share this GI here?

Translate
Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    dcomerford
    Captain II
    Forum|alt.badge.img+16
    • dcomerford
    • Captain II
    • Answer
    • Oct 17, 2024 12:00 PM UTC

    Join the InSite table in your GI using the SiteID and then change it to get show the SiteCD from this table.

    Translate
    Dermot Comerford
      Freshman I
      • JavierGtz
      • Author
      • Freshman I
      • Oct 18, 2024 7:56 PM UTC

      Thanks for your answers I was able to get it working!!

      Translate
        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