Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / EFT File Format not pu...
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 drummerboy_10

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
    drummerboy_10 Profile Picture
    drummerboy_10 on at
    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.  

  • drummerboy_10 Profile Picture
    drummerboy_10 on at
    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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,735 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,466 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans