web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

How to use report Suggest Payments?

(0) ShareShare
ReportReport
Posted on by 30
Hello everyone,

I'm wondering why I don't have the option of filtering at vendor ledger entries.

Why only vendors?

I wanted to use the report to catch all vendor ledger entries have the payment form code = bank transfer.

How can I achieve that?

I have defined the payment form code in general for the vendor and now I only want to use the report to catch the entries that have a bank transfer.

Otherwise the report does not take these items with the payment form code = bank transfer.

Thank you.
 
 
 
I have the same question (0)
  • Suggested answer
    Gerardo Rentería García Profile Picture
    25,154 Most Valuable Professional on at
  • Suggested answer
    YUN ZHU Profile Picture
    95,321 Super User 2025 Season 2 on at
    Hi, Because when this report is designed, the root DataItem is the vendor. You cannot filter unless you add the field to the Vendor table.
     
    Hope this helps.
    Thanks.
    ZHU
  • Suggested answer
    KasparsSemjonovs Profile Picture
    4,762 Super User 2025 Season 2 on at
    And Vendor card has the default Payment Terms Code assigned. Unless You specifically change it often on each Invoice, this should be enough to Filter out payments to only those Vendors, where You have indicated that they have to be paid via Bank Transfer.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,329

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 2,250 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,365 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans