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 using Zapier to automate invoicing multiple products in Quickbooks online. In the step (attached image) where I need to put in the information of products, I am setting the amount field as 450,2800. 450 corresponds to the unit price times quantity for one product, and 2800 is the same for another product. However, I seem to get the formatting wrong? I'm getting this error message  

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

 

As you might have noticed, the amount field is coming from the number formatter. I’ve formatted it for the US currency. Even if I don’t do that and put 450,2800 manually, it still throws the same error.

 

At this point I don’t know what I’m doing wrong. I would really appreciate you guys helping on this. Thanks. 

 

Multiple Line Items Invoicing Settings That I’ve Tried
​​​​

 

Hey @Zepticona ,

 

For QB Line items , You can’t map the line items values (Qty,Price,etc) directly. 

 

First convert text to line items using Formatter by Zapier and than map in Quickbooks line items. 

Thanks @jayeshkumarbhatia, it worked. 

 

I was already using Formatter by Zapier, but I didn’t realize I wasn’t making line items but comma separated one liners. Thanks again for your help! 

Line Items Appear Like Iterable Arrays

 

You are welcome! @Zepticona .

 

Let me know if you need with anything.

Hi ​@jayeshkumarbhatia I have the exact same problem as ​@Zepticona 

Can you explain more about what I should do to “First convert text to line items using Formatter by Zapier and than map in Quickbooks line items”?

 

Hi ​@katherineshen,

 

To convert text into line items and map them in QuickBooks using Zapier, start by adding a Formatter step with the 'Utilities' action and choose 'Text to Line-Item.' Configure the item and line separators to split your text correctly. Once converted, in the QuickBooks step of your Zap, you can map each line item (for example, Description) to the corresponding QuickBooks fields.

 

I hope this helps! Please let me know if you have further questions or need additional assistance.

Hi ​@JammerS thanks for your reply! I think I already did the steps of converting the text into line items using Formatter that you mentioned and put them in the corresponding fields of the “Create Invoice” on the quickbooks step. Is there something else that I might be missing?

Hi ​@katherineshen,

 

If you've set up the Formatter step to convert text into line items and mapped them to QuickBooks, you're on the right track. However, issues may arise due to formatting errors, incorrect field mapping, or incompatible data types. Double-check each of these areas, and if problems persist, providing specific error details will help diagnose the issue.

We appreciate your patience and are committed to helping you resolve this issue.

Terms & Conditions