top of page

A Shot of Business Central and A Beer - Episode 4

Updated: Aug 10, 2021

A Shot of Business Central and A Beer podcast


Hello Friends! Welcome to the show. This episode of A Shot of Business Central and A Beer Podcast is brought to you by Magnum, B.I. – Magnum, B.I. has teamed with Solution Systems who is a Microsoft Gold Enterprise Resource Planning, Silver Small and Midmarket Cloud Solutions, and Silver ISV Partner to bring your data to life and solve your issues with Microsoft Power BI.

This podcast is also brought you by Solution Systems IT Department, who can in only one half hour, make your Office 365 more secure by configuring your Activity Alerts. Where else can you make your Office 365 more secure in only a half hour? With all of the issues today with Ransomware and other cybersecurity attacks it just makes sense to be as secure as possible within the digital world.

Contents Section

  • Beer Review Segment: 59 second mark

  • A Shot of Business Central Segment: 8 minute 51 seconds mark

  • Stump Ken Question Segment: 28 minute 48 seconds mark

  • Business Central Feature - Built In CRM Capabilities Segment: 30 minute 24 seconds mark

  • Business Central Apps Segment - Payroll Solutions: 47 minute 43 seconds mark

You can also listen to us at:

Two Guys, Coffee & Business Podcast - Workplace Culture

Show Notes

Segment 1 – Surprise Beer of the Month

Did you know that the average person drinks 23 gallons of beer every day according to Lost Coast Brewery?

Breckenridge Brewery – Founded in 1990 in the mountain town of Breckenridge, Colorado. It’s the third oldest craft brewery in the state and they’ve been growing fast. They established a second brewpub in Denver in 1992 and moved to a bigger facility again in 1996.

  • Oatmeal Stout - A well balanced easy drinking stout. Deeply roasted malts lend hints of coffee and dark chocolate. There’s a softness that comes from the oatmeal, which when combined with the malts, adds a touch of sweetness at the onset. This transitions to an unexpected dry finish.

Lost Coast Brewery – Based in Eureka, California. They can bottle and can up to 1.2 million beers and fill 1400 kegs a day.

  • 8 Ball Stout - Our Eight Ball Stout is not for the faint of heart. It’s bold as hell and robust as can be, but it’ll reward your palate like no other stout. Roasted malts and heavy hops give it a flavor that will have you pouring another before you’re even finished with the first.

The Boston Beer Company - The Boston Beer Company began in 1984 with a generations-old family recipe that Founder and Brewer Jim Koch uncovered in his father’s attic and brought to life in his kitchen. That beer was aptly named Samuel Adams Boston Lager, in recognition of one of our nation's great founding fathers, a man of independent mind and spirit. Little did Jim know at the time, Samuel Adams Boston Lager would soon become a catalyst of the American craft beer revolution.

  • 26.2 Brew - Introducing Marathon Brewing Company’s new beer, 26.2 brew. This golden wheat ale is brewed with Himalayan salt and finishes with a touch of coriander for ultimate refreshment. Shelley Smith, a brewer and marathon runner, developed 26.2 Brew out of her passion to help anyone celebrate with the most refreshing beer possible. (75 Ken Rating)

O’Fallen Brewery – We’re a regional craft brewery that began in O’Fallon, MO on St. Patrick’s Day in 2000. In June 2015, the brewery moved into a 40,000 sq ft facility in Maryland Heights, MO. Our goal is to brew balanced craft beers that focus on unique ingredients and local collaborations.

  • O’Fallen Wheach - Imagine our smooth, clean wheat beer with a touch of peach and you get the idea behind Wheach, our peach wheat beer. Light, refreshing and crisp, it’s perfect for any occasion! (88 rating Michael)

Two Brothers Artisan Brewing – Growing from a small retail store – The Brewer’s Coop – to a 40,000 square foot brewery Founding one of Illinois’ original craft breweries. Been in business 21 years.

  • Wobble - Golden in color with subtle malt character, it packs big complex citrus and piney hop notes throughout. Pairings: Strong cheeses, curry, caramel apple tart.

Anheuser-Bush - We are a company built on a dream. For 165 years, Anheuser-Busch has pledged allegiance to America and its people. We take great pride in our standing as one of the country’s most iconic companies, and hold precious our responsibility to brew great-tasting, high-quality beers.

  • Shock Top - This spiced Belgian-style wheat ale is the pinnacle of refreshment brewed with real orange, lemon and lime peels for a smooth, citrusy finish. The beer that’s always down to chill — and be chilled.

Segment 2 – A Shot of Business Central with Ken Sebahar

Recap from last month’s Shot:


You should stop using the very old Business Central online URLs (July 30, 2019)

Blazej Kotelko, Senior Program Manager

