Forum Discussion

ElenaLarrabee1's avatar
ElenaLarrabee1
Qrew Captain
5 years ago

Pipelines Quickbooks channel help

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
------------------------------

2 Replies

  • From what I can gather - I think you'd set up to steps after your trigger step.

    1. Search records in that child table, (filtered on the related parent = recordID of the parent / trigger)
    2. a "for each" loop will pop up, and for each item found in #1 - create a record in Books.

    Hope that helps!

    Jacob



    ------------------------------
    Jacob MacIntyre
    Manager
    Quick Base
    Portland OR
    ------------------------------
    • ElenaLarrabee1's avatar
      ElenaLarrabee1
      Qrew Captain
      Thank you! Except, it seems like the "lines" in Books invoices are child records of an Invoice, but they aren't editable (within Pipelines) as individual records themselves, from what I can tell. You just get the option to import data for one "line" per invoice created or updated, even in a "for each".  Unless I'm missing something. 



      ------------------------------
      Elena Larrabee
      ------------------------------