Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

List or Excel file

(0) ShareShare
ReportReport
Posted on 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
    Amol Salvi 18,694 on at
    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
    Tina Menezes 2,582 on at
    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

  • 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
    Maneesha 5,889 on at
    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
    Tina Menezes 2,582 on at
    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
    Amol Salvi 18,694 on at
    RE: List or Excel file

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

  • 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
    Amol Salvi 18,694 on at
    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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February 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... 292,575 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,493 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans