Skip to Content
0

Sort my inventory by date received

Jan 03 at 06:59 PM

78

avatar image
Former Member

Hi all,

I am very new to SAP and have only had minimal training. If someone could help it would be greatly appreciated. I would like to sort all the current inventory in my location by the date it was received. Goal is to clean out all the older material. I need the list to be by date received and to show the batch # and material. Will then need to export to Excel.


Thank you!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Amit Sharma Jan 04 at 06:11 AM
-1

Hi,

Kindly use MB51 transaction.

Select the selection parameters like Material, Batch, plant , posting date and execute and then export the data in excel

Regards,

Amit

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 17 at 06:48 AM
-1

Hi Ali,

You can use Tcode MB5B for stock having selection date option in the selection screen.

Regards,

Arsh

Share
10 |10000 characters needed characters left characters exceeded
PRASOON AK Jan 17 at 06:01 PM
0

Hi,

If there is no batch management, there is no identification on the stock in system. Inventory without batch in SAP is like filling your fule tank - You can not identify fuel filled from which fuel station is getting consumed and which is left in the tank. However, you may go for assumption of FIFO and generate custom report considering the receipt and issues - there are many threads regarding inventory aging. Also, MCBE report can provide you the last recipt and issue date for the materials which may be used for analysis.

If you have batch managment, you can identify the receipt date from batch master and use it for analysis.

Regards,

Prasoon

Share
10 |10000 characters needed characters left characters exceeded