cancel
Showing results for 
Search instead for 
Did you mean: 

Ageing Inventory/Stock Report in SBO

hemish
Explorer
0 Kudos

Hi,


I’m trying to create a query in SAP business one for ageing stock inventory. There is a system build report in SAP called Ageing Stock Report, how can I extract the query so I can modify it? Or the next best option of to write the query.

I’ve started to write query from OINM table, but getting stuck when having an age bucket the stock is using right bucket. I need to know how old the stock is in months as of now.


Eg stock A

we bought 5 pieces in 2019

We sold 2 Qty in 2021

In 2023 we bought another 10 pieces but we sold 8 qty the same year from the stock we bought in 2023


I want this for my whole inventory list .


Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

Neeraj_Jain
Active Contributor
0 Kudos
hemish
Explorer
0 Kudos

Hi,

Thank you for your reply.
Can this be done in a query which I can modify in my format?


Thanks