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) / Unable to delete unuse...
Microsoft Dynamics GP (Archived)

Unable to delete unused GL Strings

(0) ShareShare
ReportReport
Posted on by Community Member

Hello

I am trying to delete a number of GL strings that were created several years ago but never used. You get the error message 'Account xxxx has account history. It cannot be deleted'.

I have run the Account Transactions smartlist for these account numbers with no results. I have also queried the index number in SSMS tables GL20000 Year-to-Date Transaction Open and GL30000 Account Transaction History and there are no results.

There is however results in table GL10111 Account Summary History for these index numbers. How is it possible for a transaction to be in this table with no associated GL transaction?

We also have an archive company which I thought perhaps GL transactions from GL20000 and GL30000 were archived, leaving a transaction behind in the main company, but only querying that database there were no transactions either.

Thankyou

*This post is locked for comments

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Unable to delete unused GL Strings

    You are most welcome Tania

    Never hesitate to share any further inquiries,

  • Community Member Profile Picture
    Community Member on at
    RE: Unable to delete unused GL Strings

    Hi Justin and Mahmoud

    Reconcile did work. The log came out with no errors but it seems to have removed the transactions in GL10111 anyway and I could delete the string.

    Thanks

  • Verified answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Unable to delete unused GL Strings

    Hello Tania

    Go to Microsoft Dynamics GP > Utilities > Financial > Reconcile

    Include the history years that shall be corrected, this will ensure to reconcile the account balances against account transactions.

    Your feedback is highly appreciated,

  • Community Member Profile Picture
    Community Member on at
    RE: Unable to delete unused GL Strings

    Hi Ian

    Thanks for your response. It says there are 2.8 millions records in Account Transaction History before I start to run checklinks on it, but when I run it the error log prints immediately with no results, it doesn't even seem like it's running anything. There is no progress bar. This seems a bit strange?

  • Verified answer
    Justin Thorp Profile Picture
    Justin Thorp 2,265 on at
    RE: Unable to delete unused GL Strings

    Hi,

    If you don't mind deleting the summary information you can manually run a query for the 1 ACTINDX in SSMS. 

    Alternatively if you want to make sure that the records in the detailed tables (GL20000 and GL30000) match what is in the summary tables (GL10110 and GL10111), then I recommend you run a reconcile on potentially all years (Tools - Utilities - Financial - Reconcile).

    Thanks,
    Justin

  • Suggested answer
    Ian Grieve Profile Picture
    Ian Grieve 22,782 on at
    RE: Unable to delete unused GL Strings

    Sounds like corruption from what you describe. May be worth running Check Links against Account Master and Account Transaction History.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,432 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans