I would like to show the item’s Safety Stock Quantity on a Sales Line. Therefore I’ve added a field fDecSafetyStockQty to Table 37. FieldClass: FlowField CalcFormula: Lookup(Item.“Safety Stock Quantity” WHERE (No.=FIELD(No.))) The result in my Sales Line is that the value is only shown after I go to the next Sales Line in the form. It doesn’t show me the value after entering the Item No. How can I achieve this?
CALCFIELDS(fDecSafetyStockQty) in the trigger OnAfterValidate on the "Item No. Control in Your form will make it work.
Great Lars, thanks!