84

Recommendation to add “Export to Excel” as core feature to all page layouts (consistent with Dynamics NAV 2017).  This is one of the key selling features that is repeatedly messaged regarding Dynamics products: that users have access to the familiar “Microsoft feel”. In Dynamics 365 for Financials, it is clear Finance users want access to data to model, analyze, and aggregate without entering an “editable” worksheet.  This is helpful for AR Customer reconciliations (export Customer Ledger Entries) or exporting the working items related to an Invoice to export Invoice Line information.  Additionally, this is valuable once a list of Posted Sales Invoice OR Posted Purchase Receipt documents is filtered, to export the filtered set for ad hoc analysis/reporting.

STATUS DETAILS
Completed
Ideas Administrator

We'll keep 'Edit in Excel' untouched, but are _adding_ an ability to Open in Excel where filters and list columns customizations are taken into account. No 'publish' back to Business Central in that mode though. This feature will be avialiable in the next monthly update.

Comments

N

I would like to add a suggestion about the security under edit in excel. Some customer don’t want to let some users the ability to refresh data. Is it possible to have this restriction with security? I didn’t find a way.

Category: Financial Management

N

Appears as if this was not apart of any December 2018 update - when can we expect to see it in BC Cloud? thanks

Category: Financial Management

N

This is shipping with December 2018 update.

Category: Financial Management

N

Any news - I still find Edit in Excel a very slow, and unfit solution when compared to "Open in Excel" - for my clients, I am adding an extension to export g/l, cust.ledg, vend. leg to csv faster - this can't really be the right solution in my opinion.

Category: Financial Management

N

Agree, but also please note that there are many pages where exporting to Excel makes no sense. So this must be controllable at design time.

Category: Financial Management

N

What is the status of this - this non-editable / filtered Excel list is severely missed.

Category: Financial Management

N

Hi Natalie,
 
Thanks for the recommendation. We'll look at adding this functionality in a future release. 
 
Thank you!
Jared Hall

Category: Financial Management