In the table ITMMVTHIS, you will found the total quantity issued from stock in the year for a specific product and specific site. The field YEAISSQTY is the one to use. Just pay attention because the key for this table is per product-site and fiscal period. So if you need the total quantity for 2020 be sure to select the last period of the year (most likely 01/12/2020).

In the table ITMMVTHIS, you will found the total quantity issued from stock in the year for a specific product and specific site. The field YEAISSQTY is the one to use. Just pay attention because the key for this table is per product-site and fiscal period. So if you need the total quantity for 2020 be sure to select the last period of the year (most likely 01/12/2020).

For the record, stock count issues are not included because this is not a real issue but a stock adjustment.

Nice catch Julien.

So PTD is YTD - prior period total.   

This seems somewhat simpler than using a statistic but requires a calculation to locate the record and the totals. So you can't just display it.  

Our conversion utility for Sage Pro/Process Pro does not build this movement history record.

In Sage Pro/Process Pro there is one field that stores the number so it can be displayed on a static screen.  There is also a history file similar to movement history.