How to Get Released PurchaseLine List

selece28

Hi all...

I have a problem, i want to create a list form that shows all Purchase Line that the [Status] of the Purchase Header is "Released".
I use a TableBox to display the Purchase Line.
My question is, How to do it? Where should i put the codes?

Thanks,
Steven

Alex_Chow

Why not just create a flowfield that looks up to the Released field on the purchase header? Then you can just filter on this flowfield.

selece28

Thank you, but could you be more specific?
Some example maybe, coz i'm a new NAV tech consultant

Regards,
Steven

kriki

Create a new field in table T39 (copy field T38."Purchase Header".F120:"Status"). Make this new field a flowfield with calcformula "Lookup("Purchase Header".Status WHERE (Document Type=FIELD(Document Type),No.=FIELD(Document No.)))"

selece28

Ow that's how to do it. I get it now

Thanks to Kriki and deadlizard. you guys help me a lot