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.

I am using Zapier to create a QuickBooks Online invoice when a Salesforce opportunity is created. I have a zap that uses the action Create Invoice in QuickBooks Online. I want the invoice number to be auto-generated with a specific format. I have a custom field in Salesforce that provides the first part of the invoice number (“FY22-”) then I want the QBO Invoice number to auto generate numbers appended to that. So it would be FY22-1, FY22-2, FY22-3, FY22-4, etc. Is this possible with Zapier? I tried putting AUTO_GENERATE after the custom field reference in the Invoice Number field, but that just resulted in “FY22-AUTO_GENERATE”.

Field in the Create Invoice in QuickBooks Online action
Result in QuickBooks Online

 

Hi @TheCRMFirm, at first glance believe the issue lays in using a dynamic and static entries for this field but I’d like to phone a friend just to make sure I’m reading this correctly. @jesse, am I on the right track with this one? 

Hi @TheCRMFirm 

Good question.

You’d likely have to configure the Invoice prepend value in QBO.

You can either set a specific Invoice # OR use AUTO_GENERATE, but not both.

 

Looks like @Troy Tessalone and I pressed send at the same time. @TheCRMFirm try making that adjustment and let us know what the outcome is!

Hi @TheCRMFirm 

 

You need to add a step before that which is Storage by Zapier and choose the Event “Increment Value” . The Key can be anything, the increment value would be 1. You then pass this value instead of “auto generate” 

Terms & Conditions