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 .