Skip to main content
Post a question

Notifications

Community site session details

Community site session details

Session Id : nuCk1Nbszyxn/9hlyulsX5
Microsoft Dynamics NAV (Archived)

List or Excel file

Like (0) ShareShare
ReportReport
Posted on 27 Aug 2017 17:21:09 by


Hi

Need a list of the stock items that are for shipment in date order, but on the list I would like the sales amount for  the items.

That is, my list shows how much money I will send on the single day as well as the item number Is it possible ?

Sincerely

Jan Larsen

*This post is locked for comments

  • Suggested answer
    Amol Salvi Profile Picture
    18,694 on 29 Aug 2017 at 06:21:53
    RE: List or Excel file

    Check this walkthrough for creating list page

    msdn.microsoft.com/.../dd338968(v=nav.90).aspx

  • Verified answer
    Tina Menezes Profile Picture
    2,582 on 29 Aug 2017 at 05:22:29
    RE: List or Excel file

    Hi,

    I'll attach screenshots below. You need to click on New to create a new page of PageType 'List'. Use table 37 Sales Line as your base table.

    Properties of the page should be as below:

    page-4.JPG

    Add the fields which you wish to display be going to the field menu.

    Page-1.JPG

    The filter required for your page should be written on the onOpenPage() trigger of your page. I have written a filter to display sales line items having Shipment date >1/11/2019 just for your reference. You can add your required filter following this.

    Page-3.JPG

    Now save and run your page. It looks like below

    page-4.JPG

  • Community Member Profile Picture
    on 29 Aug 2017 at 04:12:06
    RE: List or Excel file

    Hi Tina

    Thx

    I'm newbie, is there a little guide some where I can see how to do what you're suggesting

    Regards Jan

  • Suggested answer
    Maneesha Profile Picture
    5,889 on 29 Aug 2017 at 04:00:19
    RE: List or Excel file

    yes there is no default page ,  you have to customize and create new page as list

    follow Tina comment  

  • Tina Menezes Profile Picture
    2,582 on 29 Aug 2017 at 03:49:17
    RE: List or Excel file

    Hi,

    You need to create a new page which is of 'List' type with table 37 as your base table and add the fields to this page from the field menu which you wish to display. You can add filter for date according to your requirement.

  • Suggested answer
    Amol Salvi Profile Picture
    18,694 on 29 Aug 2017 at 01:16:08
    RE: List or Excel file

    You can create the list page using sales line table and disply the records

  • Community Member Profile Picture
    on 28 Aug 2017 at 17:56:48
    RE: List or Excel file

    Thanks for reply Salvi

    There is no default page that will show you all the lines of sales invoices. But you can just run the 37 table from object designer to see all the lines of all sales invoices.

    If you want just to see all the fields available for particular line, press CTRL+ALT+F1 and expand table fields pane.

    Is this a option for me ?

  • Suggested answer
    Amol Salvi Profile Picture
    18,694 on 27 Aug 2017 at 23:30:21
    RE: List or Excel file

    You need to create list page baaed on sales line where ypu can filter with posting date

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

Quick Links

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,440 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,569 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Loading complete