Using Zapier to try and copy information about a payment from Invoice Ninja v5 to Quickbooks Online, it seems that the “Invoice Number” the payment applies to isn’t being passed through. The Zap fails at the step where it’s finding the invoice in Invoice Ninja using the data from the payment.
The Zap data in at that step is:
include_pdf: no
_zap_search_success_on_miss: False
Fields with no value:
invoice_number
Required field “Invoice Number” (invoice_number) is missing.
So the Zap can’t continue processing in order to create the payment record in QBO because it doesn’t have the Invoice # to match against.
The “Number” field appears to be the payment number, so that’s not it. And the “Invoice_Number” field shows blank.
The Zap let’s me choose “Invoice Number” as the field on the payment to look for the Invoice Number for the next step of finding the Invoice in Invoice Ninja. But it’s blank… and looking at the Data out from the “New Payment” step, there ISN’T any Invoice Number field. There’s a “Paymentables Invoice_ID”, but that can’t be used in the “Find Invoice” step… it wants an Invoice Number.
After a delay in Step 2, Step 3 “Find Invoice in Invoice Ninja” fails with this error:
invoice_number:
{{55641683__invoice_number}}
include_pdf:
no
_zap_search_success_on_miss:
False
Required field “Invoice Number” (invoice_number) is missing.
I’ve checked and checked again that the Zap is using the new “Number” field for v5 and not the “Invoice_Number” field from v4. But it doesn’t appear to want to cooperate.
Hey @david - Hope you had a nice weekend! Just thought I’d check in to see if you had any update/info on this one. I was in Zapier earlier and I THINK it might be working, but thought I’d check with you before assuming.
OK, thanks, @david - I just did a test payment and it looks like the same “invoice_number” issue exists. So I’ll look to re-test it after this Sunday to see if rolls out.
Thanks, @hillel I’ve made that change, but even though I’ve changed the Zap to use “number” and not “invoice_number”, it keeps failing saying “invoice_number” is required and can’t be blank. So I’m hoping that the v5.3.25 release that @david replied to @WedBSV about does the trick!
Same for me, @david - the “New Payment in Invoice Ninja” trigger in Zapier doesn’t seem to be getting the “Invoice Number” passed to it. It has an “Invoice ID”, but not the number. In my zap, I then have a step for “Invoice Ninja - Find Invoice” that, even though I have it configured to use the v5 “number” field, still seems to insist it has to have the “Invoice Number”… because it fails with that as the error.
Hope that makes sense (and may be different than @WedBSV is having trouble with). Thanks!
Any update on this?? I cannot pull the Invoice Number from a Payment. I am trying to find a workout but have been unsuccessful. @David - you mentioned this would be available about a week ago. Please help!!
I believe there are some pending changes we haven’t released yet as we’ve been slammed this week. We are hopeful to get a window in the next day or so to release