Options on a Flowfield

fmhigue

I created Reserve Program for Customers. It is something like reservation but you can setup items by customer, location and quantity.
Now they want to setup 1 single customer with items but the customers related to the one on the program can use those items. I got the problem solved on the sales lines but then reserve table has a problem "It calculate Reserve Qty. on Sales Order" using Customer No. Is there a way to put an IF on the Flowfield.

Reserve Qty. on Sales Order field:

Sum("Sales Line"."Reserve Used" WHERE (Document Type=CONST(Order),Type=CONST(Item),No.=FIELD(Item No.),Location Code=FIELD(Location Code),Sell-to Customer No.=FIELD(Customer No.),Reserve Flag=CONST(Yes),Status=CONST(Released)))

Thank you in advance

David_Singleton

When PC&C were designing Financials we were asked about features that we would like to see in the new product. This was one of them, but unfortunately it did not happen.

So no you will have to do it in code.