Please try to help me the responce to our Customer

...

We going to start using Inventory Turnover Rate per Period analysis.
But we recieve different values of Issued Value from this place and summarize values from Inventory Transaction History.
We need to be sure how does it work, before we send this analysis to managers.

Here is the example on TEST db:
part_no = 1000001
contract = PLGDY
periods from 2021 01 to 2021 12
and we receive Issued Value = 33036,68 and Average Inventory Value = 2635,91

while from Transaction History
part_no = 1000001
contract = PLGDY
created 2021-01-01..2021-12-31 (Applied Date also)
we receive such values of transactions:
ARRIVAL        31 534,80
INTSHIP        28 321,68
INTUNISS                  66,94

and from Inventory Value per Period avg. value =  2 303,31

end of period    total value    
2021-01         1 802,66     
2021-02         1 110,66     
2021-03         1 058,76     
2021-04            692,00     
2021-05         1 664,30     
2021-06         2 636,70     
2021-07         3 216,38     
2021-08             -0,01     
2021-09         3 781,18     
2021-10         1 280,04     
2021-11         5 425,14     
2021-12         4 971,94     
                 2 303,31 = Avg. Value

Is there a bug in analisys procedure? How does it work?

….

It seems to me that depends on statistics are generated. Am I right?