Can you please check the data in/out in the Zapier to logs to see what’s being sent/received for the invoice number field.
Here is a overview of the test data. Video: 45s Screen Recording 2021-10-05...
id
X7axz04qdy
user_id
y1aKz9JeQG
project_id
assigned_user_id
amount
37479.98
balance
0
client_id
YqaQ5lWMan
vendor_id
status_id
1
design_id
4openRe7Az
recurring_id
created_at
1633358366
updated_at
1633358366
archived_at
0
is_deleted
false
number
0215
discount
0
po_number
782
date
2021-10-04
last_sent_date
next_send_date
2022-01-24 00:00:00
due_date
2022-01-25
terms
-
Materials Invoice of 75% is due within 7 days. Failure to pay on time will release your install date
-
2nd Materials Invoice of 25% due 30 days prior to your install date
-
3rd Invoice for Installation Services and Material Taxes if Applicable due 5 days before install date
-
A Final Invoice for actual Freight costs will be sent once shipped and is due prior to install completion
Please wire your payment directly to us. Wire Instructions are included above for both domestic and international. They are also included on your invoice email.
public_notes
private_notes
Link to QB Install&Tax Invoice: https://app.qbo.intuit.com/app/invoice?txnId=5905
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
true
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
cost
-51534.78
quantity
1
product_key
4
notes
Materials
type_id
1
product_cost
0
discount
0
is_amount_discount
true
tax_name1
tax_rate1
0
tax_name2
tax_rate2
0
tax_name3
tax_rate3
0
sort_id
0
line_total
-51534.78
gross_line_total
-51534.78
date
custom_value1
custom_value2
custom_value3
custom_value4
2
cost
-1674.84
quantity
1
product_key
112
notes
Tax on Materials
type_id
1
product_cost
0
discount
0
is_amount_discount
true
tax_name1
tax_rate1
0
tax_name2
tax_rate2
0
tax_name3
tax_rate3
0
sort_id
0
line_total
-1674.84
gross_line_total
-1674.84
date
custom_value1
custom_value2
custom_value3
custom_value4
3
cost
90689.6
quantity
1
product_key
7
notes
Installation
type_id
1
product_cost
0
discount
0
is_amount_discount
true
tax_name1
tax_rate1
0
tax_name2
tax_rate2
0
tax_name3
tax_rate3
0
sort_id
0
line_total
90689.6
gross_line_total
90689.6
date
custom_value1
custom_value2
custom_value3
custom_value4
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
Vyb8gvm2av
client_contact_id
4QbYRpPOdz
key
jEdMLGDqGEiZrJhWJ8kI0EX1EQu0nAXrzD1SFmbBiVBjcpUBBm9IHZ2I9SsbCjwz
link
sent_date
viewed_date
opened_date
updated_at
1633358366
archived_at
0
created_at
1633358366
email_status
email_error
documents
Thanks, if you could please send the data in sent by a full test zap it would be helpful.
Data In:
- include_pdf:
no
client_id:
WZdPJyw2aK
send_email:
false
invoice_number:
Quote #706 - 75% Material Deposit Due
po_number:
706
date:
2021-10-06T09:00:00-05:00
due_date:
2021-10-13T16:15:21-05:00
cost:
72869.63249999999
quantity:
1
product_key:
Materials
notes:
75% Deposit on Materials for job# 706
private_notes:
Link to QB Materials Invoice: https://app.qbo.intuit.com/app/invoice?txnId=5989
line_items:
1:
cost:
72869.63249999999
quantity:
1
product_key:
Materials
notes:
75% Deposit on Materials for job# 706
---------------------Data Out---------------------------
- id:
pmbkVD8Jaz
user_id:
y1aKz9JeQG
amount:
72869.63
balance:
0
client_id:
WZdPJyw2aK
status_id:
1
design_id:
4openRe7Az
created_at:
1633554922
updated_at:
1633554922
archived_at:
0
is_deleted:
false
number:
0216
discount:
0
po_number:
706
date:
2021-10-06
next_send_date:
2021-10-12 00:00:00
due_date:
2021-10-13
terms:
- Materials Invoice of 75% is due within 7 days. Failure to pay on time will release your install date - 2nd Materials Invoice of 25% due 30 days prior to your install date - 3rd Invoice for Installation Services and Material Taxes if Applicable due 5 days before install date - A Final Invoice for actual Freight costs will be sent once shipped and is due prior to install completion Please wire your payment directly to us. Wire Instructions are included above for both domestic and international. They are also included on your invoice email.
private_notes:
Link to QB Materials Invoice: https://app.qbo.intuit.com/app/invoice?txnId=5989
uses_inclusive_taxes:
false
tax_rate1:
0
tax_rate2:
0
tax_rate3:
0
total_taxes:
0
is_amount_discount:
true
partial:
0
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:
cost:
72869.63249999999
quantity:
1
product_key:
Materials
notes:
75% Deposit on Materials for job# 706
type_id:
1
product_cost:
0
discount:
0
is_amount_discount:
true
tax_name1:
tax_rate1:
0
tax_name2:
tax_rate2:
0
tax_name3:
tax_rate3:
0
sort_id:
0
line_total:
72869.63249999999
gross_line_total:
72869.63249999999
date:
custom_value1:
custom_value2:
custom_value3:
custom_value4:
entity_type:
invoice
paid_to_date:
0
auto_bill_enabled:
false
invitations:
1:
id:
Jxbo0g7Ldg
client_contact_id:
WPe9w5mPbL
key:
mpt1iMqoeo0AUNm8ySQZO05GOGF2RYeQBwfbbRsau9R7E7ZkmTYHMyHA1Zl2e0S0
link:
invoice/mpt1iMqoeo0AUNm8ySQZO05GOGF2RYeQBwfbbRsau9R7E7ZkmTYHMyHA1Zl2e0S0
sent_date:
viewed_date:
opened_date:
updated_at:
1633554922
archived_at:
0
created_at:
1633554922
email_status:
email_error:
Fields with no value:
project_id
assigned_user_id
vendor_id
recurring_id
last_sent_date
public_notes
tax_name1
tax_name2
tax_name3
footer
partial_due_date
custom_value1
custom_value2
custom_value3
custom_value4
reminder1_sent
reminder2_sent
reminder3_sent
reminder_last_sent
subscription_id
documents
Thanks! Do you know which exact version of the Zapier integration you’re using?
The newest one for V5
We’ve just deployed a new Zapier version (v5.0.21) which should help, when you have a chance please try creating a new zap.
If you use the one labeled Invoice Ninja latest with the round circle it should be correct.
Note: if you search for the full name “invoice ninja” you can see more options.
Yes the one with the circle has a green tag that says “beta”. I have been using that one since switching to V5 a few days ago.
We’ve recently deployed a new version of the v5 integration.
I’m not sure, Zapier just informed us v5 should be fully live now.
Can you please email them directly for advice.
One thing which may be confusing is that the v5 Zapier now appears to have a square logo which in the past was used for the v4 version.
I reached out to Zapier again now. Selecting the “latest” auto populates 1.0.12 which doesnt work at all so now nothing is functioning.
Sorry for the trouble, hopefully it’s resolved soon.
It may help to manually choose the latest v5 version available.
That isnt an option.
Have you tried searching for the full name “invoice ninja” and then scrolling down?
We went the V5 way as recommended here and nothing is actually working for us now. Can someone please advise how we can get the Zapier to work to create a new user in InvoiceNinja. Its actually broken our entire workflow…
Sorry for the trouble, we’re waiting on Zapier to resolve the issue.
We’ve developed a new v5 integration but it looks like only the v4 integration is currently available.
We expect the problem to be resolved soon…