Item Usage by Customer Default Warehouse

I am in search of a way to see item usage history by a customers default warehouse regardless of the shipping warehouse. Currently everything I'm seeing is based on the movement from the shipping warehouse. The problem with this is when we ship from a warehouse that differs from the customers local/default warehouse we are not seeing where the true need is. We end up replenishing to the shipping warehouse instead of the "need" warehouse. I've made several attempts to modify one of the current inquires we use but haven't had any success. Am I overlooking something in Acumatica? Any help would be greatly appreciated!! I've included the current inquiry that I have been working with. Thank You!!