ACH with one payment for multiple invoices

alsol
alsol Member Posts: 243
edited 2012-08-28 in NAV/Navision Classic Client
When creating an ACH payment file in NAV (2009 R2 NA) it creates one EFT payment for each invoice. If there are several invoices for the same vendor it does not combine them into one payment. According the CTX format, it should create an addendum record with the detailed payment information but issue on transaction per vendor.

Is this supported by the standard?

Comments

  • Vjeko
    Vjeko Member Posts: 55
    Standard NAV (W1) does not have such functionality. I don't know if Swiss localized version supports this.
    (Co-)author of "Implementing Microsoft Dynamics NAV 2009"
    http://vjeko.com/
  • jglathe
    jglathe Member Posts: 639
    Hi,

    the german payment module combines the transactions to one payment. Seemed to me like standard functionality since report 393 suggest vendor payments is involved.

    with best regards

    Jens
  • alsol
    alsol Member Posts: 243
    The ACH is a part of the NA (North America) localization. I am aware that other localizations have this ability but the payment modules cannot be compared. The ACH module is based on checks, so it still creates check ledger entries even tough it exports a file for electronic payments.

    Has anyone experience with the CTX format of the ACH electronic payment in NA? The following objects are involved:

    Codeunits
    10090
    10091
    10092

    Reports
    10083
    10084
  • ISSI-tla
    ISSI-tla Member Posts: 1
    In order to have one ach record created per payment, you must create the payment journal uing the summarize vendor option when doing the suggest vendor payments. This will make one line per vendor in the payment journal for the entire payment amount with it applied to multiple invoices. We ended up creating a custom remittance advice to email to the vendor to show invoices being paid since the ach record cannot reference an invoice number.

    Teresa
  • Ravi_Prakash_Goyal
    Ravi_Prakash_Goyal Member Posts: 72
    You must have figured out the issue by now but there is a hotfix available from Microsoft.

    http://support.microsoft.com/kb/2280687/de

    Regards,
    Ravi Prakash Goyal

Categories