Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

GL Account with Zero Current Year Balance but activity in history

Posted on by

Is there any way that i can remove an old account that I do not use anymore?

Yes there was some activity the first time the account was created in 2010 but we haven't used it since then.

I want to remove it.

How can I do that?

*This post is locked for comments

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: GL Account with Zero Current Year Balance but activity in history

    If you just don't want to see or use the account, make it inactive, uncheck the 'Allow Account Entry' checkbox and unmark all of the 'Include in Lookup' selections. That will keep it from showing up in the default lookup window for Sales, Inventory, Purchasing and Payroll transactions, but it will still show in Financial. (Just unmarking the 'Include in Lookup' will cause it to not show in those subsidiary modules, you don't have to mark it inactive for that). The other thing you could do is download a free copy of SmartSort from EthoTech, create a SmartList Favorite that excludes inactive accounts and then assign that SmartList favorite as the default Lookup. This way it wouldn't even show in the Financials Lookup.

    The SmartList assignment will slow down the lookup a bit.

    Kind regards,

    Leslie

  • RE: GL Account with Zero Current Year Balance but activity in history

    Hi Leslie,

    I thought about the remove history but that would leave me with unbalanced entries.

    I know about the combining and i don't want the history of that account being merged with another account.

    Anything else?

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: GL Account with Zero Current Year Balance but activity in history

    You could use the PSTL tools to merge it into another account. You would keep your historical transactions in the target account and the old account would disappear.  You could also use the Remove History Utility and restrict it to that single account. To do the account restriction, you need to click on the Ranges button and then select the appropriate values for each segment of your account number. Once the history is removed, you ought to be able to delete the account. If you choose to remove (delete) history, be sure to just check the Print checkbox and not the Remove checkbox to be sure the results will be what you expect.

    Kind regards,

    Leslie

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,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans