Hi everyone! Does anyone know how to add multiple lines to a Quickbooks invoice via a pipeline? Is that possible? For example, I have a Job record in Base that generates a Books invoice via a pipeline. The Base record has multiple child records that I need to be able to insert as multiple line items in the Books invoice. Thank you! #quickbooks #Pipelines #channels------------------------------Elena Larrabee------------------------------

It does work in pipelines. You just have to perform a few steps STEP A. trigger your pipeline, in your master table, however you want. I usually create a button that triggers a checkbox. STEP B. quickbase search records look for child records that contain the master table "related id" for example, I look for all line item records that contain the same related work order Id number as step 1. this will help "query" your line items STEP C. create an invoice Quickbooks step Lines* (list) is the place where you enter the objects from step 2. pipelines will automatically iterate through each line. done.------------------------------Manny Hernandez------------------------------

Hi Elena,I am trying to figure this out right now with either pipelines or zapier. I will let you know if I figure it out.------------------------------Manny Hernandez------------------------------

Manny,Thank you for this, its very appreciated.. it worked perfectly except for one thing. In the Quickbooks channel's "Lines (list)" section, I can't figure out where to map a "line item cost" field to the "Rate" field in Quickbooks. It has a field to map "Amounts" for the total for the line item, but nothing i've tried will send anything to the Rate field. It sends Quantity, Name, SKU, and Description (and even Amount) perfectly for each Child record in a given Parent record, but nothing for the actual Rate. So as it is, it creates the invoice and all of the line items, and each one has a name, description, quantity, and total, but the Rate field is left blank. Have you come across this issue?------------------------------Sam Cole------------------------------

Sam,I did have the same issue. Unfortunately no luck with making the native fields work. Seems like those filelds are missing in the pipelines.I did have a workaround that I am using for now until they fix it. I made a formula text field where I combine the rate and amt beneath the description. See attached photos. Not the best fix - but it will do for now. ------------------------------Manny Hernandez------------------------------

Thanks Manny. I've also opened a support case and given them all the info. Hopefully they'll get it corrected soon------------------------------Sam Cole------------------------------

Pipelines Quickbooks channel help

MannyHernandez
Qrew Trainee
5 years ago
Hi Elena,

I am trying to figure this out right now with either pipelines or zapier. I will let you know if I figure it out.

------------------------------
Manny Hernandez
------------------------------
- MannyHernandez
  Qrew Trainee
  5 years ago
  It does work in pipelines. You just have to perform a few steps
  
  STEP A. trigger your pipeline, in your master table, however you want. I usually create a button that triggers a checkbox.
  
  STEP B. quickbase search records
  
  look for child records that contain the master table "related id"
  
  for example, I look for all line item records that contain the same related work order Id number as step 1.
  
  this will help "query" your line items
  
  STEP C. create an invoice Quickbooks step
  
  Lines* (list) is the place where you enter the objects from step 2.
  
  pipelines will automatically iterate through each line.
  
  done.
  
  ------------------------------
  Manny Hernandez
  ------------------------------
  - SamCole
    Qrew Cadet
    5 years ago
    Manny,
    Thank you for this, its very appreciated.. it worked perfectly except for one thing. In the Quickbooks channel's "Lines (list)" section, I can't figure out where to map a "line item cost" field to the "Rate" field in Quickbooks. It has a field to map "Amounts" for the total for the line item, but nothing i've tried will send anything to the Rate field. It sends Quantity, Name, SKU, and Description (and even Amount) perfectly for each Child record in a given Parent record, but nothing for the actual Rate. So as it is, it creates the invoice and all of the line items, and each one has a name, description, quantity, and total, but the Rate field is left blank. Have you come across this issue?
    
    ------------------------------
    Sam Cole
    ------------------------------

Forum Discussion

Pipelines Quickbooks channel help