Skip to main content
Solved

Cash Account Reconciliation Issue

B
Freshman I

Hi,

We have a cash account that needs to be reconciled. It has been sitting on hold since 1/31. When clicking on it in Reconciliation Statements it times out and won’t load the transactions. I checked the

CAReconEntry.CATranExt table and there are over 7400 unreconciled transactions. Is there a max number it can reconcile?

Also, there is a clearing account tied to the cash account. Could this be causing an issue? The clearing account does not have reconciliation required checked but the cash account does. Only one of the two charges methods in the clearing account are listed in the cash account also. Could this be causing the issue?

Last question, the periods are closed since the last reconciliation date was 1/31. Do we need to reopen the periods in AR to get these reconciled? Could this be the issue?

 

Thanks so much! Your wisdom is appreciated!

 

 

Best answer by Laura02

Hello @brutherford ,

Congratulations on your first post in Acumatica Community. 🙂

I do not think Clearing Accounts are causing the problem. For a small test, temporarily disconnect the Clearing Account from the main cash account in Banking → Cash Accounts screen, Clearing Accounts tab.

I do not think Closed Periods are causing the problem. For a small test, ask the Financial Supervisor to reopen the periods back to January temporarily.

I’m not aware of any maximum number of reconciliation transactions. I’ve completed high volume reconciliation statements, particularly when helping recently migrated customers with their very first bank reconciliation statements, including customers who migrated GL in detail from a prior system.

Is there any error or more information available in Tools → Trace?

Do you see the same behavior in bank reconciliation screen when all customizations are temporarily un-published?

Have you tried the same screen when logged on as Admin user and while logged on from a different computer?

What is your Acumatica version?

 

 

Laura

 

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

2 replies

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

Hello @brutherford ,

Congratulations on your first post in Acumatica Community. 🙂

I do not think Clearing Accounts are causing the problem. For a small test, temporarily disconnect the Clearing Account from the main cash account in Banking → Cash Accounts screen, Clearing Accounts tab.

I do not think Closed Periods are causing the problem. For a small test, ask the Financial Supervisor to reopen the periods back to January temporarily.

I’m not aware of any maximum number of reconciliation transactions. I’ve completed high volume reconciliation statements, particularly when helping recently migrated customers with their very first bank reconciliation statements, including customers who migrated GL in detail from a prior system.

Is there any error or more information available in Tools → Trace?

Do you see the same behavior in bank reconciliation screen when all customizations are temporarily un-published?

Have you tried the same screen when logged on as Admin user and while logged on from a different computer?

What is your Acumatica version?

 

 

Laura

 

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Click my logo to Follow me ~
Chris Hackett
B
2 people like this
  • Chris Hackett
    Chris Hackett
  • B
    brutherford
B
Freshman I
  • brutherford
  • Author
  • 4 replies
  • November 20, 2024

I apologize about the delayed response, the issue was a bug and was fixed by Acumatica expediently. If you experience the same issue and are on a version less that 2024 R1, upgrading would fix it or there is a patch Acumatica can apply.

Laura02
Chris Hackett
2 people like this
  • Laura02
    Laura02
  • Chris Hackett
    Chris Hackett

Reply


Most helpful members this week

Terms & ConditionsCookie settings

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
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 — 2024  Acumatica, Inc. All rights reserved