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

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Deleting journal entries
Microsoft Dynamics GP (Archived)

Deleting journal entries

(0) ShareShare
ReportReport
Posted on by Community Member

Good Evening -

I am getting an error closing the fiscal period, 'Account assigned to transaction is missing'.  I've created a report to identify the problem postings; however, what would be the recommended method for deleting the journal entries that are missing accounts (there are several pages of them)?

Thanks so much!

Mary

*This post is locked for comments

I have the same question (0)
  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,617 Super User 2025 Season 2 on at
    Re: Re: Re: Re: Re: Re: Deleting journal entries

    Hmmm, since they're already posted, you won't be able to edit them via the front-end.  I would go directly in the database (GL20000 or GL30000, whichever is appropriate) and make the changes there.

    Be sure you backup the database before making changes.  In fact, testing it first in a test db would be advisable.

    Good luck,

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Re: Re: Deleting journal entries

    Hi,

    I'm not so lucky... those transactions were originally imported and it looks like there was a problem that was never resolved with the import.  Then a while later someone noticed the ledger was out of balance and imported a second time, apparently, deliberately removing the account numbers on the line items that imported correctly the first time.  So, now I have two posted transactions (journal entries) that are out of balance and offset one another, which is why everything appears to be in balance now, but I can't close the year.   So, I'll either need to remove those two journal entries and re-enter the correct beginning balances, or I'll need to edit them to add account numbers.  If I can edit them I would create a 'clearing account' and add that number to all the missing line items and in theory it should net to zero???

    Thanks!   

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,617 Super User 2025 Season 2 on at
    Re: Re: Re: Re: Deleting journal entries

    Mary,

    I'm making an assumption here that someone at one time tried to post these transactions and they wound up in Batch Recovery.  If that's the case then go Tools>Routines>Batch Recovery and recover the batches in question.  Then you'll be able to edit the transactions and re-post.

    Hope this helps,

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Re: Deleting journal entries

    Good Evening,

    I have gone back in and looked at the journal entries in detail and I think I see a pattern to what happened and why I am not out of balance on my trial balance.  At this point I like your idea much better and would like to just 'edit' the journal entries to add an account number to them rather than deleting them.  What would be the best way to go about doing this?  I'm using SQL 2005 with SQL Managment Studio and GP 10. 

    I really appreciate your assistance with this!

    Mary

  • Community Member Profile Picture
    Community Member on at
    Re: Re: Deleting journal entries

    Hi - thanks for responding! 

    The error we're getting is closing the 2008 fiscal year, it won't let us and is saying 'Account Assigned to Transaction is Missing'... I looked up the error on Microsoft's techknowledge and followed the instructions there to create a report to find the orphaned journal entries and then it advised to delete them. 

    I know that there was a LOT of data imported into this file originally and there has also been some connection / posting issues.  When I run a trial balance everything looks good and is balances so I was assuming (you know what they say about that) that these journal entries were not being looked at anyway....

  • Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,617 Super User 2025 Season 2 on at
    Re: Deleting journal entries

    Mary,

    Are you sure you want to delete the JEs?  Why wouldn't you want to correct the missing accounts and post them instead?

     

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans