top of page

< View All Blogs

Writer's pictureMichael Intravartolo
Jun 1, 2022

A Shot of Business Central and A Beer | Episode 38


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

Demo Tool and Demo Data for Manufacturing Scenarios

Microsoft’s SMB Business Apps re-alignment: An interview with Dynamics 365 GM Mike Morton


Interview with Molly Fuchsel



Featured Business Central App


Excel Journal Import by Chase Software


What the app provides according to Chase Software

  1. Create journal lines in Microsoft Excel and import them directly into Business Central

  2. No need to create a specific Excel layout or template

  3. Supports all fields in the General Journal Line table, even new or custom fields as well as Global Dimensions and Shortcut Dimensions

  4. 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!

Tags:

Follow Us!

Recent Articles

bottom of page