Microsoft
Dynamics 365 Business Central
My
Top 10 Favorite Things
#1-
Built-In Excel Capabilities- Refreshing and Publishing Data
As a 20
year Microsoft Dynamics GP veteran, it was hard to wrap my mind around cloud
software the past few years. I have been so entrenched in SQL Servers, RDP,
Workstation installs, config files, and the works. As the on-premise accounting
software sales started to decline, I started to look towards the future of
Dynamics Software. Last year I was on a mission to not only learn Business
Central but also be able to do demos and pre-sales, just like I could with
Dynamics GP. It was a huge feat and I am still learning things weekly. This
blog series will focus on my top 10 favorite things so far for Business Central.
This week is my first post and will focus on the built-in Excel capabilities
for Dynamics BC.
One of my
favorite things I feel in love with for BC, is the capabilities of pushing and
pulling data directly from Excel. Most of the windows inside BC have a page
tab, which allows you to either export to excel or edit in excel. That is
right: Editing in Excel, cool!
You can edit
and create master records (customers, vendors, items, accounts, etc...) as well
as transactions. You can also create and refresh your financial statements in
Excel as well. This is a huge benefit when you need to quickly add customers,
vendors, items, journal entries etc.. or make quick edits to your data. Even
better is the fact that you can save your excel spreadsheet somewhere on your
network, open in Excel, and have the same capabilities as pulling from the
system.
Here is an example of how it works:
Open the Customers Page, Select Page drop down:
Choose Edit in Excel:
Select Enable Editing:
Sign in to the Connector on the right:
Add or Edit a Record:
Go Back to BC, Refresh and see your results!
Here is a sample of what a Refresh-able Balance Sheet out of the Box looks like.
With a little Editing, You can make it your own.
Until Next Time...
Comments
Post a Comment