using flowfields

I want to make a report which calculates the items available based on the “item ledger entry” table; but then the sum must be adjusted with the value of a flowfield a the record in the “item” table. Must I use the calcfield command first? I doesn’t work neither with “if not evalutate(var , item.flowfield) then var = 0” nor with var = “item.flowfield” Is it possible to use the result of a flowfield with records of another table?

Yes, you have to use CALCFIELDS(FlowField) before using the field’s calculated value: Table.CALCFIELDS(FlowField); Value := Table.FlowField; Value := Value + Table.“Any other field” - Table.“Yet another field”;