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

Uploading serial numbers in MIGO_GR screen

Hi all,

The customer is using serial numbers option while preparing the goods receipt against a purchase order through tcode MIGO_GR. The customer receives the material in huge quantities say 20000 nos. or more. At present in the MIGO_GR screen the user can only enter six serial numbers at a time, which has become very cumbersome for the customer to enter serial numbers for such huge quantites in the MIGO_GR screen.

The customer want to upload the serial numbers through the excel sheet in the serial number screen of the MIGO_GR. Please give a solution for the same.

Please give details of either BADI or BAPI or User exit resolving this issue.

Thanks in advance.

AJ

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Posted on May 20, 2010 at 05:19 AM

    hi

    try DWt check following note

    814215

    and How to import serial numbers in document lines via DTW (Data Workbench T)

    regards

    kunal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2010 at 11:30 AM

    Thanks for your prompt reply. I have seen that note since i have to upload the serial numbers in goods receipt at the time of creation of goods receipt. Please give a detailed process for the same.

    Thanks in advance.

    AJ

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 20, 2010 at 11:56 AM

    HI Kunal,

    I want to enter the serial numbers at the time of creating the goods receipt in (migo_gr) and the goods receipt document is not posted. The material will also not come in my stock unless i post the grir document. Whether this note will help to load serial numbers at the time of creation of goods receipt.

    Thanks in advance.

    AJ

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      enter t code OIS2 there is a checkbox which is assigned to your serial number profile(it s call "serial no mandatory" ). make it uncheck.

      then go to IQ04 enter your material and enter the first and last serial number as ur request...system ll create the serial nos..

      and when you make the GR click the "creat the auto serial no" checkbox.

      then you can check your serial number IQ09 t code..

      regards.

      Umit

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2010 at 04:43 AM

    Hi Umit,

    Thanks for your suggestion, we had already suggested the IQ04 option to the client, but he has some F&A related issue and does not want to use this option. He wants to have complete control by entering the serial numbers through GR only. But the problem is same, the material received in bulk is in thousands and entering the serial numbers manually in gr screen is very cumbersome. Hence he wants to upload the data in the gr screen through an excel file send by the vendor to them. Can you suggest some BADI or User Exit or Functional Module to resolve the issue.

    Thanks in advance.

    AJ

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi

      While doing GR , there is a Find option in the serial number tab(Binocular Button)

      Provided if the serial numbers are already created in the system, user can click that button after entering the material,plant,sloc etc in the migo line item , internally it will go to IQ09 tcode , then user can enter the range in the serial number from to field or user can enter multiple serial numbers by selecting the multiple arrow mark option in the serial number field, after getting the serial numbers list user can click the select all option at the left top corner(green button) so that system will take the serial numbers based on the qty entered in the MIGO line item.

      At a time user can select even 50,000+ serial numbers through this binocular option

      if there is range ask the user to enter the range , other wise from the excel sheet copy all the serial numbers and paste in the serial number multiple arrow mark field at one shot in the IQ09 selection after clicking the binocular button

      Regards

      Amuthan M

      Edited by: Amuthan M on May 21, 2010 10:27 AM

  • author's profile photo Former Member
    Former Member
    Posted on May 21, 2010 at 05:25 AM

    Hi,

    I think can use the user exits, IQSM001, program this according to your requirement with the help of abaper .

    regards,

    zafar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 27, 2010 at 10:21 AM

    12122

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2012 at 05:58 PM

    Hi Ashutosh,

    Can you please tell me how you were able to resolve this issue. Did you find any alternate solution for this issue?

    Thanks in advance.

    Mahidhar.

    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.