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

Salesforce to QuickBooks online for invoicing

  • 27 January 2023
  • 5 replies
  • 141 views
P
Userlevel 1
Badge

HI new to Zapier & needing help. I have 2 zaps working well, but cant get the 3rd to work.

I want to send information form SF to QB to create an invoice.

Steps:

1 - Trigger - salesforce record updated (to Order status) - all good

2 - Action: create invoice in QB online

        set up action: wants me to choose a customer from a list already in QB. The correct customer is the customer associated to the opportunity in salesforce. So I click “custom”. This gives me a list of all the fields in the SF opportunity (quantity, size, price etc), but not the fields LINKED to the opportunity (customer).

There is the option to add a search step, but I still cant get that to work.

Here is the logic:

for the updated SF opportunity record

find the linked contact object

select the customer name

Pass that to QB

 

Any thoughts would be appreciated.

icon

Best answer by nicksimard 27 January 2023, 00:24

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.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @PinMaker 

Good question.

For context, we’d need to see detailed screenshots with how your Zap steps are configured.

Each app will expect their internal IDs for those Contacts so you likely need to add search steps.

 

Salesforce should return the Contact ID of the linked Contact to the Opportunity.

From there you can add a Zap step: Salesforce - Find Record

 

For QBO you may need to add this Zap action: QBO - Find/Create Customer

Then you can map the QBO Customer ID to the QBO Invoice.

 

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

Hi @PinMaker!

The key to using the Custom option is to map the correct field. You can get an idea which field needs to be used by checking out the lighter grey text under the label when you click a dropdown.

For example when you look at customers in a Create Invoice step you’ll see these values:

 

If you were to use the Custom tab, the value you would need from a QBO search step would look like that 66 and 67 (in other words, you’re looking for an ID rather than a name or email address).

So, for customers in QBO you would map this field into your Create Invoice step:

 

Would you mind giving that a shot to see if it works for you?

P
Userlevel 1
Badge

thank you both. will try again and let you know how I get on….

 

P
Userlevel 1
Badge

Its working THANK YOU

nicksimard
Userlevel 7
Badge +11

@PinMaker 

Yay! So great to hear that you got that working :) Thanks for letting us know.

Terms & Conditions