V5 Payment Doesn't Include Invoice Number

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.

Any ideas?

1 Like

As a follow-up, here’s the “Data Out” from the first step of the Zap that retrieves the new Payment from Invoice Ninja:

id: LDdw8yZRe1
user_id: pnelExMaKB
amount: 2
refunded: 0
applied: 0
transaction_reference: Paid in person
date: 2021-10-13
is_manual: true
created_at: 1634163258
updated_at: 1634163258
archived_at: 0
is_deleted: false
type_id: 2
client_id: pnel0JD1eK
status_id: 4
exchange_rate: 1
exchange_currency_id: 1
paymentables:
1:
id: WPe973p4bL
invoice_id: pnelPGxleK
amount: 0
refunded: 0
created_at: 1634163258
updated_at: 1634163258
archived_at: 0
Fields with no value:
assigned_user_id
invitation_id
private_notes
number
custom_value1
custom_value2
custom_value3
custom_value4
client_contact_id
company_gateway_id
project_id
vendor_id
currency_id
documents
querystring

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.

@david any ideas? I thought we had added the invoices to the payment trigger.

I have a fix for this shortly.

1 Like

Great, thanks @david. Can’t wait!

@rvgeeks, this is now live.

Thanks, @david … just tested this, but it seems to be failing still.

Step 1 “New Payment in Invoice Ninja” returns the following data:

id: pnelV0yJbK
user_id: pnelExMaKB
amount: 12
refunded: 0
applied: 0
transaction_reference: Paid Cash 2021-10-14 Test #3
date: 2021-10-14
is_manual: true
created_at: 1634251666
updated_at: 1634251666
archived_at: 0
is_deleted: false
type_id: 2
client_id: pnel0JD1eK
status_id: 4
exchange_rate: 1
exchange_currency_id: 1
paymentables:
1:
id: GRb4DYy7bB
invoice_id: Vyb8ljZrbv
amount: 0
refunded: 0
created_at: 1634251666
updated_at: 1634251666
archived_at: 0
invoices:
1:
id: Vyb8ljZrbv
user_id: pnelExMaKB
project_id:
assigned_user_id:
amount: 12
balance: 12
client_id: pnel0JD1eK
vendor_id:
status_id: 2
design_id: MVyb8mjdvA
recurring_id:
created_at: 1634250918
updated_at: 1634251512
archived_at: 0
is_deleted: false
number: RVG-3023
discount: 0
po_number:
date: 2021-10-14
last_sent_date:
next_send_date:
due_date: 2021-10-14
terms: Payable upon receipt.

Please make checks payable to “RVgeeks” and mail to:

RVgeeks
2885 Sanford Ave SW #13216
Grandville, MI 49418

Thank You For Your Prompt Payment. We Appreciate Your Business!
public_notes:
private_notes:
uses_inclusive_taxes: false
tax_name1:
tax_rate1: 0
tax_name2:
tax_rate2: 0
tax_name3:
tax_rate3: 0
total_taxes: 0
is_amount_discount: false
footer:
partial: 0
partial_due_date:
custom_value1:
custom_value2:
custom_value3:
custom_value4:
has_tasks: false
has_expenses: false
custom_surcharge1: 0
custom_surcharge2: 0
custom_surcharge3: 0
custom_surcharge4: 0
exchange_rate: 1
custom_surcharge_tax1: false
custom_surcharge_tax2: false
custom_surcharge_tax3: false
custom_surcharge_tax4: false
line_items:
1:
product_key: Annual Renewal
notes: TEST - Annual Website Updates, Hosting, E-mail, Domain Renewal, Maintenance & Support
cost: 12
product_cost: 349
quantity: 1
tax_name1:
tax_rate1: 0
tax_name2:
tax_rate2: 0
tax_name3:
tax_rate3: 0
custom_value1:
custom_value2:
custom_value3:
custom_value4:
discount: 0
type_id: 1
createdAt: 1634250894160000
is_amount_discount: false
sort_id: 0
line_total: 12.00
gross_line_total: 12
date:
entity_type: invoice
reminder1_sent:
reminder2_sent:
reminder3_sent:
reminder_last_sent:
paid_to_date: 0
subscription_id:
auto_bill_enabled: false
invitations:
1:
id: BDbDoKW6al
client_contact_id: 46dBWx5ke7
key: VolejRejNm-r5TqQXQdgGnlSmMk67i5VjkG5EeVK2SY
link: https://rvgeeks.invoicing.co/client/invoice/VolejRejNm-r5TqQXQdgGnlSmMk67i5VjkG5EeVK2SY
sent_date: 2021-10-14 22:35:55
viewed_date:
opened_date:
updated_at: 1634251243
archived_at: 0
created_at: 1634250919
email_status: delivered
email_error: smtp;250 2.0.0 Ok: queued as DE2821E341BE
documents:
Fields with no value:
assigned_user_id
invitation_id
private_notes
number
custom_value1
custom_value2
custom_value3
custom_value4
client_contact_id
company_gateway_id
project_id
vendor_id
currency_id
documents
querystring

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.

Appreciate any thoughts!

  • John

Hi John,

I see the issue. The payment is being created and firing the webhook before the invoices are attached. I’ll push up another release for this.

2 Likes

Great, thanks @david! Let me know when it’s up, and I’ll test it out and report back. Thanks!