Hi Rachid, There are a few stock inquires you can use for this purpose. Stock by date (CONSSDA), Detailed stock (CONSSDE), and Stock transactions (CONSSMV). For example, if you run the detailed stock inquiry to lookup the initial stock quantity and then tunnel into the stock transactions inquiry to get a detail movement information. Additionally, use the function help to review the tables used for your script.

Thanks Joel , i will try.

The Table of Stock in a specified date is ITMMVT but i didn't find the column DATREF "Date"

What version and patch level are you on?

V11

i solvedthe issue the Sources Table are ITMMVH and STOJOU thanks

Care to share how you did it?

If you aggregate the total amount per giving month  ,you will end with just the total transactional value , not the inventory value.

I've solve it by using windows function (SQL/SEI) to include running value since the start on sage (in STOJOU tables)

Meaning that I had to sum all transaction for giving material(s)  until giving date.

Nice to hear that we tried on bi solution but it is complicated situation 

Technically if you have no need for site , you can use this SQL logic

SELECT ITMREF_0,SUM(QTYSTU_0) FROM PROD.STOJOU
WHERE ITMREF_0 = '30687073082808' AND CREDAT_0 <= '01/01/22'
GROUP BY ITMREF_0

CREDAT can be converted to parameter 

for SEI , I just repurpose the cube for STOJOU (can be used the ERP tables with any other SEI package) , I've converted date to MM-YY in calculated column 

and then used the built in windows function

Technically if you have no need for site , you can use this SQL logic

SELECT ITMREF_0,SUM(QTYSTU_0) FROM PROD.STOJOU
WHERE ITMREF_0 = '30687073082808' AND CREDAT_0 <= '01/01/22'
GROUP BY ITMREF_0

CREDAT can be converted to parameter 

for SEI , I just repurpose the cube for STOJOU (can be used the ERP tables with any other SEI package) , I've converted date to MM-YY in calculated column 

and then used the built in windows function

Thank you very much for your kind explanation