Hello,
I am trying to write a GI that allows me to see the Default payment method and cash account for all vendors, and I am struggling to get there.
Would anyone know which table i need to relate in order to show that? I am using the default Vendor GI as a starting point.
Best answer by BenjaminCrisman
View original
+4
Hi
Though there is already an out of the box GI which has this join and it’s the Vendor Locations GI and Payment Method can be grabbed from the column configurator by default!
I used the following tables below. Basically copied the Vendors GI and added the CR.Location table and joined to AP.VendorR by bAccountID to bAccountID.
Hi etrojan28,
I’m trying to mirror what you did here as I would like to add the default payment method to the Vendor GI. I’m getting an error that won’t let me save the new inquiry asking me to join with the related table. Perhaps I’m missing a step. Could you post a screen shot of the Relations tab of your inquiry?
Thank you for sharing this.
+4
Hi
Thanks!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
