Most businesses need to see the individual transactions that modify their stock levels--sales, shipments received, shrinkage, breakage, etc.
One way to do this is to set up a table as a transactions ledger where each time a transaction takes place that changes inventory, a record is created in this table that records the amount added or removed from inventory. FIleMaker then subtracts the total removed from the total added to compute the current amount on hand.
Here's one example of that method: Managing Inventory using a Transactions Ledger
Thanks Phil for the info but, this is a "hobby" business with over 7500line items and I don't keep transactional records at all ... not required
is there a simpler way?
The "transactions" are not necessarily the purchase/sale of inventory items though that is what is illustrated there. Anything that would increase or decrease your inventory makes for a transaction.
You can set this up without an invoicing system and just have a ledger like layout with an "in" and an "out" field where you can add or remove items and FileMaker can then do the match for you.
ok thank you