Hello i working on SCRIPT of Stock in a BI TOOL i want to have initial stock,amount of incoming quanity what ever transaction ID . and outcome is there a way to have the stock in a speciefied date a table which give this information

because STOJOU inclide just all mouvements.

Parents
• 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

• Thank you very much for your kind explanation