on 04-08-2013 2:31 PM
Hello SAP Experts,
Procedure :
Created Physical Inventory Document - MI01 Tcode
Entered Inventory Count - MI04 Tcode
Posted Inventory Difference - MI07 Tcode
After posting the difference if the Difference qty is +ve or -ve then material document is created.
Also quantity(In ERP Stock) of the material is replaced with the quantity(Counted quantity) entered in MI04 tcode at database level.
Requirement :
I need to retrieve previous quantity values for the material(i.e, posted by physical inventory document) due to error in typing quantity for the inventory count of PI Document.( In Simple, Material quantity values should be reverted back)
I need a tcode to get the previous quantity values of Material.
Clue
I found a tcode called MB59 to retrieve all the material documents of a material. Can I have any solution with this tcode to get the previous values back for the material at database level?
Note : I found one solution through SCN that we can get the previous quantity values by creating other PI Document with those previous values and post the inventory deifference. But I need simple process to get the values back
Thank you,
Swetha.C
once the physical inventory document is created, counts are entered and posted, you can not reverse that, so users who are entering the physical inventory counts should be careful before they post because if the wrong qty has entered and posted can not be reversed. To do so then again you have to follow the same process by creating a new physical inventory document and so on to correct the wrong entered qty.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
In addition to above replies, please note the logic behind the posting of material documents by PI :
- two movement types 701/702 get hit automatically.
-If you see the movement type setting in OMJJ, there is no setting of Reversal movement type for 701 and 702.
-The accouting effect of 702 mvt type is exactly reverse of 701 mvt. type.
-So, as Anoop said, if user need to again post PI if the ealier entered count is wrongly posted.
Hope, this is clear.
Regds,
Nilesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
there is no cancellation process for posted physical inventory documents.
After having posted you can only create a new document and do a new count.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Jurgen,
Thank you for your support.
We found one link http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MMIM/MMIM.pdf
In this document, it describes how to cancel/reverse material document.
Can you please look into it and let me know whether we can solve our requirement or not?
Thank You,
Swetha.C
I certainly know how to cancel a material document, e.g. with MBST or using theaction Cancellation in MIGO, or even using the reversal movement in MIGO.
But you can only cancel movements that you created as well in MIGO or in the old transaction like MB1A. But you cannot cancel a material document that got created automatically from another application like a goods issue from a delivery (has to be cancelled with VL09) or the physical inventory (no cancellation available - the normal process is a recount.
User | Count |
---|---|
89 | |
7 | |
6 | |
3 | |
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.