Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

EFT File Format not pulling the PM30300 table data for Wells Fargo iPayables Payment Manager

(0) ShareShare
ReportReport
Posted on by

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

  • Verified answer
    RE: EFT File Format not pulling the PM30300 table data for Wells Fargo iPayables Payment Manager

    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.  

  • RE: EFT File Format not pulling the PM30300 table data for Wells Fargo iPayables Payment Manager

    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.  

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,144 on at
    RE: EFT File Format not pulling the PM30300 table data for Wells Fargo iPayables Payment Manager

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Congratulations to the January Top 10 leaders!

Check out the January community rock stars...

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,031 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,868 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans