[Jason Wilder]

As people know there are a couple of ways to export a list to Excel in NAV 2016. 
1) Highlight, copy rows and paste
2) Hit Excel button (if it is showing, weird that it doesn’t show on a lot of list screens)
3) Hit Ctrl E.

Sometimes I prefer Ctrl E since it creates a table in Excel and adds pretty formatting.  We just noticed that we have a custom screen where when we hit Ctrl E it didn’t seem to export all the records.  Weird!  Turns out it was exporting everything it just happened to sort the records based on the Primary Key not the sort that was in the screen. 

I have tested several other screens such as Customer List, Item Ledger and a couple of custom screens and they always seem to export based on the sort of the screen.  Has anyone experienced Ctrl E sorting on the primary key not the screen sort as I have (and if so do you know why it is doing this)?

——————————
Jason Wilder
Senior Application Developer
Stonewall Kitchen
York ME
——————————

[Suresh Kulla]

Jason,

I have not seen this earlier, I have also created few test scenarios to confirm and it always exports the data based on the page sort but not on the primary key value of the table.

On your custom page, what properties have you set (ex: InsertAllowed,SaveValues..…) also on your table is one column a primary key or multiple columns? 

——————————
Thanks
Suresh Kulla
Navision Developer
ArcherPoint Inc.
Atlanta GA
(866) 343-4517
——————————
——————————————-

[Derek Eilderts]

Hi Jason,
I have experienced this problem as well.  For me, the columns that don’t carry over into excel are the ones that I asked our IT department to add.  For example, I asked to have item description added as a column in the Bin Contents List and all columns except that one make it to excel when I do Ctrl E.  Same with the User ID column I asked to be added to the item ledger entry table.
In those instances I need to highlight, copy, and paste (but it doesn’t look as pretty)

——————————
Derek Eilderts
Controller
Intercomp Company
Medina MN
——————————
——————————————-