Creating QB Bills with both account and item based lines

[E2]

What is your goal?

Create QB Bills with both account and item based lines based on previously aggregated arrays

What is the problem & what have you tried?

I am currently using Make to import my Airtable records to Quickbooks (bill). I use an aggregator to group the records by vendor, then create/update the item-based QB bill. However, I now want to add an account-based line to each of these bills (currently manual, need to automate this).

I’m stuck on the structure for this. I cannot put more than one array in the mapped QB Lines field. Is there a way to merge two arrays and add that instead? Or do I need to use API? I’ve avoided the API until now… hoping I can do this without it..

Screenshots (scenario flow, module settings, errors)

[Stoyan_Vatov]

Hey there,

you merge two arrays with the merge() function.

[Mohamed_Jahar]

Hi @E2,

You can achieve this without using the API by merging both arrays.

Use the following expression:

merge(itemLinesArray; accountLinesArray)

The merge() function combines both arrays into a single array. This allows you to create a bill containing both item-based and account-based lines using the native QuickBooks module, without the need for any custom API calls.

Hope this helps!

Best Regards,
@Mohamed_Jahar

[E2]

Thank you, this worked! Here’s my updated flow

[E2]

Thanks, this worked!