Quantity Available on Report

Hi All,
We're building an inventory consumption report and need some assistance with the correct function to report "Quantity Available". For us, it not just Quantity on hand - quantity on sales order = Quantity Available. There are other variables in the mix Quantity Available = Quantity on Hand + Q on PO – Q on SO + Q in Production – Q to transfer out + Q to transfer in. Anyone have a solution or can point us in the proper direction?


Thanks,
Tony