Try Microsoft Edge
A fast and secure browser that's designed for Windows 10
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?
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.
/****** 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.
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.
Thanks for the reply both.
But what is the reason Dynamics GP allow duplicate serial number in the first place?
Dynamics GP will not allow.
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.
Thanks for your reply. Will see if i can check with the Microsoft team on the logic behind the design
Please let us know what you find out!
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?
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.