How can i remove everyday stock

[rengen]

Hello and sorry for my silly question, but im very new to Filemaker Pro.

My father has a shop and i make a database for stock reporting.

My problem probably is simple but for me is very dificult to do it.

I have the field "Previus status" this is the stock that we already have, the field "sold" where we put the sold items and the "current status" where is "Previous status - Sold". for example "500 - 100 = 400 in the filed current status.

If i go to remove another 50, the result it is not 350 but 450. because take again the Previous status. How can i solve this.... AAAAGGR!! I hope to undestand my problem, also i include a screen shot. Thank you very much.

Edited March 27, 2010 by Guest
The Topic: <a href="http://fmforums.com/forum/showtopic.php?tid/213913">How can i remove everyday stock</a> was moved from <a href="http://fmforums.com/forum/showforum.php?fid/140">Solutions Wanted</a> to <a href="http://fmforums.com/forum/showforum.php?

[rengen]

Finally, it is difficult?

[bcooney]

It is not difficult. It is more complex than what you've done. In a typical inventory solution, you would have more tables and track more balances. For example, you would have Purchase Orders, and PO Line Items, Receipts, RecLI, Invoices and InvLI.

Qty on Order = sum (PO Line by Part) - sum ( RecLI by Part)

Qty Sold = sum (InvLI)

etc. So, you need to branch out in your system, and build the transaction tables that will calculate your quantities.

It is also helpful to have Adjustments, so that you can directly manipulate Qty on Hand (do to damage, shrinkage, etc.).

Perhaps search the forum for "inventory" and look for FM Templates.

[rengen]

thanks for answering.