Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hello,

I’m trying to setup Freshbooks New to create a new sales invoice into Xero when I generate the invoice in Freshbooks. However, the Xero zap is asking me to input the required field “Line Quantity,” but I can’t find any field that is being detected in my Freshbooks invoice even though Freshbooks clearly has Quantity and Line Total in their invoices. I tried fudging it by inputing “1” into the Line Quantity field in hopes that it will always default to saying 1, but it’s still not allowing it to work. Please help!

 

This is the exact error message I am receiving: 

“We had trouble sending your test through.

A validation exception occurred, The UnitAmount field is mandatory and cannot be derived from the Quantity and LineAmount fields., The LineAmount field is mandatory and cannot be derived from the Quantity and UnitAmount fields.”

Hi @joshjcurtis ,

Thank you for reaching out- so sorry you are running into this error!

I am escalating to Support as they can dig into your Zap and help to resolve most quickly. Sit tight and someone will be in touch just as soon as they can!

@joshjcurtis - Thanks for your patience. We understood that you went back to using Freshbooks. We just wanted to ensure others received the answer:
 

Both Line Quantity and Line Unit Price are required. We can see this in the full error provided by Xero:

https://cdn.zapier.com/storage/files/dc929293b6d3c965d452abc5a68a4dfd.txt

If a "Line Item Code" value is not provided, Xero requires that you provide both a price and a quantity. That way, it can calculate the total for the invoice. The "1.0" that has been manually entered in for "Quantity" should work, as soon as there is a "Price" associated with the line-item as well. That will allow Xero to multiply the two together to create a total price.

Once the action has a value for "Quantity" and "Unit Price", even if one or both of those values have been manually entered, the action should succeed.

Terms & Conditions