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.

Question

How to generate QuickBooks Online invoice number with specific format

  • 7 February 2023
  • 4 replies
  • 244 views
T
Userlevel 1

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

 

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

4 replies

chanelle
Userlevel 7
Badge +8

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? 

Troy Tessalone
Userlevel 7
Badge +14

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.

 

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

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!

MohSwellam
Userlevel 7
Badge +8

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” 

Founder of GeekyAir.com
Terms & Conditions