Check for duplicate serial numbers / Enforce unique serial numbers

Feature Request: 

Add a check that the entered Serial Number is unique to the Assembly module and the Stock Adjustment module (and anywhere else the below problem could be created).  

Here's why:

One of my clients has discovered a situation where it is possible to enter a serial number for a SKU which has been previously used.  This introduces a situation where it is possible to have more than one serial number for the same SKU, which is arguably, by definition, not possible/correct.

There is no mention in the documentation of FIFO - Serial or Special - Serial Number products having the ability to have duplicate serial numbers.  In fact, the DEAR documentation states for Special - Serial Number products in DEAR will "Each product will have its own unique identifier".  See the documentation here and below. 

To further demonstrate the kind of problem this flaw creates are the following examples.  Using the "FIFO - Serial Number" costing method, I was able to create both two assemblies with the same serial (batch) number (see Assembly #FG-00110 and #FG-00111) as well as a stock adjustment using duplicate serial numbers (see Stock Adjustment #ST-00034).  This is bad and a flaw in its own right.  Worse, when I did a sale (see Sale #SO-04012 for Acme Sports) of this product SKU with a quantity of two, it gave me quantity two (2) of the SKU with the same serial number in the Pick stage, which in the real world, should be impossible, at least from a business rules standpoint that there is one and only one serial number for a stock item for a given SKU.  See here:  See screenshots below.


It is my opinion that being able to add duplicate serial numbers is an issue in DEAR that should be improved.  Serial numbers for a given SKU are by definition unique.  Being able to get duplicate serial numbers into DEAR via Assemblies, Stock Adjustments, or any other means creates problems in the system.


Special Methods

Special - Batch

Special - Serial Number

Special methods require a batch or serial number to identify products and are not affected by when the items were added to your inventory.. If a batch or serial number is not specified, DEAR will automatically generate batch numbers for the product. The serial/batch number must be specified in the Pick stage of the sales process as well as the Stock Received of the purchase process. 

Special - Batch 

Use the Special-Batch Inventory Costing Method to determine the cost of goods using their assigned Batch numbers.

The DEAR Inventory system is capable of tracking goods sold, using an assigned Batch number, once the sold items are invoiced. This will allow user to trace goods in case a recall occurs or customer requires any information about the product/batch sold to them.

Special - Serial Number

Use the Special-Serial Number Inventory Costing Method to determine the cost of goods using their assigned Serial Numbers. Adding Serial Numbers to your product is extremely helpful to your business because:

Each product will have its own unique identifier and can be easily verified whenever there is a product return. You can also make sure that the product returned is from your store.

It makes handling of warranty and claims simple.

Your business’ product reporting will be accurate up to Serial number level.

Search within your Inventory or past Sale and Purchase Orders will be easier and save you time looking for a specific product.







5 people like this idea
  • Yes, yes, yes!! We just spotted this with a client who has a completely bespoke production per product, i.e. each product is engineered for a specific sale. Duplicate serial numbers will destroy this logic, especially because you can have the same serial, on the same SKU in the same warehouse more than once.

    2 people like this
  • Please can you give an update on this request. Special Serial Numbers feature is used by us in order to handle support and returns and tracking. By allowing duplicate serial numbers to be created on our Dear account, this makes the recall feature unuseable and defeats the purpose of serial numbers - i.e. to have a unique identifier. It is very easy for a staff member to try to enter a serial number twice by mistake.

    Could you add a tick box under General Settings > Inventory that says "Don't allow duplicate serial numbers"?

Login or Signup to post a comment