In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Adding GL Account info to Vendor Generic Inquiry
Hello. I tried searching the forums but didn't see a specific answer to this question. So apologies in advance if this was answered already.
I would like to add to the Vendor Generic Inquiry, some GL account info.
Ex. in the Vendor GI, I'd like to add
- AP Account
- AP Sub
- Expense Account
- Cash Discount Account
- (stuff from the GL Accounts tab in the Vendor Form)
It appears that the tables I need to add do not populate in the "Add Related Table" in the Tables tab?
Thank you in advance.
You are looking for the LocationExtAddress table
Add that and join on the DefLocationID from vendor to the locationid table and you can add in the fields you are after