Skip to main content
Solved

Import Settlement Batches - Pending Review


Jeff96
Captain II
Forum|alt.badge.img+4

I’m having an issue with a Import Settlement Batch that is in the pending review status. It seems that everything is correct on it, but I can’t create a deposit.

Best answer by Jeff96

Finally got an answer from Acumatica. This is a known issue when upgrading.

 

Known issue: In Acumatica ERP 2021 R2, customer refunds created for deposited AR payments were not shown on the Bank Deposits form | Community

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

14 replies

Kandy Beatty
Captain II
Forum|alt.badge.img+16

Hi @Jeff96 

Are you getting any errors?

Here are the steps to create a deposit, is this how you are doing the process?

To Create a Bank Deposit for a Settlement Batch

The created bank deposit has the On Hold status if the Hold Transactions on Entry check box is selected on the Cash Management Preferences (CA101000) form and the Balanced status if the Hold Transactions on Entry check box is cleared.

  1. Open the Import Settlement Batches (CA507000) form.
  2. On the All Records tab, find the needed batch in the table, and click the link in the Reference Number column. The system opens the batch on the Settlement Batches (CA307000) form.
  3. On the form toolbar, click Create Deposit. The system creates a deposit and inserts its identifier, which is a link, in the Bank Deposit box of the Summary area.
  4. Click the link in the Bank Deposit box.
  5. The system opens the Bank Deposits (CA305000) form in a pop-up window, where you can review the settings of the bank deposit.
  6. Optional: To take the bank deposit off hold, click Remove Hold on the form toolbar.
  7. To release the bank deposit (which you can do if it has the Balanced status), click Release on the form toolbar.

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • August 9, 2023

Hi @Jeff96 were you able to find a solution? Thank you!


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • August 10, 2023

Hi, 

 

I didn’t find a solution, this is now a case with Acumatica Support. 

I did find more info on what the issue is. It seemed like certain refunds had the original payment batch attached to them, so that threw off the system. We’re still investigating how this is possible since the refund was made days after the original payment. 


Forum|alt.badge.img+9
  • Semi-Pro I
  • 714 replies
  • August 10, 2023

Hi @Jeff96 Please post the error message to review. If the transaction was already added to a Bank Deposit Batch the system will not allow you to create again. Were you able to see all other refunds on the Bank Deposits before.

Thanks


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • August 10, 2023
ChandraM wrote:

Hi @Jeff96 Please post the error message to review. If the transaction was already added to a Bank Deposit Batch the system will not allow you to create again. Were you able to see all other refunds on the Bank Deposits before.

Thanks

There is no error message. The batch is simply in pending review mode with nothing to do to it. 

Most refunds are not on deposits till we create them with the batch settlement. 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • August 29, 2023

Hi @Jeff96 were you able to find a solution? Thank you!


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • August 30, 2023
Chris Hackett wrote:

Hi @Jeff96 were you able to find a solution? Thank you!

No. This is still being investigated by Acumatica. 


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • Answer
  • September 18, 2023

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2640 replies
  • September 18, 2023

Thank you for sharing the known issue with the community @Jeff96!


Forum|alt.badge.img

@Chris Hackett The KB article references 2021 R2, but my customer is experiencing the same issue as @Jeff96 was above. There is a Settlement Batch in a status of Pending Review, and there is no option to Create Deposit. They are on 2023 R1 Build 23.108.0020. I will be contacting Acumatica Support for a script, but I’m wondering how to prevent this issue in the future. Thanks!


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • February 28, 2024
kristybrooks83 wrote:

@Chris Hackett The KB article references 2021 R2, but my customer is experiencing the same issue as @Jeff96 was above. There is a Settlement Batch in a status of Pending Review, and there is no option to Create Deposit. They are on 2023 R1 Build 23.108.0020. I will be contacting Acumatica Support for a script, but I’m wondering how to prevent this issue in the future. Thanks!

I don’t think there is a fix. We have three settlements every day, and every day we have broken ones. It seems like no one at Acumatica is paying attention to this.


Forum|alt.badge.img

@Jeff96 what is your resolution? Does the same script work to fix each one?


Jeff96
Captain II
Forum|alt.badge.img+4
  • Author
  • Captain II
  • 246 replies
  • February 28, 2024
kristybrooks83 wrote:

@Jeff96 what is your resolution? Does the same script work to fix each one?

They don’t provide you with the script, they do it themselves. We had to open tickets for each batch. We stopped using the feature for now. 


Forum|alt.badge.img

@Jeff96 that’s an extreme disappointment. This is the best tool for my customer to handle 1,000’s of credit card transactions per bank deposit. Thanks for the info.


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