could someone know any formula can ID to full name from Inquiry
Solved
Inquiry name showing
Best answer by pandachan48
Naveen B wrote:
Hi
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.
Hope this help!!
Any formula to set on inquiry to show full name? I don’t know how to edit in database.
+19Hi
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.
Hope this help!!
Naveen B - Acumatica MVP 🏆 | Independent Developer for Hire 🚀 ⏩ https://www.linkedin.com/in/boga-naveen-kumar-54079a66/
Naveen B wrote:
Hi
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.
Hope this help!!
Any formula to set on inquiry to show full name? I don’t know how to edit in database.
+19As I said, you need to with BAccount table and get the Customer Name just like below.
Any Formula can we put here(Style) to show full of the name?
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.