There might be a comprehension difficulty on my part, since I am not aware of your activities, so let me attempt my version of what I think would work:
You have a number of Products that are stored at Department "Home" and which are withdrawn by other Departments "Bakery", "Grocery", etc. and which may also be returned to Department "Home" afterwards. You want to know how much of each Product you have left at "Home" and how much is in each other Department. You also want to know the In and Out Mutation patterns for those other Departments. My approach is to include "Home" in the Department Table with its own ID# and to include the number of each Product that are at that location in your overall totals as an inventory control.
Thus: At the start, and each time brand new Product is purchased, add it to Home (a plus transaction in your Mutation table). When removing Product from Home to Bakery, it is a minus Mutation. When returning Product to Home it is a plus Mutation (but only to the Bakery). The total Product in Home at any time may have to be adjusted by the difference between the other Departments' net balance.
Example: 500 Product A exist at Home. 250 are withdrawn to Bakery during the quarter-year and 200 are returned by Bakery during the same period. If they used up 50 in the process that no longer exist, a minus Mutation would then be made to the Home Department to adjust the balance on hand to 450.
Am I even close?
