About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Best answer

How do I match and update Salesforce opportunities to QuickBooks invoices?

  • 6 February 2023
  • 6 replies
  • 224 views
T
Userlevel 1

I was able to create a Zap that creates an invoice in QuickBooks when an Opportunity of a certain record type is created in Salesforce. It finds the related customer account and creates the pledge invoice, no problem.

Now I need to update the QuickBooks invoice to Received when the Salesforce Opportunity is updated to Received and vice versa. I can’t figure out how to match the QuickBooks invoice to the Salesforce Opportunity to do the update. Has anyone done this before? Can I do this with a Zap or do I need to use Transfer?

icon

Best answer by SamB 17 February 2023, 11:50

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

6 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @TheCRMFirm 

Good question.

FYI: Zaps are meant for 2-way data syncs: https://zapier.com/help/create/basics/does-zapier-support-two-way-syncing

One options is to add another step to your initial Zap that will store the QBO invoice ID in a custom field on the Salesforce Opportunity record for reference in the new Zap.

Otherwise, try these Zap steps.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
T
Userlevel 1

Thank you @Troy Tessalone! This is super helpful. To mark the invoice as Received in QuickBooks, what field should I update? Or do I need to create a payment against the invoice?

Troy Tessalone
Userlevel 7
Badge +14

@TheCRMFirm 

Not sure if there is a field in the QBO Update Invoice to adjust the Invoice Status.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
christina.d
Userlevel 7
Badge +9

Hiya @TheCRMFirm!

I wanted to swing by and mention @Troy Tessalone was right. This doesn’t appear to be possible at the moment, primarily due to limitations in the QBO API. Full transparency I’m going off this thread in their community.

Could be something worth bringing up to them that you’d also be interested in this though!

Sorry to not have better news but appreciate you joining and asking in the Zapier community. 🧡

T
Userlevel 1

It turns out that the client wants only to update in one direction. So when a QBO invoice is marked paid, then we use Zapier to update the Stage to Received in Salesforce. In a previous zap, we had stamped the QBO invoice number on the Salesforce opportunity so we could find it when the QBO invoice is paid.

SamB
Rank
Userlevel 7
Badge +11

Hi @TheCRMFirm! 👋

In that case you’d need an “Updated Invoice” type of trigger that could run when the invoice’s status is marked as paid. There’s an existing feature request open for that type of trigger so I’ve added your vote to that. We’ll email you as soon as that trigger gets added to the QuickBooks Online app.

There’s already a related topic in Community that’s associated with that feature request so we’ll be posting any news we have to share over there: 

In the meantime, there’s a workaround you can try that’s mentioned on that related thread. Essentially you’d set up a webhook in Quickbooks to run when an invoice’s status is changed to “paid”. So you’d have the webhook trigger the Zap and update Salesforce using the following trigger and actions:


Hope that helps. Please do let us know whether you’re able to get that working using the suggested workaround! 🙂

Terms & Conditions