Query Help - Onhand Inventory Date in Warehouse

[bbranco]

Hello, 
Can anyone help me with this?

I need a query to show if there is onhand inventory in a warehouse that was put in there greater than 2 weeks.

The customer has warehouse setup for returns, so all returns go in there so they can be quality checked before moving to the main warehouse for shipping.

I need a query to show me any item and inventory that is in there for longer than 2 weeks.

Example:
Item      Date           Qty
ABC1    04/05/25    100
ABC1    03/24/25    200
ABC1    02/20/25    150

I need to have the 3/24 and 02/20 in the query.

I am having problems figuring out what tables to use.  They are using Hana.

Thanks in advance

[williamwachholz]

Hello,

The main table that you need to search is OILM - Inventory Log Message Table

Best regards