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

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Journal entry hung aft...
Microsoft Dynamics GP (Archived)

Journal entry hung after power failure

(0) ShareShare
ReportReport
Posted on by Community Member

We have a journal entry that shows up on a smart list but did not get posted completely.  This was due to a power failure.  When trying to inquire the journal entry, the message is "The journal entry number you've entered doesn't exist or hasn't been posted.  Enter or select a valid journal entry number."

How can this journal entry be killed?

Thanks.

Teresa

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    mark the header record void in sql?

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at

    If you look in the GL10000 table for the header and the GL10001 for the accounts, do you find your entry there? If it was entered in a batch, the batch ID should be in the SY00500 table. Posted GL entries post to the GL20000 table, I'd check that table too for the journal entry number.

    If you find the batch ID in the SY00500 table, check the value in the fields  MKDTOPST and BCHSTTUS. Make note of what the values are and then set each of them to zero (0). After those fields are set to zero, see if you can pull it up in the GL transaction entry screen. If you can, you should be able to delete it if it originated in the GL. You could also void it if you didn't want to delete it.

    If it still will not come up in the GL transaction entry window you can, as Deanne suggested, change the value of the VOID field in the GL10000 table to 1. In addition, you should delete any rows related to that journal entry from the GL10001 table.

    If you are using MDA or Analytical Accounting or if this was an intercompany or multicurrency transaction you may have some additional cleanup to do. If this transaction came up from a subledger you might also have more work to do.

    Kind regards,

    Leslie

  • Community Member Profile Picture
    Community Member on at

    That was what I needed.  Thanks.  Teresa

  • Community Member Profile Picture
    Community Member on at

    Thank you.  I did end up changing that flag.

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

Season of Giving Solutions is Here!

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