Register record of Sales Shipment/Invoice Line

edo906
edo906 Member Posts: 7
edited 2020-09-24 in NAV Three Tier
Hi,

I have a project for NAV2013R2 where i have to take some records of sales shipment line and sales invoice line and write them on custom table(with page action). Before this, the user can filter (when push the action page) records for POSTING DATE only month and year(for example if user set 04/2020, "process" write on the custom table only INVOICE OR DDT with POSTING DATE from 01/04/2020 to 30/04/2020)

How can do this??

Thanks so much and sorry for my bad english

Answers

  • AlexeyShamin
    AlexeyShamin Member Posts: 82
    edited 2020-09-24
    Hello!
    small example:
    BeginDate - date
    StartDate - Date
    SalesInvLine - record on Sales Invoice Line
    FilterDate - set by user/ Example 01/04/2020

    BeginDate := CALCDATE('<-CM>', FilterDate);
    EndDate := CALCDATE('<-CM>', FilterDate);


    SalesInvLine.RESET;
    SalesInvLine .SETFILTER("Posting Date", '%1..%2', BeginDate, EndDate)
    IF SalesInvLine.FINDSET THEN
    REPEAT

    UNTIL SalesInvLine.NEXT = 0;
  • edo906
    edo906 Member Posts: 7
    Thanks for answer!! :)

    But with your code, there is an error:

    bhukrmuhzn8r.png

    and then the date that set by user on filter on request page is only(Month/Year) without days... for example if i set 04/2020, take records of all April... if i set 05/2020, take records of all May


    Thanks so much







    AlexeyShamin wrote: »
    Hello!
    small example:
    BeginDate - date
    StartDate - Date
    SalesInvLine - record on Sales Invoice Line
    FilterDate - set by user/ Example 01/04/2020

    BeginDate := CALCDATE('<-CM>', FilterDate);
    EndDate := CALCDATE('<-CM>', FilterDate);


    SalesInvLine.RESET;
    SalesInvLine .SETFILTER("Posting Date", '%1..%2', BeginDate, EndDate)
    IF SalesInvLine.FINDSET THEN
    REPEAT

    UNTIL SalesInvLine.NEXT = 0;

  • AlexeyShamin
    AlexeyShamin Member Posts: 82
    User input month and year in different variables?
  • edo906
    edo906 Member Posts: 7
    Yes, without days. Only month and year and then take all records in that month of the year
    AlexeyShamin wrote: »
    User input month and year in different variables?

  • AlexeyShamin
    AlexeyShamin Member Posts: 82
    UserMonth - variable with month
    UserYear - variable with year

    BeginDate := DMY2Date(1, UserMonth,UserYear);
    EndDate := CALCDATE('<CM>', BeginDate);

    find out help about this function
    https://docs.microsoft.com/en-us/dynamics-nav/dmy2date-function--date-
  • edo906
    edo906 Member Posts: 7
    edited 2020-09-24
    Thanks!! But for transfer few fields to other table? I try this code on page action:
    IF saleshipline.FINDSET THEN
REPEAT
  ledger.ID_TRANSPORT_DOCUMENT := saleshipline."Document No.";
  ledger.ROW_TRANSPORT_DOCUMENT := saleshipline."Line No.";
  ledger.ID_INVOICE := saleshipline."Document No.";
  ledger.ROW_INVOICE := saleshipline."Line No.";
  ledger.INSERT;
UNTIL saleshipline.NEXT = 0;

    Var:

    Name DataType Subtype Length
    saleshipline Record Sales Shipment Line
    ledger Record Ledger

    But it didn't work.

    Help me please

    Thanks

    AlexeyShamin wrote: »
    UserMonth - variable with month
    UserYear - variable with year

    BeginDate := DMY2Date(1, UserMonth,UserYear);
    EndDate := CALCDATE('<CM>', BeginDate);

    find out help about this function
    https://docs.microsoft.com/en-us/dynamics-nav/dmy2date-function--date-

Categories