Skip to main content
Solved

Duplicate amount in AR aging report -ref 5692. We see a duplicate amount in AR report by customer. How to fix it?


Thank you.

Best answer by Laura02

Hello, 

Has the AR Aging report been customized? People in the Report Designers Role can see Report Versions tab. Please deactivate any custom report versions shown on Report Versions tab and see whether the amount is still doubled.

Example:

Laura

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

7 replies

iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 562 replies
  • July 19, 2024

@Lesia07 could you try recalculating the customer balance?

 


  • Author
  • Freshman I
  • 4 replies
  • July 19, 2024

Yes, nothing changed. Same


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 562 replies
  • July 19, 2024

@Lesia07 what version are you guys on? 


  • Author
  • Freshman I
  • 4 replies
  • July 19, 2024

Acumatica 2023 R1
Build 23.117.0021 


iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 562 replies
  • July 19, 2024

@Lesia07 thanks for sharing! this is really weird! i am not seeing anything on the known issues list for the version you are on.  when you drill into the 5692 invoice from the AR aging report, does it show you the duplicate lines or does it show the correct amount as your screenshot shows? also, is this report customized at all? (sorry for all the questions 😅)

I would recommend submitting a case to acumatica, the support team should be able to login and poke around to troubleshoot what’s going on.  


  • Author
  • Freshman I
  • 4 replies
  • July 19, 2024

We see the correct amount only in the AR Sensitive report. All records are correct, but there are problems with the AR Aging by Vendor report. When we drill into the 5692 invoice from the AR Aging report, it doesn’t show the duplicate lines. 


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

Hello, 

Has the AR Aging report been customized? People in the Report Designers Role can see Report Versions tab. Please deactivate any custom report versions shown on Report Versions tab and see whether the amount is still doubled.

Example:

Laura


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