Finance | Project Operations, Human Resources, ...

PM - Unposted Payments - Drillback URL (dgpp://DGPB/?..) not working from external

(0) Share

Report

Posted on by bgajjar

150

Hi There,

The Drillback url from below SQL view is not working, is anyone have any idea ?

SELECT [Apply To Voucher Number] FROM [dbo].[PayablesApply_Open] WHERE Posted = 'No'

below is the one example, I tried changing DCSTATUS to 1. still not working. it should drillback to "Payables Payments Zoom" window.

dgpp://DGPB/?Db=&Srv=VM-APP&Cmp=TWO16&Prod=0&Act=OPEN&Func=OpenPMTrxNmbr&DOCTYPE=6&VCHRNMBR=00000000000000262&DCSTATUS=2&CurncyView=1&CallID=-1&TRXSORCE=&Origin=

Thanks

Bharat

Categories:

Microsoft Dynamics GP

All responses (2)

Answers (0)

bgajjar 150 on at

Like (0)

Report

RE: PM - Unposted Payments - Drillback URL (dgpp://DGPB/?..) not working from external

Hi David,

Thanks for reply, all other drill back works fine, I mean for posted and History records, only Unposted Payments are not working. you can grab Drillback url from below query and try

SELECT [Apply From Voucher Number For Drillback] FROM [dbo].[PayablesApply_Open] WHERE Posted = 'No'

Thanks

Bharat
Suggested answer

David Musgrave MVP ... 13,917 Most Valuable Professional on at

Like (0)

Report

RE: PM - Unposted Payments - Drillback URL (dgpp://DGPB/?..) not working from external

Was GP actually installed on the workstation? You might need to repair to fix the registry settings.

GP needs to be running for the URL drill backs to work.

PS: You can create your own custom URL Drill backs with GP Power Tools.