Views:

A client attempted to generate an EFT file but nothing would generate, no errors, it just wouldn't generate. This was caused by one of the vendors not having EFT information setup in GP. To find this I ran the following script. 

select * from CM20202 TRX
join SY06000 EFT on TRX.CustomerVendor_ID=EFT.CustomerVendor_ID and TRX.ADRSCODE=EFT.ADRSCODE
where EFT.EFTBankAcct is null
 

Keywords: EFT, not created