Filter Last Entry in Purch. Inv. Line

elTorito

Hi.

I had add a new Field in Table Item.

FieldClass: FlowField:
CalcFormula: Lookup("Purch. Inv. Line"."Unit Cost (LCY)" WHERE (Buy-from Vendor No.=FIELD(Vendor No.),No.=FIELD(No.)))

What i must do so in Field will appear the last Entry in Purch. Inv:Line?

Momentanly it will appears the first datarow....

Thanks.

kine

I think there is missused the lookup - it is for looking up some value (but it assume that there is only one record selected with the filters). If you need some value from some record, better will be to create some function which return this value...

kriki

You can also create your fields in the Item.table as a normal field. And in the "OnInsert" and "OnModify"-triggers of "Purch. Inv. Line" you update the field in the item-table.

elTorito

kriki wrote:

You can also create your fields in the Item.table as a normal field. And in the "OnInsert" and "OnModify"-triggers of "Purch. Inv. Line" you update the field in the item-table.

I Think i must do it so, because why ever we haven't enough permissions for edit Codeunit 22 , it seems that our NSC did do it any changes in it .