AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Acumatica Generic I...
Adding GL Account i...
 
Notifications
Clear all

Questions Adding GL Account info to Vendor Generic Inquiry

 
Acumatica Generic Inquiries & Pivot Tables
Last Post by atiu 4 years ago
3 Posts
2 Users
2 Reactions
2,162 Views
RSS
atiu
Posts: 7
 atiu
Topic starter
July 15, 2021 3:15 pm
(@atiu)
Active Member
Joined: 5 years ago

 

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.

Using 2020R2

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.

 

 


2 Replies
alconroy
Posts: 32
 alconroy
July 27, 2021 9:47 am
(@alconroy)
Eminent Member
Joined: 4 years ago

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

 

2021 07 27 14 43 21

 

2021 07 27 14 43 57

Reply
atiu reacted
atiu
Posts: 7
 atiu
Topic starter
October 1, 2021 5:30 pm
(@atiu)
Active Member
Joined: 5 years ago

Sorry for the late reply. Thanks for the information!


Reply
Tim Rodman reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,526 Topics
  • 10.9 K Posts
  • 42 Online
  • 2,338 Members
Our newest member: Shoaib Shafquat
Latest Post: Pick List report suddenly not splitting on Shipment
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • Julian Schrenzel David Edmonson
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2025 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×