Open Forum

Expand all | Collapse all

Is there a fix for broken Journal Entry Inquiry links?

Jump to Best Answer
  • 1.  Is there a fix for broken Journal Entry Inquiry links?

    SILVER CONTRIBUTOR
    Posted Feb 06, 2019 09:38 AM
    GP 2013 R2

    Occasionally, when doing a Journal Entry Inquiry, I will click on the Source Document and it does not link to the correct source document. I have seen this happen most often on payables with deferral entries, but not always.

    Is there a utility or job I can run to fix the link between journal entries and source documents?

    That JE lookup link saves a ton of time, when it is accurate!

    Thanks in advance!
    Robert

    ------------------------------
    Robert Meade
    Acounting & Budget Manager
    Grace Communion International
    Charlotte NC
    ------------------------------


  • 2.  RE: Is there a fix for broken Journal Entry Inquiry links?

    SILVER CONTRIBUTOR
    Posted Feb 07, 2019 02:27 PM
    Hi Robert,

    Are you getting any error message?

    ------------------------------
    Cecile Dinh
    GPUG VA Arlington Chapter Leader
    GPUG 2018 Sapphire Awardee
    GP Admin at ARC (Airlines Reporting Corp.)
    ------------------------------



  • 3.  RE: Is there a fix for broken Journal Entry Inquiry links?
    Best Answer

    Posted Feb 08, 2019 10:51 AM
    Our team ran into this as well. We found it to be a bug with Revenue Expense Deferrals. If you use deferrals or if it is enabled you could test this by disabling the code and trying to drill to the source doc -- Disabling a dictionary in this window only effects the Dynamics instance you do it in, and it will default back to enabled when you log out and back in.

    I was not able to get information on an expected fix date from Microsoft Support but they did confirm this to be a known issue

    Status Window

    ------------------------------
    Kurt Quiggle
    Shooting Star Casino
    Mahnomen MN
    ------------------------------



  • 4.  RE: Is there a fix for broken Journal Entry Inquiry links?

    SILVER CONTRIBUTOR
    Posted Feb 08, 2019 12:24 PM
    Thanks Ken - that's the problem - as soon as I disabled the module like you showed, drilldown worked correctly.
    Guess I'll just have to wait along with everyone else until Microsoft fixes it.
    At least I'm glad to know it is not a db problem!
    #GeneralLedger
    ​​

    ------------------------------
    Robert Meade
    Acounting & Budget Manager
    Grace Communion International
    Charlotte NC
    ------------------------------



  • 5.  RE: Is there a fix for broken Journal Entry Inquiry links?

    SILVER CONTRIBUTOR
    Posted Feb 08, 2019 12:25 PM
    Nope, no errors at all. Works flawlessly, just links to the wrong drilldown. :-(

    ------------------------------
    Robert Meade
    Acounting & Budget Manager
    Grace Communion International
    Charlotte NC
    ------------------------------



  • 6.  RE: Is there a fix for broken Journal Entry Inquiry links?

    TOP CONTRIBUTOR
    Posted Feb 08, 2019 11:44 AM
    Robert,

    I would definitely check out the Revenue Deferral module bug mentioned in a response, but if you don't have RED installed, or that ends up not being the issue, you can try running check links on your GL tables to see if it restores the link back to the originating document.

    If that doesn't work, you'll have to investigate in SQL.

    In the GL20000 and GL30000 tables there are two fields:
    SOURCDOC

    so you can do a select * from gl20000 where sourcdoc = 'PMTRX' to see all the payables transactions that hit the GL.

    Then you'll want to look at the ORCTRNUM column that should have the document number in payables

    So then you check to see if the document exists in PM - replace the vchrnmbr with the orctrnum from the GL transaction:
    select * from PM30200 where VCHRNMBR = '00000000000000322 '

    If the sourcdoc and the ocrtrnum in your GL for those journal entries is missing, you'll need to populate them, linking back to the voucher number in AP or whatever module you're missing the link from.






    ------------------------------
    Rob Klaproth
    Dynamics Certified Professional
    (GP Install & Configure)
    Sr. GP Consultant
    Armanino, LLP
    San Diego, CA
    ------------------------------



  • 7.  RE: Is there a fix for broken Journal Entry Inquiry links?

    SILVER CONTRIBUTOR
    Posted Feb 08, 2019 12:27 PM
    Thanks Rob - it looks like the RED error.
    However, I did find a report under Maintenance, Check Deferral Links.
    I ran this for all systems and no errors were found, which was a nice reassurance.

    ------------------------------
    Robert Meade
    Acounting & Budget Manager
    Grace Communion International
    Charlotte NC
    ------------------------------



  • 8.  RE: Is there a fix for broken Journal Entry Inquiry links?

    Posted Feb 27, 2019 11:38 AM

    Hi Robert,

    When RED is enabled, the system tries to look at only the GL20000 (Open) table. If the Journal Entry you are drilling down to is posted in the current, open year it will work. The problem is when you are attempting to drill down on a historical year, since those transactions are stored in the GL30000 (History) table. As mentioned in other posts, when RED is disabled it works because the system then checks in the correct table, either being GL20000 or GL30000.



    As a work around this issue, you could:

    1. Temporarily disable RED in the Customization Status window (this will only disable it for your user). I would not recommend this route, since it can be easy to forget to re-enable RED.

    Microsoft Dynamics GP > Tools > Customize > Customization Status

    2. Use Smartlist to drill down to the Source Document from the Journal Entry.
    Microsoft Dynamics GP > Smartlist > Financial > Account Transactions > *

    Click on Search and enter Journal Entry > is equal to as Search Definition 1

    Click OK

    From here you can double-click on one of the Account Transaction lines and the Transaction Entry Zoom window will open. From there you can select the Source Document field to drill down to the original Source Document transaction.

     



    ------------------------------
    Samantha Corzo
    T3 Information Systems
    Washington DC
    ------------------------------



  • 9.  RE: Is there a fix for broken Journal Entry Inquiry links?

    SILVER CONTRIBUTOR
    Posted Feb 27, 2019 01:31 PM
    Thanks Samantha - that smartlist is a great alternative until Microsoft can fix it properly!

    ------------------------------
    Robert Meade
    Acounting & Budget Manager
    Grace Communion International
    Charlotte NC
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role