Able to enter the same Serial Number after selling

Question Status

Suggested Answer
Suet Lee asked a question on 24 Mar 2016 9:56 PM

Hi,

In GP i was able to  enter the same serial number after selling the item. Example, i have received item 100XLG serial number 10000, subsequently sell it. After that, i redo another shipment and i was able to enter the same serial number and post.  

Has anyone experience this before?

Reply
Suggested Answer
Sanjay Kumar Rajarao responded on 25 Mar 2016 5:11 AM

IV00200 is the Item Serial Number Master table.  SERLNMBR is Serial Number field.

IV00200 has following indexes

Script for AK3IV00200 shows  the index is unique non clustered for itemnumber - serial number combination.

USE [TWO]
GO

/****** Object: Index [AK3IV00200] Script Date: 3/25/2016 3:44:01 AM ******/
CREATE UNIQUE NONCLUSTERED INDEX [AK3IV00200] ON [dbo].[IV00200]
(
[ITEMNMBR] ASC,
[SERLNMBR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

Therefore duplication should not be possible.  I tried to add a duplicate record got this message in SQL

The record i inserted matched the values for a sold serial number 5.

attempted to enter an inventory adjustment entry with serial number 5

Therefore  item - serial number duplicates is not allowed.    You should check the records in IV00200 table and compare the values for the serial number field to see if there are any hidden / non visible characters in one of the record for serial number field.

Cheers!

Sanjay

Reply
Suggested Answer
Sandip Jadhav responded on 25 Mar 2016 11:21 AM

Hi Lee,

Sanjay has given great reply. But I still don't want to and make changes in Database level as it will be revert back on upgrade and patch installation. Instead of that small VBA code can check duplicate serial number alert with message.

Tks

Sandip Jadhav

Reply
Suet Lee responded on 28 Mar 2016 12:51 AM

Thanks for the reply both.

But what is the reason Dynamics GP allow duplicate serial number in the first place?

Reply
Sanjay Kumar Rajarao responded on 28 Mar 2016 10:10 AM

Dynamics GP will not allow.

Thanks

Sanjay

Reply
Suggested Answer
Leslie Vail responded on 28 Mar 2016 6:56 PM

Hi Suet,

I believe this is working as designed. The system does not keep track of all of the serial numbers you have ever had and prevent you from using the same serial number twice. You just can't have two items (with the same part number) with the same serial number at the same time. You can buy and sell the same serial number as much as you want. I'd never really thought about it, but you bring up a good point.

Kind regards,

Leslie

Reply
Suet Lee responded on 28 Mar 2016 10:37 PM

Hi Leslie,

Thanks for your reply. Will see if i can check with the Microsoft team on the logic behind the design

Reply
Leslie Vail responded on 31 Mar 2016 11:22 PM

Hi Suet,

Please let us know what you find out!

Thanks,

Leslie

Reply
Pam Robertson responded on 12 Oct 2017 1:31 PM

Suet, we just had this happen to a customer, which is disconcerting.  Did you find out anything from Microsoft about how and why this is allowed?

Reply
Suet Lee responded on 12 Oct 2017 8:22 PM

Hi Pam,

Microsoft has confirmed that this was the way Serial Numbers were designed to work in GP

We have raised this as a product suggestion. Kindly log in to Vote hopefully Microsoft can add this control in the coming GP release.

connect.microsoft.com/.../gp-is-allowing-to-use-duplicate-serial-numbers-after-the-items-are-sold

Thank You

Reply
Suggested Answer
Sanjay Kumar Rajarao responded on 25 Mar 2016 5:11 AM

IV00200 is the Item Serial Number Master table.  SERLNMBR is Serial Number field.

IV00200 has following indexes

Script for AK3IV00200 shows  the index is unique non clustered for itemnumber - serial number combination.

USE [TWO]
GO

/****** Object: Index [AK3IV00200] Script Date: 3/25/2016 3:44:01 AM ******/
CREATE UNIQUE NONCLUSTERED INDEX [AK3IV00200] ON [dbo].[IV00200]
(
[ITEMNMBR] ASC,
[SERLNMBR] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
GO

Therefore duplication should not be possible.  I tried to add a duplicate record got this message in SQL

The record i inserted matched the values for a sold serial number 5.

attempted to enter an inventory adjustment entry with serial number 5

Therefore  item - serial number duplicates is not allowed.    You should check the records in IV00200 table and compare the values for the serial number field to see if there are any hidden / non visible characters in one of the record for serial number field.

Cheers!

Sanjay

Reply
Suggested Answer
Sandip Jadhav responded on 25 Mar 2016 11:21 AM

Hi Lee,

Sanjay has given great reply. But I still don't want to and make changes in Database level as it will be revert back on upgrade and patch installation. Instead of that small VBA code can check duplicate serial number alert with message.

Tks

Sandip Jadhav

Reply
Suggested Answer
Leslie Vail responded on 28 Mar 2016 6:56 PM

Hi Suet,

I believe this is working as designed. The system does not keep track of all of the serial numbers you have ever had and prevent you from using the same serial number twice. You just can't have two items (with the same part number) with the same serial number at the same time. You can buy and sell the same serial number as much as you want. I'd never really thought about it, but you bring up a good point.

Kind regards,

Leslie

Reply