Insert in Sales Line

deepblue
deepblue Member Posts: 152
edited 2006-09-07 in NAV/Navision Classic Client
Hello,

I'm trying to insert lines in Sales Line table, I want to fill some fields like: "Document Type","Sell-to Customer No.","Document No.","Type",...
but I want the system automaticlly fill the "Line No." like in "Sales Quote" form. Has anyone any solution?

thank you!

Comments

  • matteo_montanari
    matteo_montanari Member Posts: 189
    deepblue wrote:
    Hello,

    I'm trying to insert lines in Sales Line table, I want to fill some fields like: "Document Type","Sell-to Customer No.","Document No.","Type",...
    but I want the system automaticlly fill the "Line No." like in "Sales Quote" form. Has anyone any solution?

    thank you!

    No, i'm sorry
    You must fill "Line No." manually. example:

    Salesline.SETRANGE("Document Type", SalesHeader."Document Type");
    Salesline.SETRANGE("Document No.", SalesHeader."No.");
    IF Salesline.FIND('+') THEN
    LastLIneNo := SalesLine."Line No."
    ELSE
    LastLIneNo := 0;

    ...

    SalesLine."Line No." := LastLIneNo + 10000;

    Matteo
    Reno Sistemi Navision Developer
  • kriki
    kriki Member, Moderator Posts: 9,135
    Filling up "Line No." automatically is a form-property, so you can't use it in code.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories