Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

check links analytical accounting - gp 2013

(0) ShareShare
ReportReport
Posted on by 1,910

When running AA check links on GP 2013, I get this error:

'Encountered Errors During Analytical Accounting Checklinks, You must first run Financial

Checklinks'.

Even after running check links for Financials successfully, the error persists.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: check links analytical accounting - gp 2013

    Your are welcome Peter, :-), Have a nice day.

    Regards,

    SantoshG

  • Peter Muchira Profile Picture
    Peter Muchira 1,910 on at
    RE: check links analytical accounting - gp 2013

    Hi Santosh,

    Many thanks, option 2 got me sorted out.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: check links analytical accounting - gp 2013

    Hi,

    Try running the Check links for Financials once again,

    if still issue persists, then following are the 3 reasons to pop this message

    1: Reporting ledgers for the Transactions might be other than BASE, IFRS and LOCAL

    Query to check -->  

    SELECT * FROM GL10000 WHERE Ledger_ID NOT IN (1,2,3) UNION

    SELECT * FROM GL20000 WHERE Ledger_ID NOT IN (1,2,3) UNION

    SELECT * FROM GL30000 WHERE Ledger_ID NOT IN (1,2,3)

    Resolution = if any records are returned please set Ledger_ID field to 0

    2: Batch is deleted but the transaction which was assigned to batch still exists

    Query to check -->

    SELECT * FROM GL10000 G WHERE G.BCHSOURC NOT IN (SELECT S.BCHSOURC FROM SY00500 S WHERE G.BCHSOURC = S.BCHSOURC and G.BACHNUMB = S.BACHNUMB)

    Resolution = either create the batch or delete the Transaction from the backend manually

    3: distribution record exists but the header record is missing

    Query to check -->

    SELECT * FROM GL10001 G WHERE G.JRNENTRY NOT IN (SELECT DISTINCT JRNENTRY FROM GL10000)

    SELECT * FROM GL10002 G WHERE G.JRNENTRY NOT IN (SELECT DISTINCT JRNENTRY FROM GL10000)

    Resolution = Either delete the Distribution records or create the header record manually

    Hope this helps,

    Regards,

    SantoshG

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans