Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

Customer ageing report with details and without details

(0) ShareShare
ReportReport
Posted on by 3,354

Hi All,

when i run the customer ageing report with details check mark it will print all the invoices. When i run the same report with details unchecked then it will print only summary no invoices.

In both the cases the invoices are grouped under buckets.

now, my issue is when  i run the report for one particular customer and uncheck the details check mark, the report will print the correct balance under balance as of coloumn but it will not print the amount in ageing buckets why so?

it prints correctly for other customers

*This post is locked for comments

  • Tony111 Profile Picture
    Tony111 4 on at
    RE: AX2012 Customer ageing report with details and without details

    Hi, 

    Where do I find this form?

  • Suggested answer
    NaveenKumar S Profile Picture
    NaveenKumar S 3,354 on at
    RE: AX2012 Customer ageing report with details and without details

    Hi, On debugging came to know that there was a customisation made, to fetch all the payments into separate column this was making the transactions to not to be displayed in the buckets.

    thanks

  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: AX2012 Customer ageing report with details and without details

    Check the origin of the transaction you will find the due date must be not lying in these buckets. Thats why it is not coming in that period range. 

  • Verified answer
    Weaveriski Profile Picture
    Weaveriski 23,616 on at
    RE: AX2012 Customer ageing report with details and without details

    That the 266277.54 is due before 1/3/2015

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,354 on at
    RE: AX2012 Customer ageing report with details and without details

    Prashant I checked it, but, when i run the report , this is what i get

    3515.Untitled.gif

    here you can see the balance amount of 2940 ia appearing in one bucket

    but for the amount 266277.54 is not appearing in any buckets whabt could be the reason

    thanks

  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: AX2012 Customer ageing report with details and without details

    1. Try to put aging definition in place of interval. Then It will come in that particular bucket. If it lies between that it should print. 

    2. Put the criteria also.

    Aging period definition: Select an aging period definition. The Interval field is not used if you select an aging period definition. Aging period definitions that have more than six aging periods cannot be used on the printed report.

    Vendor-Aging.jpg

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,354 on at
    RE: AX2012 Customer ageing report with details and without details

    one issue i faced now is, if i mention the ageing period definition, then the bucket date value changes, this is the issue

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,354 on at
    RE: AX2012 Customer ageing report with details and without details

    and if the customer has payments, the aging reports shows it under balance as of column, and it has to show under ageing buckets as well but it is not showing, however it is working fine for invoices

  • NaveenKumar S Profile Picture
    NaveenKumar S 3,354 on at
    RE: AX2012 Customer ageing report with details and without details

    i keyed in balance as of: today,

    start date: blank

    ageing period definition: blank;

    interval: 1

    day/Mth: Month

    printing direction: backward

    details: no

    but, now have got a trick, when i enter, ageing period definition then the report prints fine, but don't know the reason

    thanks

  • Suggested answer
    Prashant Singh Profile Picture
    Prashant Singh 8,797 on at
    RE: AX2012 Customer ageing report with details and without details

    Please explain your aging setup. How you are printing the aging report. Explain your selection in this form.

    Screen-Shot-2015_2D00_06_2D00_25-at-9.59.22-AM.png

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,836 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans