Splitting Expenses as inventory is distrubted

562 1
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

I am looking for a way to split expenses amongst people in our company without duplicating the total. We purchase company merch/promo items and that expense goes under our expense table and is assigned to 1 of our 7 offices, or corporate. We assign all promo expenses to "corporate". We then have an Inventory and an orders table. I add the inventory in as we buy more and add that to our expenses. Then, as the items are distributed to employees and partners those go under the orders table. The issue is the full expense amount remains under "corporate" instead of splitting it amongst the employees (who are assigned to a branch in the employees table) based on what is distributed to them in the orders table.

1 Reply 1
6 - Interface Innovator
6 - Interface Innovator

Hi Anna! Can you provide a little more insight into your base structure? I'm having trouble replicating which tables are linked to which and what relevant fields for this issue live in what table