Bulk reversal of GL subledger batches

Hi,

When you reverse a batch manually, is the new batch status on Hold?

If the status is on Hold, you won’t be able to release it (last action).

You either temporarily change the GL Preferences to deactivate the On Hold on entry option or add an action in the import scenario to remove from hold before releasing.

@BarbaraPietersen23 Assuming, you are Saving the Batch after the Reverse action. If not, please try.

Thanks to both for the responses.

@Eric Ratté - the status is not on Hold when creating a reversal batch

@ChandraM  - I modified the scenario to include saving the batch before reversal. Still doesn’t work.

When reversing manually I see that I need to open the batch first and reverse from inside the batch but there doesn’t seem to be a command for that.

Any other ideas? I really don’t want to have to reverse all these batches manually.

Thanks 

Hi Laura

Thank you so much. It worked! You have saved me hours. 😁

Hi @Laura02 Thats a great fix!

Hey ​@Laura02 

Is your scenario works with 24R2, I tried and its throwing an error. If you can give me some light, please.

Hi ​@wimalendranrajendran92 ,

I’ve never tried to reverse an Unposted-status batch. Can you reverse a batch with Unposted status manually, in Journal Transactions screen? I expect Posting may be required, before we can reverse.

Also, I notice you are reversing a batch that came from AR. I recommend Reversing or Voiding the original document in the AR module versus reversing in GL.

Laura

HI ​@Laura02 ,

I have successfully revered the unposted batch manually, i test before starting the import. thanks for noticing that.

Yes, the original transection is from AR, but we need to nullify the GL effect. So, we are trying to do this. thanks for coming back quickly.