I have a baq that allows me to calculate the qoh at a given date, but I need to know at a certain time of that date as well. Is there a way to do this using PartTran.systime and PartTran.sysdate?
Yes the record will have the running qty for the date you’re looking for. The query is a bit tricky… I’d do a subquery on parttran, getting the max sysrevid before your cutoff date parameter. Then join that to parttran again to get the data you need for output.