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

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Wrong data after run c...
Microsoft Dynamics GP (Archived)

Wrong data after run check links

(0) ShareShare
ReportReport
Posted on by Refeesh Ali 5,201

Hi

 

After I run the check links some wrong account with data is showing with “Check links acct description” account description in my TB values. Kindly advice me how can I remove these accounts with data.its making my all TB and P&L wrong

Thanks,

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    Hi Refeesh,

    There are quite a number of reasons why running Checklinks against the Financial module will create these entries.  One of them would be there was data against an account that was not thoroughly removed (ie: was removed using SQL and not the right way of using the GP interface).

    The best solution, as with other master records in GP, is to check the account, verify if the transaction against it is invalid, delete if there are unposted transactions, and remove history if there are historical data.  Once you are done with that - you should be able to delete the problematic account number.

  • Suggested answer
    MattPaulen Profile Picture
    MattPaulen 6,912 on at

    I'd check GL00100 to see what the ACTINDX is for that account that Checklinks created.  Then see if that ACTINDX exists in any transactions in GL20000 (open years), GL30000 (closed years) or even GL10001 (work).  

    From what it sounds like a transaction was created for an ACTINDX that doesn't exist as an actual account and Checklinks is trying to fix that by automatically creating the account for you.

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    Hi thanks for your tips. but i just need to know how can i remove it from my db for accurate TB

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    i mean i need the querry to remove it . i try to remove it but it is posted transaction but that account not created and use by finance. how come?

  • MattPaulen Profile Picture
    MattPaulen 6,912 on at

    If it's been posted and in an open year then it will be in the GL20000.  Since it's most likely part of a balanced transaction, the whole JE would need to be deleted.  Did the transaction originate in the General Ledger or did it originate in a sub ledger?

    If you truly think it just needs to be deleted and you know the JE number you should just be able to run DELETE GL20000 where JRENTRY = 'JE#'.  However, if it's part of a large transaction I would make sure it doesn't need to be changed to a different account.  If you do run the statement to delete it, you'll want to run your financial reconcile for the year it resided in.

  • Suggested answer
    Tristan Clores Profile Picture
    Tristan Clores 2,812 on at

    Hi Rafeesh,

    If you are not familiar with runnish SQL scripts, I would not recommend directly removing it using SQL.

    It would still be best to just remove the historical transaction(s) using the GP interface and then deleting the account properly.

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    @Tristan Thor Clores : yes i am familiar to use SQL script. kindly provide me. i need to remove it from my db

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    even from sql script or direct application doesnt matter please advice the way to do it.

  • Refeesh Ali Profile Picture
    Refeesh Ali 5,201 on at

    please support

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans