210
Hello,
A GL batch containing 2 journal entries was posted following whihc only 1 journal appears to have posted and the other one has disappeared.
The batch is not in a recovery state and it is no longer showing in the unposted list of journals. the batch was generated from the Sales series.
How do I find the missing journal and have it posted?
Hi Jackie,
I recommend you check the GL tables to see if this journal entry exists anywhere. If you know what the journal entry number was, you can run queries similar to the following (replace XX) with the journal entry number:
SELECT * FROM GL10000 WHERE JRNENTRY = 'XX' --GL WORK HEADER
SELECT * FROM GL10001 WHERE JRNENTRY = 'XX' --GL WORK DETAIL
SELECT * FROM GL20000 WHERE JRNENTRY = 'XX' --GL OPEN TABLE
SELECT * FROM GL30000 WHERE JRNENTRY = 'XX' --GL HISTORY TABLE
If the journal entry exists in the GL10000/GL10001 tables, that means it is still sitting in WORK. You can try to pull it up in the GL Transaction Entry window (Transactions >> Financial >> General) by JE number and post it from there, or assign it to a new batch and post it that way.
If you can't find the missing JE in the WORK, OPEN, or HISTORY tables in GL, then you'll have to manually enter the JE in the GL Transaction Entry window and then post it that way. You could consider putting a note on the JE to record the reason for it (which sales document it's associated with).
Hope this helps!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (