I’m trying to create an square invoice from my jotform submission for the 75% balance due a week before an event date. There is no field to add the amount in the invoice and is also saying that Failed to create an invoice in Square Cannot create invoice, order cannot have existing payments. I guess it’s because the order ID, but don’t know how to fix that.
Thanks.
Hi
For us to have more info about what you are referring to post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings visible along with the encountered errors.
Review all the info below as there are a few issues with the Zap step configuration.
TIP: Click field labels to see tooltips with more info.
For the Zap step Square Create Invoice
The Order ID field expects the ID of a Square Order, rather than what appears to be the Jotform Submission ID.
So you will likely need to add another Zap step to find the Square Order in order to the Square Order ID to map.
Field: Payment Due Date
Issue: need a space between the mapped variable and “-7d”, which also needs to be corrected. (change from “-7days”)
Help links for using the proper date/time modifiers:
The Date of Sale field variable looks like it needs to be remapped.
Feedback from AI about the error:
The error message in the screenshot:
Failed to create an invoice in Square
Cannot create invoice, order cannot have existing payments
This means that Square does not allow invoices to be created for orders that already have payments associated with them. An invoice is essentially a request for payment, so if Square detects that the order already has been paid—either fully or partially—it blocks the invoice creation.
You're trying to create an invoice for an existing Square order that already has a payment transaction linked to it.
This could happen if the order was:
Paid in full at the point of sale
Already charged via API
Received a partial payment via another method (e.g. card on file, cash)
Option 1: Ensure you are using a new order without any payments when creating an invoice.
Option 2: If you already collected payment, you likely don’t need to create an invoice.
Option 3: Create a new order specifically for invoicing, separate from any pre-paid order.
How can I create a new order to get a new order ID?
Try this Zap action: Square - Create Paid Order
If this meets your automation logic requirements.
i have this error message: Failed to create an invoice in Square Cannot create invoice, order cannot have existing payments
Feedback from AI about the error:
The error message in the screenshot:
Failed to create an invoice in Square
Cannot create invoice, order cannot have existing payments
This means that Square does not allow invoices to be created for orders that already have payments associated with them. An invoice is essentially a request for payment, so if Square detects that the order already has been paid—either fully or partially—it blocks the invoice creation.
You're trying to create an invoice for an existing Square order that already has a payment transaction linked to it.
This could happen if the order was:
Paid in full at the point of sale
Already charged via API
Received a partial payment via another method (e.g. card on file, cash)
Option 1: Ensure you are using a new order without any payments when creating an invoice.
Option 2: If you already collected payment, you likely don’t need to create an invoice.
Option 3: Create a new order specifically for invoicing, separate from any pre-paid order.
how can i create a non paid order in zapier? so I can link my invoice to that
That may require using the Square API: https://developer.squareup.com/docs/orders-api/create-orders
Zap action: Square - API Request
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.