Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

check links analytical accounting - gp 2013

(0) ShareShare
ReportReport
Posted on by 1,912

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
    on at
    RE: check links analytical accounting - gp 2013

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

    Regards,

    SantoshG

  • Peter Muchira Profile Picture
    1,912 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
    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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Almas Mahfooz Profile Picture

Almas Mahfooz 3 User Group Leader

Featured topics

Product updates

Dynamics 365 release plans