Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

Vendor - Listing Report (Balance Column)

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?

  • 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,590 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

Quick Links

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

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

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans