Sep 08, 2021 11:30 PM
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!
Solved! Go to Solution.
Nov 03, 2021 08:42 AM
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
Nov 03, 2021 08:42 AM
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
Apr 04, 2024 02:22 PM