Tracking Inventory/Sales & Purchases
I stumbled across you post (http://forums.filemaker.com/posts/a6ef951917) while searching for a answer to how manage my stock levels. I am using a solution, where I have invoices and they track my stock levels, as long as I add them manually.
Say I create a product and add 10 to stock in hand. Then after sales and sales, they reduce. I can only increase my stock on hand if I manually add them.
What want to do it to create a relationship where I can "buy" more stock, which would also track my expenditure when increasing my stock.
Someone said in another post in another forum that I could make some change to the Invoice tables creating it backwards.