mibuso.com
Home› NAV/Navision Classic Client
Options

Filter Last Entry in Purch. Inv. Line

elToritoelTorito 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

  • Options
    kinekine 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.
  • Options
    krikikriki Member, Moderator Posts: 9,090
    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!

  • Options
    elToritoelTorito 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)
Sign In or Register to comment.