Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Forms
Microsoft Dynamics NAV (Archived)

Forms

(0) ShareShare
ReportReport
Posted on by jsshivalik 3,027

Hi

  I have main form Location & sub Form . Both Forms are linked on Location Code. In Sub Form i want to display Day Wise Sales Amount Data 

from Sales Line table.

01/04/2018     200000

02/04/2018     400000 & so on

Thanks

*This post is locked for comments

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Forms

    Hi

       Main Form is Location . In Sub Form i want t display Data.

    Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,729 on at
    RE: Forms

    can you send us the screenshot, is it a document form if so where are you planning to populate the values ? What is your actual requirement

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Forms

    Hi

      Code is written on Push Trigger of Button .

    Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,729 on at
    RE: Forms

    Where are you writing this code and what is the purpose of it ?

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Forms

    Hi

      I am trying like this but not working . It is giving error

    DLine already exists
    Identification fields and values:
    Location = 'LDH',Date='01/01/17'

    TEntry has key Location,Date . In Sum Amount Index field it is written Amount . In DLine table i want display Date Wise Amount Sum of Location.


    TEntry.RESET;
    TEntry.SETCURRENTKEY("Location",Date);
    TEntry.SETFILTER("Location","No.");
    TEntry.SETRANGE(TEntry.Date,StartDate,EndDate);

    IF TEntry.FINDFIRST THEN BEGIN
    REPEAT

    DLine.INIT;
    DLine."Location" := "No.";
    DLine."Date" := TEntry.Date;
    DLine."Amount" := TEntry."Amount";
    DLine.Status := 0;
    DLine.INSERT;
    UNTIL TEntry.NEXT=0;
    END;

    Thanks

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 43,729 on at
    RE: Forms

    what is your source for the subform , is it sales line table ?

  • jsshivalik Profile Picture
    jsshivalik 3,027 on at
    RE: Forms

    Hi

        In Sales Lines table there may be lot of entries of same date. Like

    01/04/2018     Doc1       20000.00

    01/04/2018     Doc2       35000.00

    02/04/2018     Doc3       25000.00

    05/04/2018     Doc4       40000.00

    05/04/2018     Doc5       50000.00

    But in SubForm i want data should displayed like this.

    01/04/2018     55000.00

    02/04/2018     25000.00

    05/04/2018     90000.00

    Thanks

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Forms

    Provide more details..

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans