Share
ReportDears,
I am trying to open a Journal Voucher, I get the message shown in the subject of this post.
Please advise how to fix this entry.
Thank you
Elie
*This post is locked for comments
You’re offline. This is a read only version of the page.
737
Dears,
I am trying to open a Journal Voucher, I get the message shown in the subject of this post.
Please advise how to fix this entry.
Thank you
Elie
*This post is locked for comments
Cause: The BACHNUMB and BCHSOURC fields was missing in GL10000.
Solution:
1. Call the journal entry number from GL10001
2. Copy batch ID from BACHNUMB (GL10001) and SET in the BACHNUMB field in GL10000
3. Mostly the BCHSOURC is GL_Normal, SET in GL10000
JV will open now.
Replace with your batch and Journal number and check.
select BACHNUMB,* from GL10000 where JRNENTRY=3695
Now check Batch Activity
select * from dynamics..SY00800 where BCHSOURC='GL_Normal' and BACHNUMB='TEST'
If you find record there, delete from this table.
Now check, if batch exists or not.verify it's not locked or marked to post.
If not then create the batch from GP.
MKDTOPST should be 0 and USERID should by ''
BCHSTTUS should be 0
if not update them.
select MKDTOPST,USERID,BCHSTTUS,* from SY00500 where BCHSOURC='GL_Normal' and BACHNUMB='TEST'
All users are logged out- user activity is empty. reconcile GL is done. Result is same same.
I guess that the transaction is corrupted due to a PC force shutdown when this window was opened. I there a way to clean it from SQL than re-enter it manually?
Elie, I would suggest now that you try to run a reconcile on the GL - reconcile of the batches is where I would start.
When you had all the users log off of GP did you have a chance to look at the User Activity window to see if there are any 'stranded' user sessions?
Post and we will continue to figure this out.
Bill, Thank you for your reply.
I asked all users to log out from GP than I tried to open this JE with no success. the same error appear.
just this JE is showing the error.
Regards,
Elie
Are there several people in the database (company) able to enter JE at the same time?
If so, is it possible that someone has a JE open at this time that is holding your record from closing or open correctly?
Check with other users and check to see that you do not have the screen open on your desktop two times.
Can you repeat this error any time you want? Is if for a single JE or is it for all / any JE number?]
Lots of questions - no real answer - but might point you in the right direction - if this helps let us know. If not, please update the thread so we can move on to solve the problem with you.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,387
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
