Stock Checkbox and Calculation

[tmas73]

I have a "Stock Checkbox" that I can check manually if the item is in stock, then I have a calculation that calculates a products weight and price. So when the price is below $0 the checkbox should be automatically un check (so we know to reorder the product).

But it still should be possible to uncheck or check the same checkbox manually. How is this possible?

Thanks

T

[bcooney]

I don't follow. Why would a product's weight and price have any thing to do with whether or not it is in stock?

And..don't you calculate Qty in Stock using Receipts/Sold/Adjustments, etc?

[tmas73]

Hi, yes you have stock numbers, but in this case its liquid used in recipes, so when the liquid runs out (by volume or weight) the checkbox should be unchecked. One bottle od liquid for example 500g is used in 10 recipes and once a calculation gets below "0" checkbox reminder pops off and also will change the fields color.

[bcooney]

Why would you manually check InStock if you have a calculated InStock? Is your calc not accurate and you're getting false InStock values? Can you add Adjustments to the qty in stock, bringing it down to zero if necessary?

[tmas73]

Hi, just want the option for lazy users that dont fill anything out just keep track manually!

[bcooney]

I'd go with two fields, one calculated InStock and one manual checkbox.

[tmas73]

Ok, but what would the formula be?

if the field displays a - (negative)number the checkbox should uncheck.

I tried:

Case ( oil_quantities:il_weight_left > 0 ;oil_materials:il_stock = 1;

oil_quantities:il_weight_left < 0; oil_materials:il_stock = 0)

But it wont work

Thanks

[tmas73]

Thanks problem solved. The Stock had to be a calculation field and the the calculation was wrong!