Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / EFT format
Microsoft Dynamics GP (Archived)

EFT format

(0) ShareShare
ReportReport
Posted on by Community Member

Need a field from the EFT format function that will provide the voucher type.  There is an 'Apply to Voucher number type' which shows as INV but I need a field that will designate that the amount is negative (aka a credit)

Payment processor is wanting:

Vendor, invoice, invoice date, invoice amount, debit/credit, check number and check amount

The only thing I'm having problems with is the debit/credit field.  GP does not have negatives.  Is there any other field in GP2013 which can provide a positive/negative indicator that can be automatically put in the EFT file?  

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    RE: EFT format

    Hi Deanne,

    Have you been able to solve this issue?

    I am doing the exact same setup for Vendor Payment through a third party provider debit card system.

    Appreciate any help from all,

    Thanks much,

    Thomas S.

  • Community Member Profile Picture
    Community Member on at
    RE: EFT format

    Thanks for your input.

    Also - I do not want to create a manual process (SQL query) - I want the client to be able to create the EFT file within GP and that would be the file to send with NO additional revisions.  

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: EFT format

    Going to need to do a bit of hunting and trial by error in my 'sandbox' will post something.  I would also believe there are others that will know the answer for you right away.

  • Community Member Profile Picture
    Community Member on at
    RE: EFT format

    not silly!

    This is a third party payment processor - associated with a bank - they sign vendors up to accept payments via debit cards.  This eliminates checks and remittances from being sent.  The problem is that we need to provide the check details - all the invoices/credits/etc on the check - not just the check amount like most EFT processes.  The vendor logs onto the processor's bank site to see what invoices/credits have been paid and the funds are on their debit card.  Problem is how to designate credits!  I was using the Document Type and 1's come across for invoices, 3's for debits, 6's for checks.  But - the credit memo's come through as 1's - not 5's

    Is that as clear as mud?

  • Bill Campbell Profile Picture
    Bill Campbell 12 on at
    RE: EFT format

    Are you looking at doing EDI ?? Who are you sending the file to?

    Just looking for clarification.  If this is a silly question, sorry.

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

News and Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans