595
To All:
I am trying to add the ID field from GLTran in order to pull in the vendor and customer ids on the Detail GL report. I thought there use to be a knowledge base article out there showing how to do this. I know the view needs to be modified and I do have access to SQL.
Any help is appreciated.
Cherie
*This post is locked for comments
Thank you Mark - that worked perfectly!
Cherie
The field you are looking for is GLTran.ID It is used for various ID's, based on the module that generated the transaction. There are 2 spots in the view to add the info:
GLTran_ID = t.Id (in the part of the view that retrieves data from the GLTran table)
and
GLTran_ID = '' (in the UNION ALL part of the view further down)
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (