News and Announcements icon

Dynamics 365 CommunityForums Small and medium business | Business Central, N... Adding Fields in Edit ...

Small and medium business | Business Central, N...

Suggested answer

Adding Fields in Edit in Excel

(0) Share

Report

Report

Posted on by john.ellis

3,482

I'm seeing either poorly written articles or poorly communicated discussions on how to add unavailable fields to Edit in Excel.

For example, the Fixed Asset G/L Journals window does not export all dimension columns by default.

I know about clicking "Design" in Edit in Excel to add fields.

But, if I click "Update", a message comes up saying that doing so may end the world as we know it.

Would someone please provide a link to a good and up to date document on how to edit what is in Edit in Excel and how to do so safely?

Thanks!

John

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

YUN ZHU 73,647 Super User 2024 Season 2 on at

Like (0)

Report

RE: Adding Fields in Edit in Excel

Hi, As far as I know, Microsoft's documentation for Edit In Excel only has the following. There are other documentation for settings and permissions.

https://learn.microsoft.com/en-us/dynamics365/business-central/across-work-with-excel#edit-in-excel

But I personally think that Edit In Excel is just an auxiliary means. Generally, users will choose to modify and input on the page. If a large number of rows need to be inserted, it will be much more convenient to use the Configuration Package.

Sorry this may not solve your problem. But hope to give you some hints.

PS: For information related to the customization of Edit In Excel, see the link below.

https://yzhums.com/25314/

https://yzhums.com/22941/

Thanks.

ZHU

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans