Which is better Stored or Unstored Calculation for Converted Inventory?
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?