
1. Re: Finding the number of Containers remaining
philmodjunk Aug 1, 2017 7:29 AM (in response to thong127)How would you do it using pencil and paper?
What I don't see that I would expect for that calculation is some value that tells me how many containers there are before the material documented in this record is used to fill some of them. From the info provided in your example, I can compute the number of containers needed, but need more info to determine how many should then remain.
The number of containers needed for the material in this one record:
Ceiling ( Material Stock / Quantity in each Container )
This assumes that you keep each container but one filled to capacity.

2. Re: Finding the number of Containers remaining
thong127 Aug 1, 2017 7:59 AM (in response to philmodjunk)Hi Phil,
Thank you for the reply, my purpose is to know how many counts of containers are remaining base from my remaining stocks.
like for example if I received 72 boxes of bottles with 25 counts of bottles inside each boxes. I have 1800 pieces in my inventory. if I issue 113 bottles I need to know how many containers remaining in my inventory.
Thank you

3. Re: Finding the number of Containers remaining
philmodjunk Aug 1, 2017 8:05 AM (in response to thong127)And that is exactly my point. Nothing in your post shows us exactly how to find out that 1800 pieces total nor the 72 boxes total.
And does "boxes" = Container from your original example? So you need to know the number of boxes that remain, counting a partial box as 1 box?

4. Re: Finding the number of Containers remaining
Johan Hedman Aug 1, 2017 8:06 AM (in response to thong127)Best way to handle that is to use a table for In and Out going bottles. This will be handled in a Stock table with three fields.
ID for Article (your bottle)
Ingoing
Outgoing
When someone buy one or several bottles from you, create a new record and set outgoing the the number for bought bottles. When you buy for your stock, you create a new records in Ingoing.
Then in your Article table you just add a Calculated Field with Sum( Stock::Ingoing )  Sum ( Stock::Outgoing ) .
To make that work you need a relationshop from Article to Stock based on ID for Article