Mohammad Daoud was kind enough to build some SQL for Vendor Notifications on EFT Bank Transfer.
Mohammad R. Daoud: Vendor Notifications on EFT Bank Transfer
Payables & ReceivablesSales, Purchasing & Inventory
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.