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.

  • Home
  • Get Help
  • Troubleshooting
  • QuickBooks Online error: Amount calculation incorrect in the request.: Amount is not equal to UnitPrice * Qty. Supplied value:58.56, Quickbooks Field: Line.Amount

I have a math format that adds multiple items*qty.  When I use the output for the format it fails.

Test

Failed to create a create invoice in QuickBooks Online

Amount calculation incorrect in the request.: Amount is not equal to UnitPrice * Qty. Supplied value:58.56, Quickbooks Field: Line.Amount

Troubleshoot error

Hi @SolarGoesGreen -

I found a few articles online that may help resolve your issue. 

This article offers two possible solutions, though if it were me, I’d probably start with the second recommendation. 

Another article offered this recommendation as a solution: 

Solution:
Check the Qty, UnitPrice and Amount fields for each line of the transaction and ensure that the UnitPrice times Qty is equal to the Amount. (UnitPrice * Qty = Amount)

What is your trigger app? If you’d like, including screenshots of your Zap set up is extremely helpful when it comes to troubleshooting! Just be sure to omit any personal information. 

This is from an order in my zapier mailbox.  How does this work with multiple items?  I have the price of each item and qty of each item in the zap, then I have formatted those to add and the total for the amount in my inv oice.  What specifically do you need?

 

Thank you!

Hi @SolarGoesGreen 

Thank you for confirming that information.

Could you kindly send a screenshot of how each of your steps are set up? This would allow me to check further.

(If there’s any personal information, kindly blur them.)

Looking forward to your response! 😊

These are orders from Outlook.  I have tried the math formatter to multiply prices with quantities, and then use that total as well, and still fails.  The attached math that I tried, I took the e1st product price*qty]+]2nd product*qty]+]3rd product price*qty].  

Hi @Charie 

Thank you for sharing the screenshots.

Looking at the error message, it seems like something our Support needs to check as they will be able to check the Zap itself.

You may try to reach out to them here: https://zapier.com/app/get-help

Let me know if you have other questions.

Terms & Conditions