on 06-23-2015 2:11 PM
Hi,
Does anybody know if there is a transaction that can be run where you get a list of part numbers with their last stock adjustment date? By stock adjustment I mean movement type 701 - inventory difference in un-restricted use stock. So an adjustment to the stock on the system after a stock count has been done and the physical and system stocks were different.
Something like the below?
Part Number | Last stock adjustment date |
---|---|
Part 1 | 10/06/15 |
Part 2 | 23/05/15 |
Part 3 | 23/06/15 |
Part 4 | 14/04/15 |
Any help would be much appreciated.
There is no such list in SAP.
You can of course get the date of all 701 movements from MB51. But how will you differentiate between the last count and the last adjustment if both is done with a 701?
Further in a selection screen with multiple entries there is no technical link between an entered material number and an entered date. This link only exists from the selection screen if you have just one material or one date in your selection, but multiple materials and multiple dates does apply to all combinations of both fields.
If you know that all your materials which you enter have been counted on the same date, then you can use MB51 to list all 701 movements that have a posting date >counting date.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anthony
Did you already tried MB51, used with movement type 701? Click on details and you should see the posting date which in you case would be last stock adj. date (if I am not wrong).
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.