D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

ACH payments in AX 2012 - how do i include credits in payments?

  • 1.  ACH payments in AX 2012 - how do i include credits in payments?

    Posted Aug 01, 2019 09:39 AM
      |   view attached
    ​good morning,

         we've recently started ACH payments in AX2012
         however, I cannot figure out how to have a payment to a vendor that includes an invoice and a credit combined on the payment...I need to remove the credit from the payment journal to process the batch (otherwise I receive an error "payment must be a debit amount > 0")
         I do not want to settle it, because we want to show on the payment advice the individual invoices / credits and amounts included in the ACH payments

    invoice 1234 for $4,000
    credit memo 7 for $100

    we'd like the ACH payment to be for $3,900, and the ACH advice to show both of those items
    if I use the "settle open transactions" function, then the payment will only show invoice 1234 was paid for $3,900.  our AP dept will be receiving questions of short-paid invoices if we went this route


    ------------------------------
    jon bartholomew
    Kayem Foods Inc.
    Chelsea MA
    ------------------------------


  • 2.  RE: ACH payments in AX 2012 - how do i include credits in payments?

    TOP CONTRIBUTOR
    Posted Aug 02, 2019 02:09 AM
    In all the ACH versions / variations I implemented in the past we used to create a SINGLE payment line per vendor, and settle/mark this line against all the invoices / credit notes of that vendor. The payment line amount would be the net total, and the payment advice we print for this payment would show all the invoices and credit notes.,

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------



  • 3.  RE: ACH payments in AX 2012 - how do i include credits in payments?

    Posted Aug 02, 2019 08:04 AM
    does something in the setup allow you to do this?​

    ------------------------------
    jon bartholomew
    Kayem Foods Inc.
    Chelsea MA
    ------------------------------



  • 4.  RE: ACH payments in AX 2012 - how do i include credits in payments?

    Posted Aug 02, 2019 09:08 AM
    We are having the same issue. Vendors with N030 payment terms will have invoices selected for a payment using due dates and if the credit note date is later than the invoices dates, the system will select invoices for a payment and omit credit note. At that point, we have no more payments to the vendor, and we are only left  with a credit on the vendor file. Is there a way to make credit notes to be picked up with the current payment, regardless when the credit note is due?

    ------------------------------
    Maria Nowak
    Controller
    Tigercat International Inc.
    Cambridge ON
    ------------------------------



  • 5.  RE: ACH payments in AX 2012 - how do i include credits in payments?

    TOP CONTRIBUTOR
    Posted Aug 02, 2019 05:48 PM
    Hi Maria,
    We are dealing with this issue through process (not automation)

    Since all credit notes are entered manually by an accountant, our guideline is when entering a credit note to override the Terms of Payment value from the default coming from the vendor (N30 in your case) to N0.

    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------



  • 6.  RE: ACH payments in AX 2012 - how do i include credits in payments?

    Posted Aug 06, 2019 07:55 AM
    Thank you, Zvika.
    We are also changing the payment terms but sometimes they gets missed.
    Too bad we are unable to automate it.

    Maria

    ------------------------------
    Maria Nowak
    Controller
    Tigercat International Inc.
    Cambridge ON
    ------------------------------



  • 7.  RE: ACH payments in AX 2012 - how do i include credits in payments?

    TOP CONTRIBUTOR
    Posted Aug 02, 2019 05:53 PM
    On the Method of Payment setup, we set the "Period" value to "Total"
    We flag all invoices and credit notes with that Method of Payment.

    When we execute the "Payment Proposal" functionality to generate the payment journal, it will create a single payment lines for all the invoices of a particular vendor.



    ------------------------------
    Zvika Rimalt
    Functional Consultant
    Vancouver BC
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role