inventory in warehouse report

[Yatin_Talkar]

Please provide me with a query for an 'Inventory in Warehouse Report' that allows for:

- Date-wise selection
- Item group selection
- Warehouse selection

The report should display the following details:
- Last purchase price
- Total value of the quantity in the warehouse

Additionally, it would be ideal if the report displays all items in a particular warehouse grouped by item groups, along with their totals.

[Dominik_Tylczynski · Accepted solution]

Hello @Yatin_Talkar 

I don't think you will find a single standard transaction suiting your needs. You'd rather need to combine data from a couple of reports:

• MB52 - current stock
• MB5B - historical stock for posting date
• ME2L, ME2M - purchase order reports (purchasing price)
• ME1L, ME1M - purchasing info records 

Consider the note 453888 - FAQ: Reporting in purchasing, point 2 on how to activate ALV display in purchasing reporting with the user parameter ME_USE_GRID.

Best regards

Dominik Tylczynski

[Yatin_Talkar · Accepted solution]

Hello Sir,

[Yatin_Talkar · Accepted solution]

Hi Sir,

[Yatin_Talkar · Accepted solution]

this is not working properly

IF @object_type = '22' AND @transaction_type = 'U' BEGIN DECLARE @CurrentUserID INT -- Get the current SAP B1 user ID (not using INTERNAL_K) SELECT @CurrentUserID = USERID FROM OUSR WHERE USER_CODE = CURRENT_USER -- If the user is NOT allowed IF ISNULL(@CurrentUserID, -1) NOT IN (1, 17, 19) BEGIN IF EXISTS ( SELECT 1 FROM OPOR WHERE DocEntry = @List_of_cols_val_tab_del ) BEGIN SET @error = 10001 SET @error_message = 'You are not authorized to update Purchase Orders.' END END END