web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / check links analytical...
Microsoft Dynamics GP (Archived)

check links analytical accounting - gp 2013

(0) ShareShare
ReportReport
Posted on by Peter Muchira 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

I have the same question (0)
  • Verified answer
    Community Member Profile Picture
    Community Member 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

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

    Hi Santosh,

    Many thanks, option 2 got me sorted out.

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

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

    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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans