inventory - inventory transaction real time

Content

i use inventory - inventory transaction real time subject area, i need to create analysis

1- open balance for each item before specific date .

2- sum transaction between 2 date .

3- end balance = open balance + sum transaction

4- i need cost value for each item .

5- if i want to get invoice number from payable , can i add subject area in the same analysis.