ZMB5B - Material Stocks at a given date (Basic Trial Balance)

Transaction: MB5B

Purpose: To show the stock in quantity and value at a given date.

The standard report MB5B has been converted to normal ALV, in order to be able to export it to Excel.

The report will give one line per item showing the basic figures:

• Starting Balance Quantity / Value for the first date of the period we put
• Receipt Quanity / Value for the period we choose. Receipt means ANY incoming movement (Purchase, Surplus e.t.c)
• Issue Quantity / Value for the period we choose. Issue means ANY outgoing movement (consumption, sales, shortage e.t.c)
• Closing Balance Quantity / Value for the period end we choose.

Demonstration to get the Spare Parts Stock at 30/09/2020.