Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
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 Microsoft Employee

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: Journal Entry has been used, please enter another.

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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: Journal Entry has been used, please enter another.

    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 Microsoft Employee on at
    RE: Error: Journal Entry has been used, please enter another.

    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!

  • Suggested answer
    sandipdjadhav Profile Picture
    sandipdjadhav 18,265 on at
    RE: Error: Journal Entry has been used, please enter another.

    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

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