Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results forΒ 
Search instead forΒ 
Did you mean:Β 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.

Reply to message

View discussion in a popup

Replying to:
alippiatt@bioinf
Level 1

How do we get auto invoice number generation to work with batch invoice import via CSV? It works when batch invoicing from the web interface, but not the CSV import.

We have QuickBooks Online Advanced subscription. Batch invoicing works as expected from the web interface, but not from importing via CSV. Mainly, the invoice number is a problem. We have the Sales/Customize transaction numbers setting set to On. When you use the web interface, it auto-fills the next sequential invoice number properly. However, it does not with the CSV import. The CSV import requires the Invoice No. field in its mapping. It you omit that field/column and try to upload a CSV, Step 2 fails with this error message: "You must map all the mandatory QuickBooks fields." If you then add the Invoice No. column, but leave the rows blanks, it completes step 2, but then does not upload any data and gives this error message: "Invoice No. missing in one of the rows." We tried the same test turning the Sales/Customize transaction numbers setting to Off, but the result is the same. How can we bulk import invoices via CSV without entering Invoice Numbers in each row? We want QBO to automatically generate the invoice numbers on import.

Need to get in touch?

Contact us