web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Adding vendor id to vr...
Microsoft Dynamics SL (Archived)

Adding vendor id to vr_01620

(0) ShareShare
ReportReport
Posted on by Cherie Kane 639

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

I have the same question (0)
  • Verified answer
    Mark E Profile Picture
    Mark E 6,451 on at
    RE: Adding vendor id to vr_01620

    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)

  • Cherie Kane Profile Picture
    Cherie Kane 639 on at
    RE: Adding vendor id to vr_01620

    Thank you Mark - that worked perfectly!

    Cherie

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans