Skip to main content
Solved

Exclude Prepayments and Payments from AR Aging buckets.

  • 6 September 2024
  • 4 replies
  • 84 views

Forum|alt.badge.img

Hi,

Has anyone successfully removed prepayment and payment amounts from the calculation of the aging buckets on the AR Aging report. I have the report filtering out the prepayment and payment transactions so they do not show up on the report but those prepayment and payment amount are still showing up in the aging balances. I need to remove the prepayment and payment amounts from the aging balances. 

Thanks! 

Best answer by Laura02

Hello @etrojan28 ,

Is your report customized? Users in the Report Designer role can see the report versions tab.  Please de-activate all custom versions of your Aging report to rule out customizations as the cause of the totaling problem.

Inactivate all custom versions and then test Aging report

Did you try AR Aged Period-sensitive report?  I tried AR Aged Period-sensitive report with and without Prepayments.

With Prepayments, totals on last page:

Without Prepayments, totals on last page are increased (I still included Payments).

Laura

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

4 replies

iqraharrison
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 528 replies
  • September 6, 2024

@etrojan28 this post may help with making changes to the AR aging reports, this one is related to customer statements and excluding prepayments but it may be a good start to help modify the reports you listed

 


Forum|alt.badge.img
  • Author
  • Varsity I
  • 47 replies
  • September 6, 2024

Thanks @iqraharrison I actually dropped a comment on that thread. I have the report filtering out the Prepayment and Payments. The issue is the aging buckets are still including those amounts that are filtered out. 


Laura02
Captain II
Forum|alt.badge.img+19
  • Captain II
  • 3135 replies
  • Answer
  • September 6, 2024

Hello @etrojan28 ,

Is your report customized? Users in the Report Designer role can see the report versions tab.  Please de-activate all custom versions of your Aging report to rule out customizations as the cause of the totaling problem.

Inactivate all custom versions and then test Aging report

Did you try AR Aged Period-sensitive report?  I tried AR Aged Period-sensitive report with and without Prepayments.

With Prepayments, totals on last page:

Without Prepayments, totals on last page are increased (I still included Payments).

Laura


Forum|alt.badge.img
  • Author
  • Varsity I
  • 47 replies
  • September 13, 2024

@Laura02 

The report has minor customizations I actually copied over the stock report and I’m having the same issue on the out of box report. Detail looks great but the total in the footer still includes prepayment balances. 


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