Payables & Cash Management

Get Involved. Join the Conversation.

Topic

    Ratna Elete
    Is Invoice-Number available in Payments Instructions xml...Answered
    Topic posted November 7, 2019 by Ratna EleteBlue Ribbon: 750+ Points, tagged Payables 
    21 Views, 2 Comments
    Title:
    Is Invoice-Number available in Payments Instructions xml document and can be sent to Bank in ACH Addenda Record?
    Summary:
    Can Invoice-Number be sent in ACH Addenda Record, is it available in Payment Instructions xml document
    Content:

    We have a requirement to send the invoice-number in the ACH Addenda record.

    Looking at the payment xml file, invoice-number is not available.  

    How do we send invoice-number without doing a huge customization.

    Did anyone sent invoice-number in the ACH Addenda record?

    Version:
    19C

    Best Comment

    Glen Ryen

    Hi Ratna,

    The AP Invoice Numbers are there in the payment extract, under /OutboundPaymentInstruction/OutboundPayment/DocumentPayable/DocumentNumber/ReferenceNumber.  But are you looking to send one addenda record per payment (CCD+) or multiple (CTX)?  The latter is more flexible, but also more complicated to code.

    Glen

    Comment

     

    • Glen Ryen

      Hi Ratna,

      The AP Invoice Numbers are there in the payment extract, under /OutboundPaymentInstruction/OutboundPayment/DocumentPayable/DocumentNumber/ReferenceNumber.  But are you looking to send one addenda record per payment (CCD+) or multiple (CTX)?  The latter is more flexible, but also more complicated to code.

      Glen

      • Ratna Elete

        Thank you Glen.  

        Excellent.  It worked like a charm.

        We are doing 1 addenda per payment.

        I see payment reference number, instruction reference number for respective fields but for invoice they just labelled it referencenumber, don't understand why it was not prefixed with invoice like other reference numbers.