Options on a Flowfield

fmhigue
fmhigue Member Posts: 290
edited 2008-10-30 in NAV/Navision Classic Client
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

Comments

  • David_Singleton
    David_Singleton Member Posts: 5,479
    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. :cry:
    David Singleton

Categories