Inventory-Physical Stock and SAP stock not matching

[Former Member]

Dear All,

Our client has an issue wherein physical stock and SAP stock are not matching. Physical stock is showing less. Now, they are asking us to match this with SAP stock.

Kindly suggest what would be the best way to do this. I checked with the client what has happened to the physical stock and why it is showing less, they said you do not worry about that, just make an adjustment in the system.

Thanks and Regards

Adithya.

[BijayKumarBarik · Accepted solution]

Hi,

You can reduces stock by doing physical inventory process with t.codes: MI01 , MI04 and finally MI07.Do assignment of G/L account for Gain/Loss-Inventory difference with key GBB-INV with your chart of account with valuation class.

During posting in MI07,based on your requirement,stock will reduces and have following accounting entries with Movement Type  702.

(BSX) Stock A/C  -  Cr

(GBB-INV) Gain/Loss Inventory difference  A/C -  Dr

Regards,

Biju K

[Former Member]

An adhoc adjustment can be done for the material using MI10 if the plant & sloc are not warehouse managed.

If it is warehouse managed use MB11 T.code with 711 for adjusting down and 712 for adjusting up. Here you can also specify the storage bin in which you wish to carry out adjustments and storage type in which the bin recides should not have a capacity check active.

[former_member182609]

Check with finace team either you can match excessive stock issueing the goods 551 scrapping or Physical inventory process.Which one they intrested then follow the process.

[Former Member]

Hi

If you want to match the physical stock with system stock follow the physical inventory process system will update the quantity accordingly and profit and loss account will hit

Mvt type 701 and 702

[kailas_ugale]

HI,

You have to carry out physical inventory process at your end and and every year have to for closing and opening balance match and for  balance sheet of company and audit purpose also.

check following link

http://help.sap.com/saphelp_470/helpdata/en/4d/2b8cde43ad11d189410000e829fbbd/content.htm

http://scn.sap.com/thread/674979

http://scn.sap.com/thread/1528098

Kailas Ugale

[Former Member]

two ways

- you can writeoff the stock from the SAP stock by scrapping. Issue the difference stock in SAP to scrapping. You can do this if the stock is damaged and some cost center can incur this loss

- you follow the physical inventory process where you can adjust (goods issue or goods receipt) the physical and SAP stock. you follow above mentioned process and use 701 movement in MI07 to remove the stock from SAP.

[Former Member]

Hi,

Adding to tej's points,

you can do physical inventory in one step using MI10 t code and if the storage location is warehouse managed use LI01N, LI11N and LI20 t-code for creating Physical inventory doc, enter the count results and write off the difference respectively.

Regards.

[tejyadav]

Do it with Physical Inventory, T-codes to use is , MI01, MI04 & MI07, Search on SCN for usage of Physical Inventory in SAP, In this way you can match SAP & Physical stock with proper Accounting entries hitting to Gain & Loss Account.