By using this website, you agree to our Terms of Use (click here)
Hi,
I found adding the Contact and Address relatively easy to on the AR side Invoices and Memos GI, but the same logic does not appear to work on the AP side (unless I am missing something).
AR had ContactID and AddressID held against the invoice which made it easy.
AP does not have these columns available. Any thoughts?
Thanks!
Add 2 tables to your GI: PX.Objects.CR.Address & PX.Objects.CR.Contact
Link these 2 tables to your Vendor table (screen shots below)
This will give you access to the address and primary contact info fields:
Thanks so much for the help Megan!!
I believe I am working with an older version of Acumatica.
It did appear that I had to add the "bAccountId" in each join as well, but adding those 2 tables worked.
@robcushen I was doing it in 2020R2. In both 2020R1 and 2020R2 there were some pretty major changes to the Customer/Vendors/Contacts and Leads screens compared to prior versions which makes some things easier, but makes some of the joins a little trickier
Online Members
