I am very much frustrated to inform all of you gurus of SAP that there is NO single RELIABLE report in SAP which give me correct BACK DATED stock report in simple format of:
Material Special Stock (SO/WBS etc) Opening Stock/Value Receipts Qty/Val Issue Qty/Val Closing Stock/Value
I tried MB5B. But, it does not show Special stock and warehouse stock together in one screen, neither it shows correct Issue/Receipt value (because it adds 321 mvt qty to both issue and receipt, also similar movements like 412 E/413 E etc gets added to issue/receipt). This is not acceptable to us, we only want actual quantity received and quantity issue. If some third party is interested in viewing total issue qty and total receipts, I have to reside on manual calculation from MB51 (which is long, tedious and unreliable method).
I tried almost all reports suggested in this forum like MC.A, MC.9, MC.1, MCBA (ohh this list is loooooooong)... but none of them suiting my format (which is quite simple, and standard if you see by a Store person point of view).
I even tried J3RFLVMOBVED - Stock over view (Russia), and that too adds 321 mvt qty to both issue and receipt.
Some body suggested S_P00_07000139 (this comes straight from Thailand).. and sadly its also of no use to me...
I like the layout of MB52, which shows all kind of stocks, but it shows only as-on-date stock.. 😔
I don't want to go for development. (Why should I?)
Now suggest me what should I do?
-The Unknown talent