AnsweredAssumed Answered

Which is better Stored or Unstored Calculation for Converted Inventory?

Question asked by starstuff on Aug 12, 2015
Latest reply on Aug 14, 2015 by philmodjunk

Title

Which is better Stored or Unstored Calculation for Converted Inventory?

Post

Hi All!

 

im trying to make a simple inventory system based on this thread https://community.filemaker.com/thread/79583, it doesn't use calculation in the fields instead it use scripts.

 

i need to add a convert inventory option (eg from box to pcs, doz to pcs) to be able to add/remove inventory of different Unit of Measure.

 

i solved this by adding a button that would convert the value to the converted unit and replace the Unit to the converted unit.

 

in the Table, i added a field to calculate the value to the available units.

 

i would like to ask if its better to have it Store or have it UnStore calculation, and will get the right inventory levels?

 

Thank you!

Outcomes