Skip to Content
author's profile photo Edward Mahoney
0
Edward Mahoney

LI20 - How to know what user cleared count in WM?

Posted on Aug 18, 2016 at 10:43 AM 1.4k Views

I am looking to find out when a user executes LI20 to clear a count in WM where I can find their user name?

I can find from the count document the user who entered the count and I can find from the IM ISEG table document who made an adjustment via LI21.

However I do not seem to be able to find who cleared the WM count if no inventory discrepancies were found?

We are developing a custom report to show counts are happening, who entered them, who cleared them, who adjusted them, however I am struggling to find the user who performs LI21.

Any ideas?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Rosh A
    Rosh A
    Posted on Aug 18, 2016 at 01:14 PM
    3

    Hi Edward,

    There is no field "Username" in the tables "LINP" & "LINV". Even LX22 also doesn't have user information who cleared the bin. So I think the data you expected, is no where available and better ask users to include an inventory reference for tracking purpose.

    BR, Rosh.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 18, 2016 at 11:14 AM
    2

    Hello,

    When you book the WM Write off with LI20 a Transfer Order is created which moves the stock from the storage bin to the 999 storage type thus you can find the user name in table LTAK for the user id processed the transaction LI20 for which the TO gets created in the system.

    So you need to have a logic based on a reference field say movement type from the LTAK table as whenever you have a Movement as 711 in case of LI20 user details should be picked in your customized table from LTAK.

    Regards,

    Gopal.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Edward Mahoney
      Aug 18, 2016 at 01:30 PM

      Hello,

      As if the difference quantity is zero in that case the inventory active check box gets removed for that particular storage bin once you post the WM write off & as Rosh mentioned there is no standard table update with the user name details.

      Regards,

      Gopal

    Comment on This Answer
  • author's profile photo Former Member
    Former Member
    Posted on Aug 24, 2016 at 09:07 AM
    0

    Hi,

    In LINV-UNAME might help along with LINV-ISTAT(inventory status).

    Thanks,

    Hari.

    Add a comment
    10|10000 characters needed characters exceeded

    Comment on This Answer

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.