Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics NAV (Archived)

List or Excel file

(0) ShareShare
ReportReport
Posted on by Microsoft Employee


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,576 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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,576 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

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,458 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans