web
You’re offline. This is a read only version of the page.
close
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) / Error: Journal Entry h...
Microsoft Dynamics GP (Archived)

Error: Journal Entry has been used, please enter another.

(0) ShareShare
ReportReport
Posted on by Community Member

We have GP 2013 integrated with TMW for our driver, the system is integrated. So, the system created a batch for last payroll cycle, but when I try to posted the Batch I get the following issue "Journal Entry has been used,  please enter another."

I looked for the JE # in the Journal entry inquiry and the JE# has already been posted, so I understand that its not letting this batch post due to the JE# being duplicate. But how do I change the JE# without having to delete the batch and post it manually, and even then would that be recomended?

Any help would be appreciate it, I'm fairly new to GP.

Thanks, Patricia

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,306 on at

    Hi Patricia,

    You need to check GL10000 table Or export it in Excel use Copy Paste functionality in Finance-->Transaction-->General Journal.

    Please keep good backup before doing any table insert/update or Delete.

    Tks

  • Community Member Profile Picture
    Community Member on at

    Good Morning Sandip, thanks for the information. How do i get to the gl10000 table?

    The Batche i have issue posting has several journal entries that I am unable to post.

    Your help would be greatly appreciated. Thanks!

  • Community Member Profile Picture
    Community Member on at

    Patricia, you would need to get into the SQL tables.  If you aren't sure how to get there you might want to get with an IT person to help you out.  You can reassign the journal entry number there.

  • Community Member Profile Picture
    Community Member on at

    Great, thanks for all the help. I got this done with our IT person.

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

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