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 11 days ago
    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 10 days ago
    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 9 days ago
    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 9 days ago
    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 9 days ago
    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 9 days ago
    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 9 days ago
    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
    ------------------------------