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.
Comments
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
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
This is shipping with December 2018 update.
Category: Financial Management
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
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
What is the status of this - this non-editable / filtered Excel list is severely missed.
Category: Financial Management
Hi Natalie,
Thanks for the recommendation. We'll look at adding this functionality in a future release.
Thank you!
Jared Hall
Category: Financial Management
Business Central Team (administrator) on 5/17/2022 1:18:30 PM