I have a BAQ that displays all partnum, warehouse, and bin and current on hand balance if it is below 0. It is our negative balance report. I want to add a column that displays the total site quantity so the user can easily see if we are actually negative or if the inventory is just in the wrong warehouse.
I cannot figure out how to get it to work to sum the site quantity and add that as an additional column into the original BAQ. Has anyone done something similar that can provide me some instruction? We are running the most recent version Kinetic 2022.2.