Thanks Beverly, but they haven`t what I need. Bye
google search 'filemaker inventory control'
2 of 2 people found this helpful
Hola cgd, though my mother language is Spanish, I'll explain in English so everybody can understand and make use of this information.
What you want is a "Inventory_Movements" table. You must send all input (purchases) and output (sales) to that table via scripting. The the actual stock would be calculated with this:
Stock = Sum ( Inventory_Movements::InAmount ) - Sum ( Inventory_Movements::OutAmount ).
If you create the Stock field as an un stored calculation it will eventually become really slow. I suggest you to have it as a number and update it with a script trigger on record load or with a scheduled script running on server.
Take a look at this image, hope you find it useful:
Thanks a lot Ibrahim, I'll try to do that.