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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

EFT File Format - Add Document Number to format

(0) ShareShare
ReportReport
Posted on by

I am trying to add the vendor's invoice number (document number) in the voucher entry screen to an EFT file format.  The tables available to select a field from in the EFT file format menu do not include the vendor's invoice number.  The paid history table (assuming PM30200) has a voucher field and a document number field.  The doc number field for the payment transaction will always be the check # because the transaction is a payment (vs a voucher which would include the vendor's invoice#).  I am using the PPD+file format and adding fields to the detail section of the file.  The remittance that prints when posting the EFT payments is accurate, I just need to capture it in my EFT file.

I am trying to create a file from GP that will show all of the data on a check and the check stub in a bank format to send to the bank.  We have outsourced the check printing function to our bank.

GP version 10.0

*This post is locked for comments

I have the same question (0)
  • Tim W Profile Picture
    2,925 on at

    I did not set this up for a full run in test to try it, but I believe you can get to the field you want from the tool by selecting

    Table Name: Pm Apply To History File (PM30300)

    Field Name: Apply To Document Number (APTODCNM)

    Which gives me the Vendor Document Number from the voucher when I query it.  Even if that works though I think you might have other issues as by design one check could pay many vouchers so not sure what would happen if you set it up this way if it takes first or repeats each row.. sorry just don't know.  Perhaps that does not apply to you.

    We have a custom tool to build our EFT XML as we pay many vouchers per check and had to hit a format from the bank which also builds a remittance so I don't use the EFT mapper from GP but it looks like you can grab that field to me.

    Good luck

    Tim

  • Suggested answer
    Community Member Profile Picture
    on at

    Thanks!  I am able to add that field to the addenda line (using PPD+) file format but I cannot get that field to be included in the generated EFT file format.  Since I'm working in 10.0, I am using the MS suggested work around to get the check remittance data (doc date, doc number, etc) on the EFT file.  The suggested work around is to build the batch with one check per invoice.  Still unable to get the doc number from the PM30200  table (APTODCNM) to actually show up on generated EFT file.

    Could this be due to an Addenda record indicator?  Am I missing something on the set up to get the addenda records to be included?

    support.microsoft.com/.../en-us

  • Community Member Profile Picture
    on at

    We are having the same issue in GP2013 - odd that we can query the PM30300 table and see the APTODCNM value in that table  - but even with the batch set to one check per invoice the EFT file does not pick that field up -- maybe someone at MS can explain - is this is a bug or is there some condition to get that to show up?  

  • Community Member Profile Picture
    on at

    Hi I am having issues with that and the addenda sequence number which is loading with only zeros in fields 84-87 and this a calculated field in GP called Addenda record indicator (unless that is the incorrect selection for that calculation?)

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…

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans