cant not delete JE on Initialize Mode

(0) Share

Report

Posted on by Community Member

Hi folks,

I have version 2012

I was trying to delete an unposted JE in Solomon, but after I switched to Initialized mode, it still would not let me edit or delete.

so current status is no action and on hold.

Is it because of settings of my initialized mode? if so, how do I change?

This JE is a reversing JE of an existing one which is not owned by me

Thanks in advance,

*This post is locked for comments

I have the same question (0)

All responses (13)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

there seems to be a conflicting statement here. You say the batch is unposted which means it should have a U status. You then say it has a no action status (or a hold status) which is not the same as unposted. Please clarify the actual batch status.

If the batch is has a U status then you would need to turn on initialize mode in order to delete it but your user ID would also have to have initialize rights and delete to the 0101000 screen. If the batch status is P then it has been posted to the GL and can no longer be deleted. If the batch status is B or H then you should be able to delete it without turning on initialize mode but you have to have delete rights to the 0101000 screen. If the batch status is V then it has been deleted and does not have to be manually deleted.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

thanks Rick, that is very helpful, the JE has a H status, but the delete button is inactive on the transaction screen, any idea why?

btw, my version is 2011 not 2012

HG

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

Is this a directly entered batch or one create by another process such as an auto-reversing batch? When you pull it up on the journal transaction screen, does the orig batnbr field have something in it?

My first guess is that your user id does not have delete rights to the 0101000 screen as am H status batch should be able to be deleted provided that you have delete rights to that screen.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

it is a reversal JE that s half auto reverse i guess? i did not hit the OK button but it still generate this JE for some reason. and yes, it does have its orig batch # associated

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

If the batch has an original batch number then it was created by one of the following:

1) from an auto-reversing batch

2) from a recurring batch

3) from the 2011 feature where you can select a batch and click the button to the right of the batch number field and you selected one of the options on that pop-up screen.

the original batch number could be pulled up to see if that was a recurring batch or an auto-reversing batch should you want to know what generated this batch.

Regardless of its origin, you should be able to delete it if it is not posted unless you do not have delete rights to the journal transaction screen. I just ran a test with a user ID who did not have delete rights and the delete button on the toolbar was disabled if the user did not have delete rights but enabled if they did.

I think you need to check your rights to this screen. You could use the SYSADMIN user id and password (if you have those credentials) and try deleting this batch with those credentials. The question becomes if you really want to delete this batch or not. It sort of sounds like you think it was created by mistake and you just want to get rid of it.

Also, look at the batch type. If it is not Nonrecurring, see if you can change it to that, save the batch, pull it back up again and try the delete again.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Rick, that is very great info, I can not change the JE to Nonrecurring, dont have that right either.

But I did emailed to IT and have them fix my user right to at lease be able to delete unposted JE. Really appreciate your help.

HG

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

so looks like no one in the company has right to delete any JEs once they are created....which just sounds weird to me...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

The SYSADMIN user, if no one else, should be able to do this if the batch status is other than posted (though a U status requires initialize mode). You did not indicate that you tried it with that user ID. You would need the SYSADMIN password to do that.

You have a situation I have never encountered in my 22 years of supporting Solomon / Dynamics SL or there is another factor that we have yet to discover.

I would be willing to do a remote session with you to take a look if you are interested. I utilize a product from Citrix called GoToAssist for remote sessions so all you have to do is go to a web address once I start a session. You really have me curious as to what is going on.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

SYSADMIN user for the system or solomon? if it is for the computer, I could ask IT for the sysadmin user id and password, then log in to solomon using my own information?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Another thought. If you simply do not want this batch and its status is H then you could run the following two SQL commands:

delete from GLTran where module = 'GL' and batnbr = 'nnnnnn'

delete from Batch where module = 'GL' and batnbr = 'nnnnnn'

My concern with doing this, without diagnosing the whole issue, is that it could have side effects if the situation is not exactly as you have said.

You also said, at one time, that you could not change the batch type to non-recurring. What is the current batch type?

Was this reply helpful? Yes No

Community site session details

cant not delete JE on Initialize Mode

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates

Community site session details

cant not delete JE on Initialize Mode

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Featured topics

Product updates