Able to enter the same Serial Number after selling

(0) Share

Report

Posted on by Suet Lee

1,347

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

All responses (9)

Answers (0)

Suet Lee 1,347 on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

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
Pam Robertson 4 on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

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?
L Vail 65,271 on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

Hi Suet,

Please let us know what you find out!

Thanks,

Leslie
Suet Lee 1,347 on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

Hi Leslie,

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

L Vail 65,271 on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

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
Community Member Microsoft Employee on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

Dynamics GP will not allow.

Thanks

Sanjay
Suet Lee 1,347 on at

Like (0)

Report

RE: Able to enter the same Serial Number after selling

Thanks for the reply both.

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

sandipdjadhav 18,267 on at

Like (1)

Report

RE: Able to enter the same Serial Number after selling

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
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Able to enter the same Serial Number after selling

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