Manufacturing Information Solutions Forum Index Manufacturing Information Solutions
Your Place for Support and Discussions
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Multiple Invoice Number Sequence in QuickBooks

 
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> QuickBooks
View previous topic :: View next topic  
Author Message
LindaSimpson
New Member


Joined: 21 May 2007
Posts: 24
Location: Cleaveland, IH

PostPosted: Thu Feb 05, 2009 12:35 pm    Post subject: Multiple Invoice Number Sequence in QuickBooks Reply with quote

QuickBooks will automatically generate the next sequential invoice number when you are creating invoices. In some cases, though, you may want to have more than one sequence of numbers. Perhaps you have two divisions of your company, each with its own invoice numbering. Or you want to track classes of sales ? with one sequence for retail sales and another for wholesale sales. This is easy to set up in QuickBooks.

Invoice Numbering Basics

If you save an invoice in QuickBooks, the next invoice that you create will have the next sequential invoice number. Save invoice ?1?, the next will be invoice ?2?. QuickBooks is smart enough to work with modified invoice number formats. If you save an invoice with invoice number ?Counter 001?, the next invoice will be ?Counter 002?. If you use ?123abc? then next number will be ?124abc?.

This sometimes creates some confusion ? someone may accidentally add a character to the end of the invoice number, then all subsequent invoices will continue with adding that character. The simple solution is to create and save a new invoice, editing the invoice number to not have the letter.

I?ll also note that in some rare occasions I?ve heard of people who have a QuickBooks company file where the auto sequencing doesn?t work ? I?ve not been able to pin down why that might happen (I?ve not gotten my hands on a file that shows this problem).

Setting Up Multiple Sequences

What if you want to have two (or more) sequences, as I described above? I might want one sequence for retail sales, where the sequence starts with ?R001?, and another where the sequence starts with ?W0001? for wholesale sales. Keeping track of two sequences and remembering which is the next number can be difficult.

[1]QuickBooks can do this ? create a second Accounts Receivable account in your chart of accounts.

[2]Once you have added another A/R account you will see a dropdown box titled Account on the create invoice screen. This allows you to select which A/R account to use for this invoice.


Each A/R account has its own numbering sequence. All you have to do is to save an invoice using that A/R account, with the starting sequence number you want to use.

Things to Watch Out for
I would like to point out a few things to take into consideration:

You have to be careful that you are selecting the proper A/R account when creating a new invoice. Your workstation will remember the last A/R account you worked with.

When you are scanning through invoices with the Previous and Next buttons, you will scan through the invoices for the A/R account you specify. That can be confusing sometimes. You have to select the A/R account to work with, then scan through the invoices for that account.

The Payments Receipts window will now show the A/R account dropdown ? so you can only apply a payment to one A/R account for a customer. If you have different A/R accounts for the same customer, one payment can?t easily be applied to invoices from different A/R accounts.

If you use Multiple Currencies this gets a bit complicated. Each currency you work with must have a separate A/R account for that currency. Unfortunately, that means you have a different invoice number sequence for each currency. You can create multiple A/R accounts for a currency. However, if you want just one sequence across all currencies, I?ve not found a way to do that.
________
CALIFORNIA DISPENSARIES


Last edited by LindaSimpson on Wed Feb 16, 2011 12:53 am; edited 1 time in total
Back to top
View user's profile Send private message
mistux
Site Admin


Joined: 25 Jun 2004
Posts: 1042
Location: South Bend, Indiana USA

PostPosted: Mon Feb 09, 2009 11:51 am    Post subject: Reply with quote

Thanks for shairing that with the group, keep up the good work!
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    Manufacturing Information Solutions Forum Index -> QuickBooks All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group