A Shot of Business Central and A Beer | Episode 38
A Microsoft Dynamics 365 Business Central podcast | Episode 38 A Shot of Business Central and A Beer
Ken and Michael back for A Shot of Business Central and A Beer, the most popular Business Central podcast available. On today’s episode we’ll discuss the latest Business Central news, then we’re going to be joined by Molly Fuchsel of Dynamics User Group, and finally we’ll talk about the Excel Journal Import app by Chase Software.
You can also listen to us on:
For the full list of sites you can find A Shot of Business Central and A Beer at click here
A Shot of Business Central and A Beer Podcast Show Notes
What we're drinking
Michael
Don Francisco’s Dark Roast Arabica Coffee.
Cuban coffee
Hints of dark chocolate and smoky aroma.
"This coffee is not the best and it’s not the worst. It’s kind of like a burner coffee for me. It’s one of those coffee’s I drink during the week because it’s saves me time. Just load the beans into the coffee grinder and put them into the pot."
Ken
Crisp, dry, karakuchi taste.
Ken's rating = 89
Shot of Business Central (Latest News)
Update 20.1 for Microsoft Dynamics 365 Business Central online 2022 Release Wave 1 is available
Hotfixes
https://support.microsoft.com/en-us/topic/update-20-1-for-microsoft-dynamics-365-business-central-on-premises-2022-release-wave-1-application-build-20-1-39901-platform-build-20-0-39849-60a0fe56-57b5-41b1-90ee-29694d59ad3b
Platform hotfixes
20 in total.
Application hotfixes
104 in total.
Local application hotfixes
Feature changes
Add action on card and list pages to trigger a chosen flow from Business Central web client
This connector makes it possible for Admins to build Power Apps or flows that use Business Central Data and for users to run Power Automate within Business Central.
Power Platform and Azure Logic Apps connector for Business Central online no longer in preview
https://docs.microsoft.com/en-us/connectors/dynamicssmbsaas/
Connector is now in General Availability
Country/regional expansion in 20 new countries
BC is now available in more than 70 countries.
Demo Tool and Demo Data for Manufacturing Scenarios
Business Central Partners: The demo tool and demo data is available for manufacturing scenarios.
Microsoft’s SMB Business Apps re-alignment: An interview with Dynamics 365 GM Mike Morton
Mike Morton was asked about exposing information to people who don’t have licenses and whether or not it was about finding new scenarios to get them involved at some like team member license level?
Interview with Molly Fuchsel
Molly Fuchsel: https://www.linkedin.com/in/mollyfuchsel/
Dynamics User Group: https://www.dynamicsuser.net/
DynamicsCon: https://dynamicscon.com/
Featured Business Central App
Excel Journal Import by Chase Software
What the app provides according to Chase Software
Create journal lines in Microsoft Excel and import them directly into Business Central
No need to create a specific Excel layout or template
Supports all fields in the General Journal Line table, even new or custom fields as well as Global Dimensions and Shortcut Dimensions
This app can be used to speed up data migration by importing opening balances or detailed transactions from Excel
Installation
Very simple. No configuration needed.
During installation of the app, a new action is added to the following Journal Pages:
1. Cash Receipt Journal
2. Fixed Asset G/L Journal
3. General Journal
4. IC General Journal
5. Job G/L Journal
6. Payment Journal
7. Purchase Journal
8. Recurring General Journal
9. Sales Journal
You can start three different ways:
1. From scratch
Open up a new excel worksheet and enter your column headings in the first row. Column headings must match the column headings on your journal page.
All rows below the first row can be used to capture journal lines.
Enter Information
Save
Select process on Journal page in Business Central and import into BC.
2. By copying lines from an existing journal
Select the lines you want to copy in the journal page.
Press Ctrl + C
Paste the lines into your Excel document
Edit
Save
Select process on Journal page in Business Central and import saved document.
3. By copying ledger entries from Business Central
Select the ledger entries you want to copy
Press Ctrl + C
Paste in Excel
Save
Import into Business Central
Works as advertised just have to be sure that your Excel Column headings match the column headings on your journal page.
Outro
Well, you’ve reached the end of another episode of A Shot of Business Central and A Beer podcast. Connect with us at www.solsyst.com and on all major social media channels. Also, don’t forget to subscribe to the podcast so you always know when the latest episode is available.
See you next month!
