Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Vendor payment proposa...
Finance | Project Operations, Human Resources, ...
Answered

Vendor payment proposal- is is possible to eliminate the vendors having net debit balance or zero

(1) ShareShare
ReportReport
Posted on by Sharlene Aleman 66
Hi,
 
Good day! 
When generating vendor payment proposal at D365 F&O, is there a way that vendors having net debit balance and total zero will not be shown in the list?
 
Like for example Vendor 1 have several lines in the proposal but its total is positive or debit, or Vendor 2 with items total to zero. Is it possible to eliminate(not display) them in the payment proposal?
 
Thank you in advance.
Categories:
Dynamics 365 Finance
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,759 Super User 2024 Season 2 on at
    Vendor payment proposal- is is possible to eliminate the vendors having net debit balance or zero
    Hi Sharlene, 

    Is your question answered by Alireza? If so, please mark the reply that answered the question.
     
    I do understand that every invoice will be on a different payment journal line? Are you able to summarize multiple invoices into a single payment? If that is the case, the Delete negative payments option as mentioned by Alireza will work.
     
    In case a workaround is not possible or a manual procedure is cumbersome, error-prone, or takes too much time, you can consider customizations to exclude the vendors from the payment journal. 
  • Sharlene Aleman Profile Picture
    Sharlene Aleman 66 on at
    Vendor payment proposal- is is possible to eliminate the vendors having net debit balance or zero
    Noted on this. Thanks for the update.
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,103 Super User 2024 Season 2 on at
    Vendor payment proposal- is is possible to eliminate the vendors having net debit balance or zero
    Hi,

    Using standard functionality, you can filter records by vendor account, currency, amount, etc. However, there is no standard field to filter by the total balance for a vendor.

    To address this, you need to manually apply filters to include specific vendors or exclude transactions from the vendor payment proposal.


  • Sharlene Aleman Profile Picture
    Sharlene Aleman 66 on at
    Vendor payment proposal- is is possible to eliminate the vendors having net debit balance or zero
    Hi @Alireza Eshaghzadeh thanks for the update. However the users are looking for a way to exclude those vendor that will have TOTAL positive balance or zero. Is there any way to do this?
     
  • Verified answer
    Alireza Eshaghzadeh Profile Picture
    Alireza Eshaghzadeh 13,103 Super User 2024 Season 2 on at
    Vendor payment proposal- is is possible to eliminate the vendors having net debit balance or zero
    Hi,
    You can exclude the credit notes from payment proposal on Advanced parameters by activating "Delete negative payments"

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,468 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans