FlowField Filter on another table

lamia

Hello Team,

I have problem with filtering another table on FlowField, I explain :

Count("Sales Cr.Memo Line" WHERE (Sell-to Customer No.=FIELD(No.)))
AND WHERE Location = Location."Use As In-Transit"

How can i do that
plz help

mohana_cse06

lamia wrote:

AND WHERE Location = Location."Use As In-Transit"

what are you expecting from above line?

lamia

this my filter that i want to use

Filter on another table (LOCATION)
how can i make it plz

mohana_cse06

You are adding this FlowFiled in which table?
What is the datatype of Location field?

lamia

This field calculate Nbr of "Cr. Memo" how has location used "as in-transit".
i add this field (flowfield) with Count("Sales Cr.Memo Line" WHERE (Sell-to Customer No.=FIELD(No.))) on table "Customer"
And i want to add another filter : table (Location) with "Use As In-Transit" = TRUE

Can i have this filter on the flowfield of table (customer) ?

lamia

any help?

Reinhard

You have to copy the "In Transit" field from the location to the Credit Memo. (Not sure why you would do that...)
Then you can do a flowField just like you have, but you can add an additional parameter as "Use As In Transit" = Yes

- Reinhard

lamia

thx u lot, but il don't want to add this field

lamia

i just test this.

I add field "in transit" in table "cr. memo" and make my flowfield in table "Customer".
That work, but just for the new cr. memo:
i explain : when i add this field a add code into "location code = onvalidate", this code get the booleen "in transit" (location") into this new field "in transit" (cr. memo)

Reinhard

yup that's right. now you have to write a short function or report (this will get thrown away afterwards) to update all the old orders.

mihail_kolev

you can also use Lookup flowfield field as filter in another flowfield.

lamia

hoow can i do it?
Plz can u explain

mihail_kolev

you should create the flowfield in the table (in your case Sales Cr. Memo Line ). Flowfield -

Name: Loc_InTransit

Lookup(Location."In Transit") WHERE (Code="Location Code")

then you can create another flowfield and use the value of this field

Count("Sales Cr.Memo Line" WHERE (Sell-to Customer No.=FIELD(No.) AND Loc_InTransit=CONST(Yes)))

Note that this might get slow in some cases. Also you can't use this field for Sum formulas.

lamia

thank you lot
that's ok