Help

Creating Invoice on Quickbooks through Integromat

Topic Labels: Automations
Solved
Jump to Solution
1141 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Praneeth_Nadell
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi, I’m trying to automate creating an invoice on Quickbooks Online by a button press on Airtable through Integromat. While I’m successful in creating an invoice, the invoice is created for a Customer in Quickbooks. However, I want the invoice to be created for a Project of a Customer in Quickbooks, which is what I’m struggling with.

Here’s the workflow:
Have a Projects table and an Items table in Airtable. Create Invoice button exists in Projects table. On button click an invoice is created for all the items from Items table associated with the respective Project.

In Quickbooks: Customer exists. Multiple Projects exist under Customer.

Problem: Unable to map the invoice created to a Project in Quickbooks

Any ideas, tips or solutions on how to achieve this?
Thanks!

1 Solution

Accepted Solutions
Praneeth_Nadell
5 - Automation Enthusiast
5 - Automation Enthusiast

Used ‘Display Name’ of project from Quickbooks to get the Project in Integromat, and filtered using the Parent_Ref value to get the required Project ID. Then used this Project ID as Customer ID to create invoice mapped to the project

See Solution in Thread

1 Reply 1
Praneeth_Nadell
5 - Automation Enthusiast
5 - Automation Enthusiast

Used ‘Display Name’ of project from Quickbooks to get the Project in Integromat, and filtered using the Parent_Ref value to get the required Project ID. Then used this Project ID as Customer ID to create invoice mapped to the project