Problem with Jotform and Square Recurring Payment Integration Creating Weird Invoice ID's

  • vnhsmpa
    Asked on April 19, 2024 at 7:11 PM

    This is a screenshot of my Invoices in Square. The invoices are all created from Card on File charges from a Subscription setup through a JotForm. The $10 and $5.45 charges yesterday and today are from this form:

    https://form.jotform.com/vnhsmpa/annual-giving

    The $2.37 and $51.95 charges are from this form:

    https://form.jotform.com/vnhsmpa/monthly-payments

    I also clicked the Create Invoice within Square and it automatically assigned the next sequential invoice number 000013 (see second screenshot). It seems like something changed with the Jotform/Square integration since 3/25/2024 where its pushing a long unique ID (that gets put in the email receipt and is very messy from the consumer side). Is it possible that this problem is on the Square side? or did something change on the Jotform side recently?

    I'm not certain on how the integration works and if Jotform does something on the scheduled day each month, or it does it once and then the subscription lives completely in Square? If that is the case, then maybe the issue is on the Square side with their Subscriptions creating Invoices.

    Problem with Jotform and Square Recurring Payment Integration Creating Weird Invoice IDs Image 1 Screenshot 30

    Problem with Jotform and Square Recurring Payment Integration Creating Weird Invoice IDs Image 2 Screenshot 41

  • Rhina JotForm Support
    Replied on April 19, 2024 at 8:24 PM

    Hi vnhsmpa,

    Thanks for reaching out to Jotform Support. When a payment is made, the user is routed to the Square payment processing page directly. The transaction ID's are generated by Square. Please reach out to Square directly regarding the different transaction ID format. If you want to view the Transaction ID on your Tables page, this is possible. Let me show you how:

    1. Choose one of the submissions that you want to view and click on the Three Dots icon.
    2. In the list that comes up, click on View Entry.

    This is how the Transaction ID format appears on our end:

    Problem with Jotform and Square Recurring Payment Integration Creating Weird Invoice IDs Image 1 Screenshot 20

    Reach out again if there's anything else we can help you with.

 
Your Answer