Last year we announced a single URL that will get you to your Business Central online. From that date a year ago the shorter, simpler URL to access all your business data has always been and we have been redirecting you silently even if you would happen to use the old ones (*.financials). Right now (from September 1st, 2019 ) we will be switching off any redirection from the previous, old addresses (*.financials) to the single Business Central domain. If you are still using any old bookmarks or links – please update them and switch fully to address only! This change only applies to online version of Business Central via the browser or any API calls (does not apply to on-premises versions).

This is important, but if you’re already using the current address as we suggested a year ago – you’re all set and don’t need to worry. Instead enjoy a sunny afternoon!

Kind regards,

Business Central team

Dynamics NAV mobile apps updated (July 26, 2019)

Blazej Kotelko, Senior Program Manager

This week we have released updated versions of the Dynamics NAV mobile apps for Windows, iOS and Android. Those apps are companion mobile applications that let you connect to your Dynamics NAV environment and work with data while on the go. Today’s update is simply a technical one allowing us to keep Dynamics NAV customers fully supported. We are not adding any new features, but have addressed minor connectivity issues related to some new system components as all mobile operating system are being gradually updated and new mobile devices released. While you won’t see much difference in the experience (your server side Dynamics NAV product remains unchanged) you will notice some interesting improvements indeed – like the support for iPhone X larger screen that we now take advantage of.

In order to update the app on your mobile device please make your way to the respective store and select an update. The new version of the Dynamics NAV app we have released is designated as version 2.6.6267

You can find more information about Dynamics NAV mobile app store listings:

The individual store listings for Dynamics NAV mobile app are:

· Download on the App Store:

· Android app On Google Play:

In the same manner will be also updating the Dynamics 365 Business Central mobile app in the coming days, so you may want to get that update too. This will also be a technical update, but since your Business Central is currently being prepared for July 2019 cumulative update you may as well get a newer version of that mobile app.

You can alsways find the Business Central mobile apps here:

· Download on the App Store:

· Android app On Google Play:

BTW Did you know you can use the Windows versions of these apps on your normal Windows 10 computer or laptop? The Windows 10 version of the app installs a familiar icon on your desktop that can be easily pinned to your toolbar and remembers your credentials – making it much easier to connect to Business Central with one click only. As it is a Windows 10 app it works on any Windows 10 device so go and give it a try – hey, did you know it also works on Xbox?


In Business Central on-premises, the first category of permissions is implemented in a license file (*.flf). The license file contains per-object definition of the access, matching what the customer has purchased. In Business Central online, the license file (*.flf) is not used for defining purchased access to the objects, instead we use the entitlements. Naturally, in the cloud world, the entitlements cannot be edited neither by our partners, nor by our customers – they are defined and maintained by Microsoft.

If you want to study which entitlements are given for a specific license or Azure Active Directory (Azure AD) role when working with Business Central online, you can inspect the entitlements in the standard demo database that we ship with the on-premises versions and via Docker.

The entitlements are stored in the Entitlement table in the application database. Entitlements are then grouped into entitlement sets which can be found in the Entitlement Set table.

The entitlement sets in their turn are linked to the Azure AD service plans which correspond to the purchased license, or to specific Azure AD roles (memberships). The mapping between the service plans, roles and entitlement sets is defined in the Membership Entitlement table.

The service plans are registered for the users in Azure AD when the license is assigned to them in the Microsoft 365 admin center (replaces the Office 365 admin center):

Power BI apps for Dynamics 365 Business Central and Dynamics NAV (July 17, 2019)

The following changes apply to the Power BI content packs that were available for install from and have no impact on any existing Power BI reports that you have installed or published on your own.

Starting September 1, 2019, content packs are no longer supported on Power BI online. At this point, updates to existing content packs are no longer supported. For more information, see the annoucement on the Power BI blog:

Specifically for Dynamics 365 Business Central and Dynamics NAV, our published content packs have a number of known issues. So because updates are no longer supported, these content packs have been removed from and replaced with Power BI apps.

Any content packs that you have already installed continue to work. If you have previously installed a content pack and you want to update that content pack, you can download the .pbit files from either PartnerSource or CustomerSource between July 15, 2019 and September 1, 2019.

When you have downloaded the .pbit file, open the file in Power BI Desktop, connect to your Business Central or Dynamics NAV data, and publish the report to your Power BI workspace.

Note: The same parameters are used to connect to your data as you used in the content packs.

The Power BI apps are now available in Microsoft AppSource and function in the same manner as the content packs. The only difference is that you must have a Power BI Pro license to install a Power BI app. Once the app is installed, it can be shared with any user, regardless of license.

New Business Central apps in June 2019 (July 10, 2019)

In the past month, partners and Microsoft published 33 new Dynamics 365 Business Central apps to AppSource. The following apps are new:

New Business Central apps in July 2019 (August 1, 2019)

Last month, our partners published 21 new Dynamics 365 Business Central apps to enrich and extent its functionality. These were new last month:

2019 Release Wave 2 Change History

