Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

Aged Accounts Receivable (120) on a particular old date with balance filter.

Posted on by 218

In Aged Accounts Receivable (120) Report

When we see aged accounts of parties having ‘0’ balance today /on current date then it works fine using filter:

Customer (Table)-> Balance (LCY) = 0

 

Is there any filter by which we can use to see report on historical dates..

Example:

Today is 10-May-2018 & we want to see report of customer having ‘0’ balance on 31.12.17.

 

Or

Is there any other option to get Aged Accounts Receivable in Historical dates?

*This post is locked for comments

  • AshishSharma003 Profile Picture
    AshishSharma003 218 on at
    RE: Aged Accounts Receivable (120) on a particular old date with balance filter.

    Posting date is not an option in Aged Accounts Receivable (120) Report

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Aged Accounts Receivable (120) on a particular old date with balance filter.

    Hi AshishSharma,

    why you can not put report filter

    eg:

     in filter page choose

    balance : >0

    postingdate : 31/12/2017

    Thank you

  • AshishSharma003 Profile Picture
    AshishSharma003 218 on at
    RE: Aged Accounts Receivable (120) on a particular old date with balance filter.

    Its for Non Zero Balance:

    .

    .

    In Aged Accounts Receivable (120) Report

    .

    When we see aged accounts of parties having non Zero balance today /on current date then it works fine using filter:

    .

    Customer (Table)-> Balance (LCY) <> 0

    .

    .

    Is there any filter by which we can use to see report on historical dates..

    Example:

    Today is 10-May-2018 & we want to see report of customer having non Zero balance on 31.12.17.

    Or

    Is there any other option to get Aged Accounts Receivable in Historical dates?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans