Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Incorrect Journal Entry Link to Sub Ledger?

Posted on by Microsoft Employee

Hi All,

We have a posted journal entry that can be viewed in Journal Entry Inquiry - the Source Document is 'SJ', but when clicking on the Source Document link, it drills down to a Payables transaction with a completely different distribution.  Just wondering if anyone else has ever seen this?

*This post is locked for comments

  • Suggested answer
    Bill Campbell Profile Picture
    Bill Campbell 22,647 on at
    RE: Incorrect Journal Entry Link to Sub Ledger?

    Can not say that I have seen this one specific in the recent months, but it can happen - not sure why, but I have heard of it and there are a few things you can try to resolve the situation.

    First, if at all possible take a backup of the LIVE database and create a TEST company so that you can work with the data in an environment that will not effect production.  Since we are not talking about changing any code or writing any kind of utility at this time, you can do this on the same SQL Server and GP Code base as you use for LIVE access.  If we progress to a point where 'code and scripts' might be employeed, you might at that point consider a TEST SQL Server installation and a separate TEST GP Code installation.

    Having taken care of the 'CYA'

    I would suggest in the TEST database that you run a full check links on the Finance and Payables modules to see if anything shakes free.  

    Secondly I would be sure to run reconciles on the Financial Year and Batches to again see if that forces anything.

    Post results when you know if these were effective.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,240 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans