Hi DUG
I know this might sound like a basic question but I could do with your help to resolve.
In the ITEM table is the INVENTORY fields (current stock holding) and the SAFETY STOCK QUANTITY field. I would like to add a Boolean field to the item page, called UNDER SAFETY. This will be set to TRUE if INVENTORY is less than SAFETY STOCK QUANTITY and false if not.
I assume I need to add the field to the ITEM table first, in order to add it to the page. And I assume I need to add the field as a flow field and use the calculation formula to compare the two fields. However, I can’t find out how to format the formula. logically it should be something like:
UNDER SAFETY == (INVENTORY < SAFETY STOCK QUANTITY)
Any help would be gratefully received.
Many thanks
PG9