All -
We're currently using GP2015 R2 (14.00.0898) and in the process of migrating our AP system to Wells Fargo iPayables Invoice/Payment Manager system. I'm in the process of creating the necessary payment files (EFT/ACH, CCR, Wires) in Dynamics GP and have encountered an problem with the Commercial Credit Card EFT file format. Because of the complexity of these EFT files, I'm having to create them as User-Defined file types.
Part of the file format requirement for this payment type is sending the invoice number being paid which can be found in the PM30300. Configuring this field in the file isn't difficult, but during my testing the data from the PM30300 table (Apply To Document Number (APTODCNM) and AppliedAmount) isn't being brought into the file and I can't seem to figure out why.
I'm sure I'm missing something simple, I just can figure out what it is.
I appreciate any help!
*This post is locked for comments
For those following this thread, I found the solution to my problem.
The file specs from Wells Fargo requires a number of records to be included for a single transaction which led me to using the IAT Addenda 1, IAT Addenda 2, etc. file types (I ended up using IAT Addenda 1 - 4 for the number of records I needed to pass). When I moved the invoice record, which was pulling the invoice number to be paid and invoice date (from the PM30300 table) to the Addenda file type, the data came in as expected.
I'd be really curious to know why the data from the PM30300 table can't be pulled into the IAT Addenda (x) line types.
Hi Heather -
The EFT files are generated after posting the payments so the PM30300 table would already be populated by the time the files are generated for the bank. I did a Google search on my issue and found several others had similar problems with GP2013 R2 so I don't know if this is a bug or something I'm not coding correctly.
Hi Sean
I am not totally familiar with the EFT formats, however it jumps out at me that PM30300 is the history tables. In theory, that should not get populated until after posting. Is the EFT exported out after posting? If so, that seems to make sense. If not, should it be looking at the payment work apply tables instead.
Cheers
Heather
André Arnaud de Cal...
292,031
Super User 2025 Season 1
Martin Dráb
230,868
Most Valuable Professional
nmaenpaa
101,156