Announcements
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
Thank you all for prompt replies!! Now, I got the point.
Regards,
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.
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" .
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156