on 08-18-2016 11:43 AM
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In LINV-UNAME might help along with LINV-ISTAT(inventory status).
Thanks,
Hari.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Gopal!
Yes I was aware of that as an option, however in the case where there is no difference and as a result no transfer order to move to storage type 999. I am looking for a record of who completed LI20 even where no inventory difference was found, so just when they complete the count to unblock the bins.
Any ideas?
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.