I am new to GI’s. I am trying to expose the G/L accounts for the items below for the GI Inquiry under Vendors.
I also need to expose the Account e-mail field to the Vendor GI Inquiry as well.
Also, what table do I need to add below to get the above Data:
Also, what relations do I need to add to below.
Any help would be greatly appreciated?
Thanks,
Frances
Best answer by Laura02
View original
+18
Hello
There is a trick to identifying fields to add to a generic inquiry:
Click Customize, Inspect Element, and then click the field you need:
I make a list of the fields I’m adding, then use “Add related table” to cause Acumatica to join the tables for me:
I’ve also found “Add Related Table” to be a little tricky. Here are some pointers:
HTH,
Laura
Hey Frances - To find what tables and fields data is coming from hold Ctrl+Alt and then click on the field in question (alternatively, you can click Customization in the upper right corner and Inspect Element to do the same)
Half the GL accounts you’ve screen shot come from the default vendor location, the others appear to come from the Vendor table - if you follow the instructions above, you should be able to figure out which table each comes from easily.
To get the default location info, try joining PX.Objects.CR.Location as shown here
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
