Announcements
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
Check this walkthrough for creating list page
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:
Add the fields which you wish to display be going to the field menu.
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.
Now save and run your page. It looks like below
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
yes there is no default page , you have to customize and create new page as list
follow Tina comment
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.
You can create the list page using sales line table and disply the records
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 ?
You need to create list page baaed on sales line where ypu can filter with posting date
André Arnaud de Cal...
293,440
Super User 2025 Season 1
Martin Dráb
232,569
Most Valuable Professional
nmaenpaa
101,158
Moderator