AnsweredAssumed Answered

Splitting details and tallies in portals - eg an inventory with 2 stores

Question asked by SamRich on Jul 19, 2013
Latest reply on Jul 19, 2013 by philmodjunk

Title

Splitting details and tallies in portals - eg an inventory with 2 stores

Post

     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. 

Outcomes