Conditional FlowField

winderman66

Hi everyone,

I am new to Mibuso and also in NAV2013R2 so, be indulgent here but tell me if iam wrong

What i am looking to do is a sum FlowField here's my Code:

Sum("Item Ledger Entry".Quantity WHERE (Item No.=FIELD(No.),Global Dimension 1 Code=FIELD(Global Dimension 1 Filter),Global Dimension 2 Code=FIELD(Global Dimension 2 Filter),Location Code=FIELD(Location Filter),Drop Shipment=FIELD(Drop Shipment Filter),Variant Code=FIELD(Variant Filter),Lot No.=FIELD(Lot No. Filter),Serial No.=FIELD(Serial No. Filter),Location Code=FIELD(User Location Code)))

User Location Code is a Lookup-Flowfield.
What i want to do is : When the "User Location Code" is empty then, remove the Location Code filter.

Ideas ?

Kowa

You have to use a flowfilter field for this.
http://msdn.microsoft.com/en-us/library ... 71%29.aspx

If you look at the flowfield formula in the "Inventory" or the "Net Change" field in the item table you can see how these flowfilter fields are used there.