Skip to main content
Solved

Adding GL Account info to Vendor Generic Inquiry


  • Freshman I
  • 4 replies

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.

 

Best answer by wfilipiak67

@atiu,

The GL Accounts are in the Location Table.

You’ll need to do a link to the CR.Location table using the defLocationID from the VendorR parent.


 

 

View original
Did this topic help you find an answer to your question?

4 replies

wfilipiak67
Captain II
Forum|alt.badge.img+3
  • Captain II
  • 98 replies
  • Answer
  • July 15, 2021

@atiu,

The GL Accounts are in the Location Table.

You’ll need to do a link to the CR.Location table using the defLocationID from the VendorR parent.


 

 


Naveen Boga
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3393 replies
  • July 16, 2021

Hi @wfilipiak67  We might need to add BAccountID condition as well otherwise we may get end up with duplicate records. 

Hope this is helpful.

 


Forum|alt.badge.img
  • Jr Varsity III
  • 30 replies
  • January 23, 2023

Hi there, I also has same question about how to add the GL account. I able to see the AP account follow above steps. However I can’t find the expense account-VexpenseAcctID- in the result grid. Could you help? Thank you.  

 

 

 


Forum|alt.badge.img
  • Freshman II
  • 12 replies
  • March 15, 2023

Ver 2020R2 and Brand New to Acumatica - 2 weeks into implementation….

Followed steps but hung up on getting Child Table = Location - when creating new Left join Relationship - Suggestions ?

 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings