Comparison of Lot and Serial Number Tracking between All Orders and QuickBooks
What can All Orders by NumberCruncher Lot & Serial # tracking do that QuickBooks cannot?
QuickBooks forces you to select either Lot OR Serial # tracking. You cannot do both.
Quickbooks does not let you specify tracking for only specific items. Once you turn it on for the company, the tracking is enabled for every item.
QuickBooks has no way to store expiration dates or any other qualitative information associated with a particular lot or serial #. All Orders has expiration dates, up to 30 custom fields and attachments for EACH lot or serial #.
Quickbooks has no way to force lot/serials to be entered leaving the possibility for data entry errors. It means that I can sell an item without specifying a lot/serial even though in my business it should be required. While there is an option to be warned if a lot/serial is not entered, because it is enabled at the company level it will warn for EVERY item. In addition, when selling an item, a manually entered lot/serial can be used that has never been entered before and should not be available for sale.
There is absolutely no connection between the total quantity from all lot/serials and the quantity on hand for an item. You can have lots with a quantity that is greater than your quantity on hand, for example. To illustrate this, a new lot/serial adjustment can be created which will change the quantity in a specific lot/serial but that will not change the overall quantity on hand for the item. A separate item adjustment must be created for that.
Quickbooks has no specific lot/serial costing so there is no way to properly see the costs when quantity is debited or to audit Quickbooks to make sure it is using the correct values.
Quickbooks does not allow any spaces in lot/serials.
Quickbooks does not support specifying which lot/serials from components go into which lot/serials of the assembly when building. In essence this means that true tracking is not supported for all but the simplest of builds and will not work for most multi level assemblies.
Quickbooks does not support scanning of lot/serial barcodes.
Quickbooks has no way to prevent the entering of duplicate lot/serials.
Quickbooks only supports a single lot for each line on a transaction. To enter multiple lots you must create multiple lines. As an example, if you want to sell 200 units of an item and have 2 lots with quantity of 100 each, you must create two separate lines to sell both lots.
Quickbooks has no way to auto generate new lot/serials
Quickbooks lot/serial reports are extremely limited and offer no real customization. There is no report to get a list of lot/serials for each item and how much is in stock for each one. In addition, if a single item has a long list of lot/serials it will only display a limited number of them.
The only way to do a lookup on a lot/serial is through the reports. There is no quick lookup screen.
Requires Quickbooks Enterprise and the purchasing of the Advanced Inventory feature.