[MOD][T7117] Change stock balance report query and add date field

Merged diego.barreto requested to merge T7117 into 12.0

Merge request reports