Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Drilldowns SSRS Report...
Microsoft Dynamics GP (Archived)

Drilldowns SSRS Reports GP 2013 R2

(0) ShareShare
ReportReport
Posted on by kmorneau 25

I am trying to enable drilldowns to the journal entry within the Trial Balance Detail report.  I am using the  Action URL - dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournal&JRNENTRY=(Fields!JRNENTRY.Value)&RCTRXSEQ=0&DCSTATUS=1&DOCTYPE=1

For example...in the report there is a journal entry 126 that I would like to drill back to get the detail for.  When the report runs instead of evaluating the JRNENTRY.Value field as 126 (the Journal entry it represents) it just produces the link without evaluating the field.
This is what I am expecting:

dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournal&JRNENTRY=126&RCTRXSEQ=0&DCSTATUS=1&DOCTYPE=1

Buth this is what is produced

dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournal&JRNENTRY=(Fields!JRNENTRY.Value)&RCTRXSEQ=0&DCSTATUS=1&DOCTYPE=1

Additionally, if I manually override with the journal entry number and paste it into the URL. It appears as though this is invoking the Journal Entry window rather than the Journal Inquiry windows so I receive an error that the entry is already posted.  Is there a method to open the Journal Entry inquiry window in the same manner.

Any help is greatly appreciated.

*This post is locked for comments

  • Verified answer
    kmorneau Profile Picture
    kmorneau 25 on at
    RE: Drilldowns SSRS Reports GP 2013 R2

    Figured it out...see below.  Essentially this modification allows us to drill back from the Trial Balance Detail report to see the Journal entries themselves.

    This is what needs to be added to the Action - URL field:

    ="dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournalInq&JRNENTRY="&Fields!JRNENTRY.Value &"&RCTRXSEQ=0&YEAR1=2014&TRXDATE="&Fields!TRXDATE.Value

    This when run in the report yields the following link on the Journal Entry field which opens the inquiry window for the corresponding entry

    dgpp://dgpb/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournalInq&JRNENTRY=126&RCTRXSEQ=0&YEAR1=2014&TRXDATE=9/9/2014

  • kmorneau Profile Picture
    kmorneau 25 on at
    RE: Drilldowns SSRS Reports GP 2013 R2

    So...I figured out the answer to the second part for invoking the Journal Inquiry window...see below.  The additional details needed are the transaction date.

    dgpp://DGPB/?Db=GP&Srv=SRVTEST&Cmp=CMPTEST&Prod=0&Act=OPEN&Func=OpenJournalInq&JRNENTRY=126&RCTRXSEQ=0&YEAR1=2014&TRXDATE=10/24/2014

    However, I am still having the issue with the JRNENTRY.Value Field rendering when the report runs, any help would be greatly appreciated.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans