could someone know any formula can ID to full name from Inquiry
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/01dfbc00-6852-4bc2-990e-73f09477bdbd.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/e476a7b3-52f3-40b3-969d-29c6d069a130.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/c3a14a16-6e68-410d-b1de-e21b03539a31.png)
Best answer by pandachan48
View originalcould someone know any formula can ID to full name from Inquiry
Best answer by pandachan48
View originalAs I said, you need to with BAccount table and get the Customer Name just like below.
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.
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!!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.