web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
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

I have the same question (0)
  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,146 on at

    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

  • drummerboy_10 Profile Picture
    drummerboy_10 on at

    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.  

  • Verified answer
    drummerboy_10 Profile Picture
    drummerboy_10 on at

    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.  

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Victoria Yudin Profile Picture

Victoria Yudin 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans