Microsoft Dynamics NAV (Archived)

Vendor - Listing Report (Balance Column)

(0) Share

Report

Posted on by Sunny2014

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

All responses (3)

Answers (2)

Sunny2014 on at

Like (0)

Report

RE: Vendor - Listing Report (Balance Column)

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

Regards,
Verified answer

azelaya59 2,807 on at

Like (0)

Report

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 3,594 on at

Like (1)

Report

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" .