How to move data from Sales order Line information to another document page Line.

ismailthesacrificer1@gmail.com
ismailthesacrificer1@gmail.com Member Posts: 76
in NAV Three Tier
In which trigger need to write code to move data from sales Order line information to another document page.

3k2djjl38s27.png

Best Answer

Answers

  • Slawek_Guzek
    Slawek_Guzek Member Posts: 1,690
    Could you be more clear about your requirements?

    Answering your question - you should probably use all three triggers: OnInsert, OnModify and OnDelete in Sales Line.
    Slawek Guzek
    Dynamics NAV, MS SQL Server, Wherescape RED;
    PRINCE2 Practitioner - License GR657010572SG
    GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
  • ismailthesacrificer1@gmail.com
    ismailthesacrificer1@gmail.com Member Posts: 76
    Thanks for the Reply Slawek!
    my requirement is to design a document page and call that page in sales line reference. When i entered the data in the sales order page then that data should moves into created page. I had tried this but i am getting only header information not the line data and here as follows that i had done. I called that page in sales line under Function Action and took a local function in Sales Order subform and written the code as

    X.RESET;
    X.INIT;
    X.No := SalesHeader."No.";
    X.INSERT(TRUE);

    Y.RESET;
    Y.INIT;
    Y."No" := X.No;
    Y."Line No" := SalesLine."Line No.";
    Y.INSERT(TRUE);

    Where X is created header and Y is created Line and i had X primary key as No and Y primary keys as No and Line No.
    Thanks In Advance.
  • ismailthesacrificer1@gmail.com
    ismailthesacrificer1@gmail.com Member Posts: 76
    Answer ✓
    I got solution where i miss and problem Solved......

Categories