Filter Last Entry in Purch. Inv. Line

elTorito
elTorito Member Posts: 191
edited 2005-05-23 in NAV/Navision Classic Client
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.
(Oo)=*=(oO)

Comments

  • kine
    kine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • kriki
    kriki Member, Moderator Posts: 9,132
    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.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • elTorito
    elTorito Member Posts: 191
    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 .
    (Oo)=*=(oO)

Categories