Skip to main content
Solved

Inquiry name showing

  • May 19, 2021 9:47 AM UTC
  • 4 replies
  • 273 views
  • Translate All
pandachan48
Jr Varsity II
Forum|alt.badge.img

could someone know any formula can ID to full name from Inquiry

 

 

 

 

Best answer by pandachan48

Hi @pandachan48,

We can not get the full name directly, as this user-defined field value only stores the ID in the database. Please find the screenshot for reference.

In order to get the Name, you need to join with the proper table. I just ran the sample example for the Customer ID.  Please find the details below.

 

Added UDF for Customer ID
Only stores ID, but not the name
I have added extra join with BAccount table to fetch the name

 

UDF: Customer ID and Customer Name

 

 

Hope this help!!

 

Any formula to set on inquiry to show full name? I don’t know how to edit in database.

View original

4 replies

Naveen Boga
Captain II
Forum|alt.badge.img+20
  • Naveen Boga
  • Captain II
  • May 19, 2021 10:19 AM UTC

Hi @pandachan48,

We can not get the full name directly, as this user-defined field value only stores the ID in the database. Please find the screenshot for reference.

In order to get the Name, you need to join with the proper table. I just ran the sample example for the Customer ID.  Please find the details below.

 

Added UDF for Customer ID
Only stores ID, but not the name
I have added extra join with BAccount table to fetch the name

 

UDF: Customer ID and Customer Name

 

 

Hope this help!!

Translate
Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    pandachan48
    Jr Varsity II
    Forum|alt.badge.img
    • pandachan48
    • Author
    • Jr Varsity II
    • Answer
    • Jul 6, 2021 6:08 AM UTC

    Hi @pandachan48,

    We can not get the full name directly, as this user-defined field value only stores the ID in the database. Please find the screenshot for reference.

    In order to get the Name, you need to join with the proper table. I just ran the sample example for the Customer ID.  Please find the details below.

     

    Added UDF for Customer ID
    Only stores ID, but not the name
    I have added extra join with BAccount table to fetch the name

     

    UDF: Customer ID and Customer Name

     

     

    Hope this help!!

     

    Any formula to set on inquiry to show full name? I don’t know how to edit in database.

    Translate
    Naveen Boga
    Captain II
    Forum|alt.badge.img+20
    • Naveen Boga
    • Captain II
    • Jul 6, 2021 6:21 AM UTC

    @pandachan48 I don’t think we can using formula.

    As I said, you need to with BAccount table and get the Customer Name just like below.

     

    Translate
    Naveen B - Acumatica MVP 🏆 | Acumatica Developer 🚀 ⏩ https://www.linkedin.com/in/naveenb-acumatica-mvp/
    pandachan48
    Jr Varsity II
    Forum|alt.badge.img
    • pandachan48
    • Author
    • Jr Varsity II
    • Jul 6, 2021 6:23 AM UTC

    Any Formula can we put here(Style) to show full of the name? 

    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