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