Serial number tracking is a key requirement for many inventory based businesses. Until now, if you wanted this feature in QuickBooks you had to use an expensive third party add-on product that would move inventory functions entirely outside of the QuickBooks company file. With the 2012 version of QuickBooks Enterprise Solutions we have a closely integrated Serial Number Tracking feature available.
To get Serial Number and Lot tracking (which is discussed in this article) you have to purchase the Advanced Inventory feature, which is available for an additional fee. Note that you can only use one OR the other of lot tracking and serial number tracking, you can’t combine them in a single company file.
This article was updated on 9/14/2011, 9/28/2011, and again on 10/20/2011.
If I receive an inventory part (or assembly) I can enter a Serial Number for each of the items in the last column.
Serial numbers can be up to 40 characters long, and must not have any spaces. You can enter them all in line here, separating each serial number from the others by either a space or a comma.
You must enter the same number of serial numbers as the quantity for the line, or you can leave the serial number field empty. I wish that we could specify which items should get serial numbers so that I don’t the annoying warning message if I leave the field blank. I know that I can turn off the warning, but then it is turned off for all items.
When you are entering the serial numbers here you will see a small down-arrow next to the field. Click on this and you will see a dropdown menu with the option Quick View for Serial Numbers. This is very nice, it is easier to enter your serial numbers with accuracy if you use this.
When I sell the item, I can select the serial numbers for the order. If you just start typing in a serial number the program will show you the list that matches. Or, you can click on one of the other options for selecting serial numbers.
Add Multiple Serial Numbers will open a window that lets you easily locate and select serial numbers. There is a nice filter feature at the top, where you can limit the list that is displayed to include serial numbers that start with, end with or contain a particular value. Here I filtered to show items that contain the value “1”.
I wish that this window would tell me how many serial numbers I need for the order detail line I’m working on, since I usually want to match that. I can drag the window aside to see the order underneath.
If I select some serial numbers this way, and then click on the option again, it doesn’t show me the serial numbers I already selected. It is easy to add the same serial number multiple times. Yes, I will be warned, but it would be nicer to have a little more help from the program here.
Quick View for Serial Numbers opens a Quick View window like what we saw above in the item receipt. This will let you add new serial numbers that don’t already exist. This feature worries me – there are certainly many situations where this is very beneficial, but for many businesses you don’t want to allow the order entry clerk to create new serial numbers. A key issue in managing serialized inventory is to have the proper control over who can create serial numbers, so the ability for the order entry clerk to add serial numbers here breaks this control process.
Autofill from Existing Inventory is easy to understand – select this, QuickBooks will select the serial numbers to match what you enter for the quantity to sell.
A serial number column appears in every transaction where you will be changing the quantity of the item.
Adjust Quantity/Value on Hand has a new adjustment type, Serial Number. You can use this to add or remove serial numbers. This is a bit of an oddball transaction, as it doesn’t change the quantity on hand, so there are no adjustments to your chart of account. I’m not sure why “Customer:Job” and “Class” are options here?
This is a special case that I want to look at further. In some industries you will be building inventory assembly items that are serialized. Going further, you may be using serialized components in the assembly. It is crucial that you be able to create the serial numbers easily, and be able to track serialized parts that are consumed. You must be able to locate an assembly that uses a particular serialized item.
This is more common with Lot Control, where you are tracking all components in a lot, but it does apply to Serial Numbers as well. And keep in mind that you cannot mix Lot Control with Serial Numbers in QuickBooks.
Here’s an assembly build that I’ve created. Two problems came up right away:
Two new reports have been added, Transaction List by Serial Number and Serial Numbers in Stock.
The Transaction List by Serial Number has you enter the item and the serial number to look for. You can’t show multiple items or serial numbers.
You cannot customize this report, which is frustrating.
The Serial Numbers in Stock report also cannot be customized. Note that the serial numbers print only on one line, with no word wrapping, so if you have a large number of serial numbers you won’t be able to see all of them in this report. This is a significant shortcoming. Update 9/28/2011: If you double-click on the serial numbers a “Quick View” window opens that will show you the entire list of serial numbers. You cannot print this, however. See this article for details.
An number of other reports can be modified to add the serial number as a column. I’m not sure how widespread this is. One useful report is the Sales by Customer Detail – as I show here with the serial number added.
Select Edit in your QuickBooks menu, then Preferences. Find the Items & Inventory preference and select the Company Preferences tab. Click the Advanced Inventory Settings button.
Check the Enable Lot or Serial Numbers box, and select Serial Numbers. Note that you can only use one of these features in a company file.
There are several options that you can set. The options that you want will depend on what you are working with. If you are manufacturing the serialized items, for instance, you wouldn’t need that feature in purchase transactions. You can easily change these options later. I’m not sure on the best recommendation for settings on the three warnings – if you have a small number of serialized items but a large number of inventory parts in the item list, the warnings can become very tiresome. Try leaving them at “warn me”, at least to start, and you’ll see the impact.
One side note – make sure that you fully understand the differences between Serial Number and Lot tracking, and choose the right approach for your business situation.
You can turn off the feature without any big impact on your QuickBooks company file as far as I can tell at this time.
However, you might not be allowed to switch between the features. I’ve not worked out all of the details on this yet, but here is an example. I had a company file set up to use Lot Tracking for one of my blog posts. I then wanted to write THIS post, so I tried to switch. I just assumed that the lot tracking information would go away, and the serial number tracking would be turned on. However, that isn’t the case. I got this error message:
Looking in the QBWin.log file, I found a number of messages like the following:
SerialNumberQueries.cpp (158) : CHECKPOINT: 1880: Tue Sep 06 09:03:06 A record with unmatched quantity for item : Gravel and site : and Serial Number – 59 found. Quantity in SN – 300.00000, in Transactions – 1.
The short answer to this is that I couldn’t make the switch without doing a lot of work, perhaps deleting transactions.
This is a first release of serial tracking, so it isn’t surprising that there are some small glitches and features that aren’t included. I think that this is a good start, at least for some businesses.
If you need tight control over serialized items this isn’t your product, at least not yet. I’m not satisfied that you can operate this with proper separation of duties for your QuickBooks users. I’m also not satisfied with the reporting capabilities.
Here is a list of problems that I can see at this point:
On the other hand, I don’t see this creating big problems with your company data file, since serial numbers are kept separate from the item list. If there are problems with serial numbers it shouldn’t affect your data integrity, and you can always turn the feature off. This is a good first step, and it can save you from having to purchase an expensive add-on product if this covers the features that your business needs.
So, test it, think about it, before you jump in. Unfortunately, if you don’t have Advanced Inventory already, you have to purchase that to be able to test it.
Thanks, Intuit, for starting down this path!