Skip to Content
author's profile photo Former Member
Former Member

Delete Serial Number

Hi All,

Is it possible to delete a serial number completely from the database. I am able to set active Inactive and deltion indicator, but not able to delete the serial number. I want to use the same serial number, which is only possible by deleting the serial number not by deactivating and setting deletion indicator.

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 08:48 AM

    HI

    I assume that serial status in IQ02 is ECUS, so you cant use the same serial number for other deliveries as system governed by rules with the help of serial proflile

    Work around for this issue is Do reverse of GI and again Do GR for the same serial number.

    Regards,

    Ram.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 06:56 AM

    Hi,

    Since you want to use the same serial number Using IQ02, change the stock information based on your requirement,

    Can you explain in detail what information your goin to maintain for the same serial number

    You cannot delete a serial number from the database, since the serial number table will have a complete history so that it can be used for future reference.

    Regards

    GK.

    Edited by: Gnana Kumar on Oct 28, 2010 8:57 AM

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 28, 2010 at 07:23 AM

    hi,

    Recently I hd got the same issue (Materials Management). I was not able to delete the serial number, instead I was able to do business process.

    Issue: We had issue materials for sub-contracting to vendor with materials in serial no's, but while doing GR for the finished materials system should not ask for the serial no. entry for the finished product. as we are not maintaining serial no. for finished product.

    we found that in the material master serial no. profile was assigned wrongly by the users.

    Resolution:

    We cannot delete the serial no's once it was created, instead Create a new profile with only (GR/GI ) MMSL procedure. and serial no. usage is 01.

    Change the new serial profile which is created and do the Good posted, and this will resolve the issue.

    Hope it will be useful

    regards,

    balajia

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.