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 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

I have the same question (0)
  • Bill Campbell Profile Picture
    Bill Campbell 12 on at

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

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

  • Community Member Profile Picture
    Community Member on at

    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

    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

    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.  

  • Community Member Profile Picture
    Community Member on at

    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.

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
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans