I start with a Jotform and pull the data from there. It works fine. Create a dropbox folder and share it. Fine Search for client in Quickbooks. If not found, create new client. Create invoice with multiline support. create second line in invoice using update invoice. Take invoice ID from step 6. create third line in invoice using udpate invoice. Take invoice ID from step 6. The problem is that the invoice doesn’t get updated with a new line, the first line gets overwritten each time. How can I achieve making a multiline invoice?

Best answer

How do I add line items to an invoice in Quickbooks?

Forum|Forum|5 years ago
May 14, 2020
5 replies
2673 views

+1

Bellevuefineart
Beginner

I start with a Jotform and pull the data from there. It works fine.
Create a dropbox folder and share it. Fine
Search for client in Quickbooks. If not found, create new client.
Create invoice with multiline support.
create second line in invoice using update invoice. Take invoice ID from step 6.
create third line in invoice using udpate invoice. Take invoice ID from step 6.

The problem is that the invoice doesn’t get updated with a new line, the first line gets overwritten each time. How can I achieve making a multiline invoice?

Best answer by AndrewJDavison

My mistake @Bellevuefineart

It’s “Storage->Push Value Onto List”

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

+1

Bellevuefineart
Author
Beginner
Forum|Forum|5 years ago
May 15, 2020

nobody?

Like

+11

AndrewJDavison
Zapier Solution Partner
Forum|Forum|5 years ago
May 15, 2020

Hi @Bellevuefineart

First, drop the “Update Invoice” steps as it’s not possible to attach new line items to an existing invoice.

You can add the multiple line items in the “Create Invoice” step.

Check out “Formatter->Push Value Onto List” you can do that multiple times to create a list of line items. Then add a “Formatter->Get Value” step to retrieve that list. You can then map that into the “Create Invoice” step and you’ll get a multiline invoice.

Let us know if you get stuck.

Find out more and hire me: https://zapier.com/partnerdirectory/andrewjdavison (andrew@andrewjdavison.com)