Able to enter the same Serial Number after selling

(0) Share

Report

Posted on by Suet Lee

1,351

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?

*This post is locked for comments

I have the same question (0)

All responses (9)

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suggested answer

sandipdjadhav 18,306 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Suet Lee 1,351 on at

Like (0)

Report

Thanks for the reply both.

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Dynamics GP will not allow.

Thanks

Sanjay

Was this reply helpful? Yes No
Suggested answer

L Vail 65,271 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suet Lee 1,351 on at

Like (0)

Report

Hi Leslie,

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

Was this reply helpful? Yes No
L Vail 65,271 on at

Like (0)

Report

Hi Suet,

Please let us know what you find out!

Thanks,

Leslie

Was this reply helpful? Yes No
Pam Robertson 4 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suet Lee 1,351 on at

Like (0)

Report

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

Was this reply helpful? Yes No