Splitting details and tallies in portals - eg an inventory with 2 stores
I saw the post on how to link your sales to your inventory - Managing Inventory using a Transactions Ledger. It got me started: I expanded my "order details" table (which includes sales info) to include fields for "Quantity In" and a calculation (Quantity In - Sales Quantity) and a summary field to make a total of the calculation field. I also added an Inventory date field.
The problem I'm having is that I have 2 stores. So when I go to my Inventory layout, which uses the Product table with a portal for Order Details - I see all the data for both stores - and the tallies are for both stores instead of separated out for each one.
I know this shouldn't be that complicated - I was thinking there should be a button or something to either sort or filter by the Location field (in the Order Details table) - but I just haven't worked out how to do it yet!
Any help gratefully received.