Skip to main content
Solved

Bulk reversal of GL subledger batches


Forum|alt.badge.img

Good day community

I need to do a bulk reversal of batches created by FA which can’t be deleted. I have posted all the batches and created an import scenario to reverse. Error message is “Batch Status invalid for processing.” Can anyone help?

 

Thank you

 

Best answer by Laura02

Hello @BarbaraPietersen23 ,

I was able to import a reversal of the Journal Transactions for IN and AR batches using this import scenario. (I don’t have any FA transactions in my testing tenant right now.)

When I added the Release action, it didn’t work - but you can easily release Balanced Batches in Finance → Release Transactions screen.  Or you could import Release process alone as a second import.

I hope this works for you.

 

Laura

View original
Did this topic help you find an answer to your question?

6 replies

Eric Ratté
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • 25 replies
  • October 5, 2024

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.


Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • October 7, 2024

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


Forum|alt.badge.img

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 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3132 replies
  • Answer
  • October 7, 2024

Hello @BarbaraPietersen23 ,

I was able to import a reversal of the Journal Transactions for IN and AR batches using this import scenario. (I don’t have any FA transactions in my testing tenant right now.)

When I added the Release action, it didn’t work - but you can easily release Balanced Batches in Finance → Release Transactions screen.  Or you could import Release process alone as a second import.

I hope this works for you.

 

Laura


Forum|alt.badge.img

Hi Laura

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


Forum|alt.badge.img+8
  • Semi-Pro I
  • 715 replies
  • October 7, 2024

Hi @Laura02 Thats a great fix!


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings