Finance | Project Operations, Human Resources, ...

EFT Batch did not pickup all the EFT Vendors Invoices

(0) Share

Report

Posted on by Robert Yao

492

Hi All,

Did anyone run into a situation that an EFT batch (Build Payment Batch) which did not pickup all the EFT vendor invoices? The EFT settings are looked fine in Checkbook and vendor side.

Thanks,

Rob

Categories:

Microsoft Dynamics GP

All responses (6)

Answers (0)

Suggested answer

Cheryl Waswick on at

Like (0)

Report

RE: EFT Batch did not pickup all the EFT Vendors Invoices

Hello Robert,

I agree with Joseph to check to see if you require prenotes in the checkbook setup, and if so, verify if the skipped vendors have been prenoted or not on their vendor card. (see 'OPTION 1' in the below link to KB 945955 on how to check this.)

Other things to check:

• The country code and bank country/region fields do not match between the vendor and the checkbook. (see 'OPTION 2' in the below link to KB 945955 on how to check this.)

• Another thing to check is to make sure the 'REMIT TO' address ID on the vendor card is the address ID set up for EFT. Check to see what address ID was used on the invoice (VADCDTRO columns in the PM20000 table.)

• If the vendor has some address ID's with EFT banking information and some without, and documents keyed under each, then the check batch should be built first, and then the EFT batch second, in that order. (Read the last bullet point under 'Q21' at the end of KB 945955 in the Q&A section.)

http://support.microsoft.com/help/945955

Hope that helps you more. The KB has all the EFT troubleshooting information in it, so is a good read.

Cheryl Waswick

Microsoft Dynamics GP Support
Joseph Markovich 3,900 on at

Like (0)

Report

RE: EFT Batch did not pickup all the EFT Vendors Invoices

Hi Rob-

I'd verify the EFT settings in payables and also the settings for each of the vendors.

Compare one that isn't getting skipped with one that is getting skipped. Is it consistent? You may even want to compare the information using a query in SQL Server Management Studio. 'select * from SY06000' and look at one of the vendor records that is OK and one that is not and see if anything looks different.

The first thing that comes to my mind is the prenotes haven't been generated for the vendors GP is skipping. Is that set up as a requirement in the PM EFT setup?

There is also this very large EFT guide I found:

docs.microsoft.com/.../guidelines-generate-eft-files

I hope some of this helps.

Joe
Robert Yao 492 on at

Like (0)

Report

RE: EFT Batch did not pickup all the EFT Vendors Invoices

Hi Lucas,

I am testing in a test environment, do you think the DEXSQL or SQL Profiler will provide some info? They just told me now even with new vendor created might have same skipping issue.

Thanks,

Rob
Lucas Reuss on at

Like (0)

Report

RE: EFT Batch did not pickup all the EFT Vendors Invoices

Hello Rob,

You may want to spin this up in a test company and see if you can reproduce the issue with these particular Vendors in a new check run. If the issue continues, you may want to open a support ticket to work on this further if you have not found a particular setup difference between the Vendors that are working and the ones that are not.

Regards,
Robert Yao 492 on at

Like (0)

Report

RE: EFT Batch did not pickup all the EFT Vendors Invoices

Hi Lucas,

Thanks for your reply. The batch did not stop when I build it up but I do think it skip some EFT vendors, I did try to delete all the existing batches and just create a new batch for EFT to test but it skipped some of them. I think there might be something settings wrong in those EFT vendors setup. I compared those working and not working which I cannot see different in SY06000. I think it will work with newly created vendors, some vendors are not working they told me might be integrated from IM. Any clue?

Thanks,

Rob
Lucas Reuss on at

Like (0)

Report

RE: EFT Batch did not pickup all the EFT Vendors Invoices

Hello Robert,

Did the Build Payment Batch stop at a certain vendor and not continue any further, or did it skip over various EFT Vendors and then still continue on building payments for others? If it stopped and did not continue forward, I would say this is more likely due to an interruption of some kind.

If you delete the batch and try again, does the same issue occur? Or were these already posted? If they were already posted, and you attempt to create a new batch by filtering to the Vendor IDs that did not work, do the payments create successfully?

You can also refer to the information found in the Dynamics GP Docs site for PM EFT Setup found linked below to check on the setup.

docs.microsoft.com/.../payablesmanagement

I look forward to your update!

Thank you,