I’m asking for assistance with a scenario integrating Quickbooks Online: In the Create an Invoice Module I’m getting an error: I"m so close i can feel it! :). Any help would be greatly appreciated:
Here’s the blueprint if helpful:
airtable_quickbooks.json (110.7 KB)
ValidationFault: Invalid Number (Invalid Number : SalesItemLineDetail)
QuickBooks
From here it looks ok but check
Numeric Fields:
Qty, Amount, and UnitPrice fields are correctly formatted as numbers without any extra characters, such as commas or spaces. They should be in plain numeric form (e.g., 23, 847.09, 36.83).Thanks for the quick response, I did verify that all fields are formatted correctly as numbers without Currency symbols. Still having the same problem. I enclosed all the fields with parsenumber() as a test and it produces the same error.
Welcome to the Make community!
According to the error message, which I read, it looks like the issue is coming from either of these fields:
One of these fields are expecting a number. A guess would be the ItemRef field, as it could require an item ID, and IDs are commonly numeric.
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Did you know, the concepts of about 70% of questions asked on this forum are already covered in the Make Academy. Investing some effort into it will save you lots of time and frustration using Make later!