Stock difference

[Former Member]

Dear Experts,

My client had a problem with stock.

1. they have two systems of maintaing the stock a.Legacy Method 2.SAP Stocks

2. Now they got stock difference between Physical and their Legacy

3. Stock difference between legacy and SAP

Actual Physical stock of an SMF material is 500 MT

Legacy System showing it as 2835 T

SAP is Showing - 3000

Now they shifted the QTY of 2335 MT of stock as Rawmaterial RM1, with a note dated 01.09.2010.

with the above effect. SMF stock will be reduced, and a Rawmaterial stock will increase to 2335 MT.

The above arrangement is solving their key legacy report. But still sap is not satisfied. they came to a conclusion that with effect from now. legacy report will be terminated. ( Its really good sign) but my problem is how do I convert this stock since it is worth of Crores of Rupees value. please advise the procedure to satisfy the audit in future.

Regards,

Adi

[Former Member · Accepted solution]

Hi,

As the physical stock is different from SAP stock, diffference can be posted in SAP using physical verification procedure Tcode MI01, MI04 and MI07.

As the value involved is high finance / accounting department of client has to be involved to post the difference .

User department has to explain the reason for the huge difference before posting the difference in SAP.

Regards,

Janagiraman.

[Former Member · Accepted solution]

Dear Mr.Ram,

Could you please guide, step by step procedure. which will be very helpful to avoide mistakes.

thanks in advance.

Regards,

Adi

[Former Member]

thank you problem soved by introducing salvaging production system

[former_member197616]

Hi,

Please check the material documents happened for the material in sap at MB51 .If you feel that all the posted documents are correct and still you feel the diff between the legacy and the sap and physical stock, defintly some moments would not have in sap.if the intial balance of the stock at key date of sap and legacy matches? please check.

any way there is a diff in the stock with physical quamtyity.You may adjust the stock by posting a physivcal inventory document in sap at MI10 at with normal process of MI01 document creation etc, then it will be adjusted.If not you may need to identify the moments happened for the material and post in sap.does any POs pending for this material to get GR? oR ANY RESERVATION S FOR ISSUE? Please check.

Regards,

[Former Member]

Hi Adi,

If you are going to have only SAP system in future, Create a Physical Inventory docuemnt and post the difference.

So that the SAP is updated with the actual Physical Quantity.

regards

Senthil

[Former Member]

hi,

Check all reverse documents as properly reversed or not also check reversed deliveres and GRN's .

can be pending reverse activity ofsome document.

sans.