Recently I had a chance to look into a post
on the Microsoft Dynamics GP newsgroup where the consultant required the ability to upload hundreds of payments into PayPal as a business process using the EFT for Payables module.
At first, I thought the issue was more related to the interfacing abilities with PayPal, but soon discovered this was not API-related -- PayPal also provides an API that can be called via web services.
It turns out, PayPal allows its customers, in its simplest form, to upload a mass payment tab-delimited text file containing the email of the payee or recipient, the amount to be paid, currency, a unique identifier for the recipient (which can easily be the vendor ID from GP), and a note or transaction description. For more information on PayPal's formatted file click here
Knowing this, the first limitation with EFT Payables is its ability to generate tab-delimited files. However, it does provide the ability to create fixed length files and XML files which can certainly be converted to tab-delimited with either Microsoft Excel. Nonetheless, I decided to explore what it would take to implement PayPal and here are the steps I came up with.Setting Up the EFT Payables Options for PayPalNOTE
: the following steps are for Microsoft Dynamics GP v10. However, they can easily be adapted for previous releases.
1) Setup a…