Small and medium business | Business Central, N...

Suggested Vendor Payments- Missing Invoices

(0) Share

Report

Posted on by Eugene M

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.

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

All responses (6)

Answers (0)

Eugene M 5 on at

Like (0)

Report

RE: Suggested Vendor Payments- Missing Invoices

Hey

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

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

Thanks

Eugene
AlessandraPanda on at

Like (0)

Report

RE: Suggested Vendor Payments- Missing Invoices

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 5 on at

Like (0)

Report

RE: Suggested Vendor Payments- Missing Invoices

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)

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.

Thanks

Eugene M
Eugene M 5 on at

Like (0)

Report

RE: Suggested Vendor Payments- Missing Invoices

Hey Josh

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

Thanks

Eugene
Suggested answer

AlessandraPanda on at

Like (0)

Report

RE: Suggested Vendor Payments- Missing Invoices

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.
Suggested answer

JAngle 89 on at

Like (0)

Report

RE: Suggested Vendor Payments- Missing Invoices

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.