Page sorting applied, but defaults to bottom of list in RTC

Dynamics 365 Business Central/NAV User Forum
1

EDIT: I’m using Nav 2009

I was asked to change the default sort order for all users on the Posted Sales Invoices (Page 143) so that the latest invoices appear at the top of the list.

Default View…

EDIT: Image HyperLink because it seems to be truncated a little : http://i1344.photobucket.com/albums/p644/dougieSSC/InvListAsc_zps31eea8c5.jpg

So I set the SourceTableView to be SORTING (No.) ORDER(Descending)

This does apply this sort, however, when I go into the Posted Sales Invoices, instead of starting at the top of the list, like above… it starts at the bottom like this…

EDIT: Image HyperLink because it seems to be truncated a little : http://i1344.photobucket.com/albums/p644/dougieSSC/InvListDesc_zps1ecca674.jpg

It has been sorted by Invoice No. descending which is what I wanted, but I’d want it to start/top at the latest invoices, not the bottom with oldest ones? I am aware I can press CTRL Home and take me to the top of the list, but that will annoy the users, I just want to see the latest invoices at the top when I go into Posted Sales Invoices.

I must be missing something here? Anyone got any ideas?

2

Hi Dougie,

Had it only been a classic Form, then we would have been able to user SourceTablePlacement = First! But since this property is not available in pages something else must be done.

Have you tried setting FINDFIRST in the OnOpenPage?

3

Did this solve your problem?