Skip to main content
Question

Discrepancy in GL and AR Aging

  • June 20, 2025
  • 4 replies
  • 80 views
G
Jr Varsity II
Forum|alt.badge.img

Hi,

The GL is showing the AR balance in CAD and USD as below, but the actual totals (as per the attached file) differ significantly.

Additionally, the balance as of today is showing a large discrepancy and appears in the negative. Could you please advise on the possible reasons for this issue?

 

Please note current CAD balance in GL is negative

 

 

4 replies

meganfriesen37
Captain II
Forum|alt.badge.img+12
  • When was the last period that balanced?  Did it ever balance?  (if not, then you’ve likely got issues going back to go-live)
  • Are your AR GL accounts marked as control accounts and are manual entries allowed?
    • If manual entries are allowed, this will cause discrepancies.  Check for any entries in the AR accounts coming from the GL module (or any other non-AR module)
  • Since you have multiple currencies, have you revalued your foreign currency transactions already?  What I have found is that the AR reports will balance prior to revaluation, but after revaluation they may not.
  • Sometimes the summary tables get out of whack.  Have you tried running “Recalculate Customer Balances”?
Megan Friesen, Contego Software Solutions, Canada
Chris Hackett
G
Jr Varsity II
Forum|alt.badge.img

 

  • When was the last period that balanced?  Did it ever balance?  (if not, then you’ve likely got issues going back to go-live)
  • Are your AR GL accounts marked as control accounts and are manual entries allowed?
    • If manual entries are allowed, this will cause discrepancies.  Check for any entries in the AR accounts coming from the GL module (or any other non-AR module)
  • Since you have multiple currencies, have you revalued your foreign currency transactions already?  What I have found is that the AR reports will balance prior to revaluation, but after revaluation they may not.
  • Sometimes the summary tables get out of whack.  Have you tried running “Recalculate Customer Balances”?

Thanks Megan,

 

Chris Hackett
Community Manager
Forum|alt.badge.img
  • Chris Hackett
  • Acumatica Community Manager
  • September 23, 2025

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
G
Jr Varsity II
Forum|alt.badge.img

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

Hi ​@Chris Hackett, 

 

No, we have a question with the client, but we can't resolve it.

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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