Skip to main content

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

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions 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.

  • Home
  • Get Help
  • How Do I
  • How do I setup conditional logic to include both new and existing items on a QuickBooks Online bill from CRM?
Question

How do I setup conditional logic to include both new and existing items on a QuickBooks Online bill from CRM?

  • January 26, 2024
  • 1 reply
  • 20 views
R
Forum|alt.badge.img

The zap is

 

When a purchase order is created in CRM, then create bill in Quickbooks.  The issue I’m having is if the item has not been created in Quickbooks yet, I want it to create the item.  Once the item is created, I want to add it to the bill so I will need NEW and EXISTING items on one bill.  I am not sure how to setup the conditional logic since BOTH items need to be on the SAME bill.  Any ideas?  I’ve thought about being able to add all the items onto a table and then creating the bill but I’m still having problems with the logic. 

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

SamB
Community Manager
Forum|alt.badge.img+11
  • SamBCommunity Manager
  • Community Manager
  • 7695 replies
  • January 30, 2024

Hi there, @RichC. Wow, that is a tricky one! 🤔

Hmm, perhaps you could use a similar approach to what’s mentioned in this guide:


But have two paths one checking the result of a search action to see if the product already existed (see Search for existing data in Zaps for more details):

  • One path would add the product into QuickBooks if it didn’t already exist and then add it to the digest.
  • And the other path would add the product that it found to the digest.


​Both paths would have a filter after those digest actions that only allows that iteration of the loop to continue running if the Loop Iteration is Last field is true. As we don’t know whether the last product the loop runs through will be an existing product or a new product there would need to be a Release Digest action in both paths - which would only run if that particular path’s rule conditions were matched AND it passed the filter conditions. After the Release Digest actions (in both paths) you’d then have a Create Bill action where you’d take the information from the digest and use it to create the bill. Since only one Path should run for the last loop iteration only one bill would be created.

That said, depending on what’s released from the digest you may also need to use a Formatter (Utilities > Line Itemizer) action to convert the digest items into line-items that you can use in the Create Bill action. 


Do you think that approach might work?

If I've misunderstood what you're looking to do or you run into any issues in giving that a try just let me know. Always happy to help further!

Terms & Conditions