Features Added to the release plan since our last show

  • When using the Copy document function to create new documents based on existing documents, you are now notified if any items or resources on the source document lines are blocked. The blocked document lines are excluded from the new document. The notification shows an overview of all document lines that are blocked in the source document.

  • The Windows PowerShell cmdlet Sync-NAVApp is updated so that you can convert all C/AL tables to AL tables with a minimal database overhead and without the need to write any upgrade code. The command Sync-NAVApp -Mode BaseAppUpgrade renames tables on the tenant database to conform with the naming convention for AL tables. This corresponds to a technical upgrade of the tenant, converting the table structure from the base application in earlier versions to the table structure for AL apps.

Stump Ken Question: Is it possible to edit the description on a Posted Transaction?

  • Yes it is and Business Central even creates a change log entry for this.

Segment 3 – Business Central Feature: Built In CRM Capabilities

  • Outlook Integration: Synchronization of Contact and Task data from Dynamics to Outlook. Also, manually link emails with Contact-related records.

  • Contact Management: Create and track Contact information including Companies and Persons

  • Contact Segmentation: Segment Contacts based on various groups or profile characteristics for use in Campaign targeting.

  • Territory and Sales Quota Management: Assign and manage sales quotas and territories. Track progress against quotas. Change as needed.

  • Task Management: Create and track Tasks with due dates for Contacts and assign Tasks to Salespersons or Teams.

  • Interaction Management: Keep track of all customer interactions and get guidance on best upsell, cross-sell and renewal opportunities throughout your sales cycle.

  • Opportunity Management: Manage sales opportunities through their lifecycle from lead to order. Track stages, values, and probabilities of close. Manage sales pipelines by individual sales rep, team, region, and company-wide.

  • Product Management: Manage products to be assigned to Sales Quotes.

  • Sales Quote Management: Manage products to be assigned to Sales Quotes.

  • Sales Price Management: Manage product prices and use prices in Opportunities and Quotes. Also, utilize advanced pricing and discounting structure and business logic within Business central to Sales Quotes and Sales Orders

  • Sales Tax Management: Utilize sales tax structure and business logic within Business Central to Sales Quotes and Sales Orders.

  • Campaign Management: Create and organize campaigns based on segments of your Contacts that you define. Create follow-up Segments and create Salesperson To-do's for follow-up activities.

  • E-mail Marketing: Create a Campaign Segment with targeted Contacts and export list to a third-party marketing solution.

  • Reporting: Enables reporting of all data contained within the system. Typically contains standard reports as well as the ability to create ad-hoc reports.

  • Dashboards: An easy to read, often single page, real-time user interface, showing a graphical presentation of the current status and historical trends of an organization’s Key Performance Indicators (KPIs) to enable instantaneous and informed decisions to be made at a glance.

  • User Role and Security: Grant access to select data, features, objects, etc. based on the users, user role, groups, etc.

  • Integration APIs: Application Programming Interface - Specification for how the application communicates with other software. API's typically enable integration of data, logic, objects, etc with other software applications.

  • Data Import/Export Tools: Ability to input, modify and extract data from the application in bulk through a structured file.

Segment 4 – Featured Business Central Apps: Payroll solutions and various types of integrations available

  • Free trial Available

  • Fully Integrated

  • To install the extension all you need to know is which language you prefer.

  • GL Entries Post Automatically

  • Able to leverage dimensions to allocate employee costs and improve financial analytics

  • Setup Wizard is fairly simple and quick as long as you know the correct information. I.E. Tax Codes, Bank Account, which posting setups you want to create. Should take anywhere from 10-20 minutes for complete setup.

  • Free trial available

  • Fully Integrated

  • To install extension all you need to know is which language you prefer.

  • Features include: complete payroll processing, employee self-service, HR onboarding, ACA compliance & reporting, and Federal and state tax filing.

  • Setup Wizard is fairly quick as long as you know the correct information. Should take 10-20 minutes.

  • The Fully Payroll Menu page is laid out very nice and makes navigation very easy.

  • Unable to install extension. Failed multiple times.

  • Built In

  • No Free Trial Available

  • Judging by pictures of the software it looks very clean and clear.

  • Built In

  • No Free Trial Available

  • Real Time Integration

  • Judging by pictures of the software it looks very clean and clear.

  • Able to connect with Microsoft Flow to send you email alerts. For example, setup Flow and ADP Workforce Now to get an alert that an employee has met their sales target for 12 consecutive months and their compensation should be reviewed for possible pay increase or promotion.

  • Built In

  • No Free Trial Available

Closing Statement

  • Thanks for listening everyone and just like last week let us know what you like, didn’t like or want to see going forward. Also, don’t forget to subscribe to the podcast.

Do you have some questions regarding Microsoft Dynamics 365 Business Central? Let us know below!


Follow Us!

Recent Articles

bottom of page