Solved

Import Settlement Batches - Pending Review

  • 17 July 2023
  • 9 replies
  • 57 views

Userlevel 6
Badge +3

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.

icon

Best answer by Jeff96 18 September 2023, 19:00

View original

9 replies

Userlevel 7
Badge +15

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.
Userlevel 7
Badge

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

Userlevel 6
Badge +3

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. 

Userlevel 7
Badge +9

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

Userlevel 6
Badge +3

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. 

Userlevel 7
Badge

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

Userlevel 6
Badge +3

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

No. This is still being investigated by Acumatica. 

Userlevel 6
Badge +3

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

Userlevel 7
Badge

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2023  Acumatica, Inc. All rights reserved