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

Announcements

News and Announcements icon
Community site session details

Community site session details

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

Suggested Vendor Payments- Missing Invoices

(0) ShareShare
ReportReport
Posted on by 5

Hello

Our company has recently implemented/automated the EFT (ACH) function within D365 BC and it has been a pleasure to export the NACHA files and send out electronic remittances. The issue we just identified is that when you are in Payment Journal and want to use Prepare- Suggest Vendor Payments function, the system is not pulling in all of the invoices.

I have a crazy theory that it has something to do with the Invoice's Payment Method Code and changes on the Vendor card, as in the case below it does recommend the US EFT invoices. But I just tested my theory by changing the Vendors' card to NO Payment Method/Bank and it didn't fix the problem. 

pastedimage1595302138822v6.png

Has anyone else ran into this issue before? Any recommendations? 

I have the same question (0)
  • Suggested answer
    JAngle Profile Picture
    159 on at

    Will need to know what filters you are using when running the routine. Could be you are filtering on a specific payment method or something else. Are you the only one preparing batches? You can skip over entries that have been taken into another journal batch.

  • Suggested answer
    AlessandraPanda Profile Picture
    Microsoft Employee on at

    Hello  

    The reasons why not all the  open and due purchase invoices are not suggeted running the suggest vendor payment could be:

     A. the fiedl OnHold of the vendor ledger entry is filled 

     B. the vendor ledger entry has been applied but  the application have not been neother posted neither removed.

     Solution:

     A. you need to  edit the list select the field and remove the the content o

     B. search for Table information in the search bo, filter by Table no.  25 and select the content of the field no. of records.

         Filter List by  Open = yes and  Applies-to ID <>'' 

    Take note of the entries to remove the Applies-To Id value you have to run the Apply entry function from h vendor ledegr entry selecting a posted entry for which the Applies to ID field is blank  select the entry for which the applies to ID field is filled and run the process Set apply to ID to remove the field content. 

     To check if it is the problem  please search for Table information, filter by table no.  25 and select no of record.

    Filter list by the vendor(s) and add the filter open = yes and compare the entries.

    After that you can  remove the Applies-To Id value opening the vendor ledger entry of and selecting any entry that have no problem run the process apply to ID.

  • Eugene M Profile Picture
    5 on at

    Hey Josh

    Thanks for responding. My filters are set to include all invoices, not to review other batches or select specific payment types. 

    pastedimage1595341355646v1.png

    Thanks

    Eugene 

  • Eugene M Profile Picture
    5 on at

    Hey Alessandra

    Thanks for your response, I reviewed both options A and B and neither one of them is the case. 

    A) The Vendor Invoice Entry doesn't show the invoice to be On Hold (And there is a remaining amount which means it wasn't applied)

    pastedimage1595341743553v1.png

    B) As you can see the amount is still listed on the Overdue and Total balance of the vendor which means that no payment was applied to this invoice. 

    pastedimage1595341845428v2.png

    Thanks

    Eugene M

  • AlessandraPanda Profile Picture
    Microsoft Employee on at

    Hi Eugene,

    I did not mean that the entry was applied but the entry has just the Apply-to ID field filled, even the application has not been posted. This prevent to the entries to be suggested as vendor payments.

  • Eugene M Profile Picture
    5 on at

    Hey

    As you can see in my other reply, my filter is set to include ALL invoices even if included in other batches. 

    pastedimage1595431833233v1.png

    unless there is another area/module/work center where you are saying it could be being applied in. 

    Thanks

    Eugene 

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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,371 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,806 Super User 2026 Season 1

#3
AndrewThomas81 Profile Picture

AndrewThomas81 1,371

Last 30 days Overall leaderboard

Featured topics

Microsoft Training Manuals

Product updates

Dynamics 365 release plans