Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Vendor - Listing Report (Balance Column)

(0) ShareShare
ReportReport
Posted on by

Hi all,

I have a questions for vendor-listing report.

[Report path]

Departments/Financial Management/Payables

Report and Analysis section. This report is located next to "Vendor 1099 information".

This report has balance column by default. I run this report with the following date filter at Limited total to section, but balance column shows as of now balance rather than date filter I set below.

Date filter set 1) "..12/31/2018" , 2) "12/31/2018"

I run this report with same date filter set at newer version of NAV (NAV2016. MAV2017), but it does not work too. I wonder why date filter does not work. Is this bug or do we need some modification if we want report to calculate balance based on date filter?

*This post is locked for comments

  • Sunny2014 Profile Picture
    Sunny2014 on at
    RE: Vendor - Listing Report (Balance Column)

    Thank you all for prompt replies!! Now, I got the point.

    Regards,

  • Verified answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Vendor - Listing Report (Balance Column)

    Sunny

    I agree with "I Gusti Made Ari Permadi" in regards to getting a report Date Driven. I prefer the Aged Account Payable (10085). It gives me a lot of flexibility out of the box. The Vendor Listing was not designed for that purpose.

  • Verified answer
    I Gusti Made Ari Profile Picture
    I Gusti Made Ari 3,594 on at
    RE: Vendor - Listing Report (Balance Column)

    the date filter will not affect the balance (modification needed ) . If you want to get the balance by date filter  in standard way , you should run report 329 "Vendor - Trial Balance" .

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

News and Announcements

Announcing Category Subscriptions!

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 Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans