Unified Operations & Dynamics AX Forum

Expand all | Collapse all

ACH Payment

  • 1.  ACH Payment

    GOLD CONTRIBUTOR
    Posted Dec 22, 2017 09:22 AM
    Hey Guys-

    We're on AX 2012 R3 CU11 and we're trying to set up our ACH file so that it includes invoice numbers and amounts for those invoices, rather than just a total payment amount. Right now the method of payment is set up with a payment specification of CTX but the ACH file only shows the total payment amount. How does the setup need to be designed so invoice numbers and amounts are part of the ACH file? Any help would be appreciated.

    Thanks,

    ------------------------------
    Amanda Creedon
    IT Business Analyst
    Kayem Foods Inc.
    Chelsea MA
    ------------------------------


  • 2.  RE: ACH Payment

    SILVER CONTRIBUTOR
    Posted Mar 17, 2018 03:01 PM
    Amanda,

    Did you get this sorted out? If so, would you mind sharing your resolution?

    Thanks,
    Ian

    ------------------------------
    Ian Gorman, PMP
    ERP Financial Manager
    ------------------------------



  • 3.  RE: ACH Payment

    Posted Mar 19, 2018 08:26 AM
    ​Yes, please share your resolution, as we have just decided to do business ACH and want to utilize the CTX style format with invoices in addition to the personal format without invoice info.  Thanks!

    ------------------------------
    Sandra Wittrock
    Accounting Manager
    Kroll Ontrack
    Eden Prairie MN
    ------------------------------



  • 4.  RE: ACH Payment

    GOLD CONTRIBUTOR
    Posted Mar 20, 2018 11:00 AM
    Hi all,
    There isn't a way to set this up out of the box, you'll have to do a small customization.

    ------------------------------
    Ryan Sorenson
    Sunrise Technologies, Inc.
    Riverton UT
    ------------------------------



  • 5.  RE: ACH Payment

    GOLD CONTRIBUTOR
    Posted Mar 20, 2018 11:32 AM
    ​Amanda,

    We are currently not using the AX check writing format.  We use an outside platform to print our checks and to email a remittance copy of the check stub.

    I am not sure what platform you are using to issue checks, but if it is outside of AX, check with the company to see if they can provide remittances via email. It was still a small customization to link the other source to AX, but it works pretty well. Your vendors would have to supply you with an email account, but that should not be too difficult to obtain.

    ------------------------------
    Grace Gillenwater
    Accounting Clerk
    Landau Uniforms
    Olive Branch MS
    ------------------------------



  • 6.  RE: ACH Payment

    SILVER CONTRIBUTOR
    Posted Mar 21, 2018 08:01 AM
    Edited by Alex Bailey Apr 23, 2018 02:16 PM
    ​If I understand your post correctly ....

    We simply made our ACH voucher series match the number sequence of the ACH 'check' numbers. So when an ACH was generated it would be as follows

    ACH-900001
    ACH-900002

    Etc etc.

    In addition to this, we added the voucher series to the payment advice (for ACHs) report to be reflected as a 'check' number.

    Now within the payment advice you will have the invoices broken down.

    I have posted a screen shot to help explain our solution.



    This was a small customization that ended up working extremely well. We plan to have it automated so once the payment is processed, the corresponding vendor will receive the email of the payment advice, referencing their invoices to the payment.

    If you should need any direction to implement this customization, feel free to contact me directly and I'll be glad to help anyway possible.

    Hope it helps.

    ------------------------------
    Alex Bailey
    Accountant
    ATMC
    ------------------------------



  • 7.  RE: ACH Payment

    SILVER CONTRIBUTOR
    Posted Mar 21, 2018 09:27 AM
    We are interested in looking at using CTX with a nacha file format that supports containing invoice numbers and invoice amounts.  Some vendors insist in this being in the file rather than just sent by email as our current use of ACH in AX does.

    ------------------------------
    Brad Reeves
    Supervisor - Financial Accounting
    Bill And Hillary Clinton National Airport
    Little Rock AR
    ------------------------------



  • 8.  RE: ACH Payment

    TOP CONTRIBUTOR
    Posted 5 days ago
    ​Resurrecting an old thread there, but did anyone ever find a solution to this? One of the benefits of the CTX format is supposed to be that you can include the remittance details on addenda lines within the ACH file format, but I can't find anything about for either AX 2012 or D365FO. It does sound like there isn't a stock solution, but has anyone implemented a solution of some kind?

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------



  • 9.  RE: ACH Payment

    TOP CONTRIBUTOR
    Posted 4 days ago
    ​I have added this enhancement to the D365FO ideas page. If this feature would be beneficial to you, please give it an upvote over there.

    https://experience.dynamics.com/ideas/idea/?ideaid=aee8afee-4b47-e911-867a-0003ff68a873

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------



  • 10.  RE: ACH Payment

    TOP CONTRIBUTOR
    Posted yesterday
    Hi all,

    I do see the CTX option in D365 - I cannot say when it was released, nor have I tested it, but thought I'd throw it out there.



    ------------------------------
    Shirley Adams
    ------------------------------



  • 11.  RE: ACH Payment

    TOP CONTRIBUTOR
    Posted 13 hours ago
    ​Yes, CTX has been an option. The problem is that the CTX file format supports sending remittance details as addenda lines. However, the current implementation of it in AX/D365 does not, and we're seeing more vendors pushing for remittance information to be sent that way rather than as a separate remittance advice via email or fax.

    ------------------------------
    Steve Latta
    Accountant
    Ortec, Inc.
    Easley SC
    ------------------------------