AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

Forums
AUG Forums
Everything Else
AR and AP Aged Past...
 
Notifications
Clear all

Questions AR and AP Aged Past Due reports based on doc date

 
Everything Else
Last Post by megan.friesen 5 years ago
5 Posts
5 Users
2 Reactions
2,750 Views
RSS
Joe Morris
Posts: 10
 Joe Morris
Topic starter
August 7, 2020 12:29 am
(@cotojoe)
Eminent Member
Joined: 6 years ago

Has anyone modified the standard Acumatica standard AP and AR Aged Past due reports to age the amounts based on Doc (i.e. invoice) date instead of due date?

If so I would very much like to get a copy.

 

Thanks


Topic Tags
AP Aged Past Due AR Aged Past Due AR Aging AP Aging
4 Replies
avaladez
Posts: 12
 avaladez
August 14, 2020 4:38 pm
(@avaladez)
Eminent Member
Joined: 5 years ago

I added the Invoice Doc date next to the Due Date. Just added the field ARInvoice.DocDate.

 


Reply
Michael.Barker
Posts: 28
 Michael.Barker
August 17, 2020 12:17 pm
(@michael-barker)
Eminent Member
Joined: 6 years ago

Also, we added a filter to exclude any documents that are due past the aging date so reconciliation activities are more accurate to the supporting ledgers. 


Reply
Leanne Manley
Posts: 30
 Leanne Manley
August 20, 2020 6:59 am
(@myobadvanced)
Trusted Member
Joined: 6 years ago

We can change it in Myob Advanced on the statement cycle to age by Doc date and that flows to this report, so check if u have the same.  Guess it means statement is aged the same

ARAgedSummary.xml

 

Attached is a generic inquiry though that you can use to make a report with


Reply
megan.friesen
 megan.friesen
(@megan-friesen)
Joined: 6 years ago

Estimable Member
Posts: 70
August 25, 2020 2:37 pm
Reply toLeanne ManleyLeanne Manley

@myobadvanced The option is the same in Acumatica as well (also glad to see that in 2020 R1 the default AR aging reports are date sensitive finally!) 

image

 


Reply
Tim Rodman and Leanne Manley reacted
Forum Jump:
  Previous Topic
Next Topic  
Topic Tags:  AP Aged Past Due (1) , AR Aged Past Due (1) , AR Aging (1) , AP Aging (1) ,
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,528 Topics
  • 10.9 K Posts
  • 14 Online
  • 2,412 Members
Our newest member: Peter Paasch
Latest Post: Tax on Inventory Transfer
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

  • drustorm21
Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2026 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×