cancel
Showing results for 
Search instead for 
Did you mean: 

Reversal of Physical Inventory Document

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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.

Answers (2)

Answers (2)

Former Member
0 Kudos

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

JL23
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Hello Jurgen,

Is there any solution to get the quantity values of material back with material document?

Thank You,

Swetha.C

Former Member
0 Kudos

Hello Experts,

Is there any way to get the quantity values back for a material by cancelling or reversing material document creted with new counted ones of physical inventory document?

Thank You,

Swetha.C

JL23
Active Contributor
0 Kudos

No, it is not possible to cancel material document for automatic movements.

Former Member
0 Kudos

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

JL23
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Jurgen,

Thank you very much for the solution.

If possible, please elaborate with an example.

Thank You,

Swetha.C