Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  MI02 Change Physical Inventory Document

    Posted 04-18-2019 07:47
    ​​All,
       I'd like to use Winshuttle to do a mass delete of materials using the MI02 transaction.  The issue is that every Physical Inventory Document has a different number of materials which were counted.  It would be ideal to be able to pass a number to Winshuttle and have it execute the steps necessary to delete the materials.
       If anyone has been successful, I'd appreciate your solution.

    ------------------------------
    Don Martin | Supply Chain Analyst
    General Motors Company (GM) | 586-335-0280
    ------------------------------


  • 2.  RE: MI02 Change Physical Inventory Document

    Posted 04-18-2019 08:46
    Hi Don,
    Do you know what the maximum number of materials is ? You could either try this in batch input mode or if you know the maximum number of records each set always record for one, then add a skip if not present icon to that action and then duplicate (Copy/paste) it to the number of lines you need. This way the number of materials count will not effect your script.

    ------------------------------
    Isra Azam |
    Exxon Mobil Corporation
    ------------------------------



  • 3.  RE: MI02 Change Physical Inventory Document

    Posted 04-18-2019 09:17

    Isra,

       Thank you so much!  Your thought sounds promising, I'll try it and let the group know.  ��

     

    Donald R. Martin

    SAP / IMM Operations and Transformation

    GBS New Logo - Email

    Mobile           : 586-335-0280

    CONFIDENTIALITY NOTICE:
    This message and any attachments relate to the official business of General Motors and are proprietary to General Motors.  This e-mail is intended for the above-named persons(s) only and is confidential, proprietary and/or legally privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on this information is strictly prohibited.  If this message has come to you in error, please immediately notify the sender by telephone or return e-mail and delete the original transmission and its attachments without reading or saving in any manner.

     

     



    Nothing in this message is intended to constitute an electronic signature unless a specific statement to the contrary is included in this message.

    Confidentiality Note: This message is intended only for the person or entity to which it is addressed. It may contain confidential and/or privileged material. Any review, transmission, dissemination or other use, or taking of any action in reliance upon this message by persons or entities other than the intended recipient is prohibited and may be unlawful. If you received this message in error, please contact the sender and delete it from your computer.


    ------Original Message------

    Hi Don,
    Do you know what the maximum number of materials is ? You could either try this in batch input mode or if you know the maximum number of records each set always record for one, then add a skip if not present icon to that action and then duplicate (Copy/paste) it to the number of lines you need. This way the number of materials count will not effect your script.

    ------------------------------
    Isra Azam |
    Exxon Mobil Corporation
    ------------------------------


  • 4.  RE: MI02 Change Physical Inventory Document

    Employee
    Posted 04-18-2019 08:50
    Hi Don - Would it be possible to use Query to extract what you want to delete ahead of time?  That way you'd know what you need to work with.
    Best Regards,
    Sigrid


  • 5.  RE: MI02 Change Physical Inventory Document

    Posted 04-24-2019 10:13
    You can get the number of lines for each physical inventory document from table ISEG. 

    Once you have that, you can create a script that uses inventory document number and line number to delete each line.  Inside MI02 you can go to "Edit" then "Position Cursor" to get to the line number, then "Edit" and "Deletion Indicator On/Off" to set the flag and save the document. 

    I have to ask though, it looks like setting the deletion flag for each line in an inventory document deletes then entire document.  If that's the case, why not just do that?

    ------------------------------
    Michael Shaw | Master Data Analyst
    Southeastern Mills, Inc. | 706-291-6528
    ------------------------------



  • 6.  RE: MI02 Change Physical Inventory Document

    Posted 04-25-2019 07:08

    Michael,

       Thanks so much for your ideas.  Fortunately, my business customer created all of their PI documents with 333 items for counting.  Their problem was the population of items to be counted was incorrect and the document numbers needed to be deleted.  In our instance of SAP, the MI02 transaction requires clicking on each item and then the delete button.  Once all items are flagged, then once saved the document is deleted.

       That said, we were able to put together a script to deleted the PI documents.  Thanks again.  

     

    Donald R. Martin

    SAP / IMM Operations and Transformation

    GBS New Logo - Email

    Mobile           : 586-335-0280

    CONFIDENTIALITY NOTICE:
    This message and any attachments relate to the official business of General Motors and are proprietary to General Motors.  This e-mail is intended for the above-named persons(s) only and is confidential, proprietary and/or legally privileged.  If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on this information is strictly prohibited.  If this message has come to you in error, please immediately notify the sender by telephone or return e-mail and delete the original transmission and its attachments without reading or saving in any manner.

     

     



    ------Original Message------

    You can get the number of lines for each physical inventory document from table ISEG. 

    Once you have that, you can create a script that uses inventory document number and line number to delete each line.  Inside MI02 you can go to "Edit" then "Position Cursor" to get to the line number, then "Edit" and "Deletion Indicator On/Off" to set the flag and save the document. 

    I have to ask though, it looks like setting the deletion flag for each line in an inventory document deletes then entire document.  If that's the case, why not just do that?

    ------------------------------
    Michael Shaw | Master Data Analyst
    Southeastern Mills, Inc. | 706-291-6528
    ------------------------------