Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Year end closing error
Microsoft Dynamics GP (Archived)

Year end closing error

(0) ShareShare
ReportReport
Posted on by Susan Darrow 380

I get an error message during the general ledger year-end closing that says "Account Assigned to a transaction is missing".  I have followed KB 855209 to find the journal entry that does not have an ACTINDX value in the GL00100 table.  Does anybody know which table I remove the offending journal entry from?  It says to fix these remove these entries, but from what table GL00100 or GL20000?

It is a beginning balance entry made on 6/30/2012 but shows in my 2013 open year.

Thanks.

Susan

*This post is locked for comments

  • L Vail Profile Picture
    L Vail 65,271 on at
    RE: Year end closing error

    Hi all,

    I see you've got this problem solved, but just as an FYI, the GL close checks the tables against the GL00105 table for valid indexes. As has been said before, every transaction needs to have an index that exists in the GL00105 table. Of course 'blank' doesn't exist in the table.  

    The other thing that happens, is if you are closing to divisional accounts, it makes sure you have a Retained Earnings account for every division. This is true whether you have anything to 'close' to it or not.

    Kind regards,

    Leslie

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Year end closing error

    Are you importing directly into the GL20000 table as opposed to importing GL batches and posting them? If so, I would stop doing that and import into batches. This way the GL transactions will contain records with a zero value for the ACTINDX field.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Year end closing error

    We get this error message on a fairly regular basis during year end closing.  In our case the ACTINDX has always been zero and the debit amounts and credit amounts have also been zero.  I think it comes from some of our Integration Manager imports.  Our solution is to delete the transaction from GL20000 after verifying that both the debit and credit amounts are zero.

    Keith McConnell

  • Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Year end closing error

    Joshua is totally right, that is the cause of the problem according to the knowledge base article

    "The error occurs if there are transactions in the General Ledger Open table (GL20000) that have an account index value that is not present in the Account Master Table (GL00100)."

  • Suggested answer
    Josh P Profile Picture
    Josh P 2,895 on at
    RE: Year end closing error

    Hi All,

    The message is saying you are missing an account, not the transaction right? That means there should be an ACTINDX value in the GL20000 table that does not exist in one of the following: GL00101, GL00102, GL00105.

    My suggestion would be to first check all of the above GL tables for account setup to make sure the account with the specified index is missing, and if so, add the account back to the system normally if you know what the journal entry is for, and assign the account index from the GL20000 table on the transaction to the new account in all the setup tables where the new account exists.

    This way you do not have to delete a GL entry, or make a correcting entry to something that may or may not be impacting your balance sheet / P&L.

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Year end closing error

    I would suggest correcting the entry in GL20000 rather than removing the corrupted entry. Although I am not a big fan of Database correction, I wouldn't think updating the "Account Index" field would not be of any associated risk.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,730 on at
    RE: Year end closing error

    Look in the GL20000 table.

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans