Updated: Aug 7, 2019
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.
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:
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 https://businesscentral.dynamics.com 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 https://businesscentral.dynamics.com 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 https://businesscentral.dynamics.com address as we suggested a year ago – you’re all set and don’t need to worry. Instead enjoy a sunny afternoon!
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: https://docs.microsoft.com/en-us/dynamics-nav-app/install-mobile-app
The individual store listings for Dynamics NAV mobile app are:
· Get it from Microsoft: http://go.microsoft.com/fwlink/?LinkId=509974
· Download on the App Store: http://go.microsoft.com/fwlink/?LinkId=509975
· Android app On Google Play: http://go.microsoft.com/fwlink/?LinkId=509976
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:
· Get it from Microsoft: http://go.microsoft.com/fwlink/?LinkId=734848
· Download on the App Store: http://go.microsoft.com/fwlink/?LinkId=734847
· Android app On Google Play: http://go.microsoft.com/fwlink/?LinkId=734849
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 powerbi.com 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: https://powerbi.microsoft.com/en-us/blog/announcing-power-bi-template-apps-general-availability
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 powerbi.com 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:
Send remittance advice by email by Microsoft Email and resend remittance advice from the payment journal and vendor ledger entries
Cap Vignes by Cap Vision All-in-one business software for winemakers, traders, and wineries
OK365 Field Sales by OrangeKloud An overall mobile solution for your daily field sales needs
Dynamicweb Plug-In Unit by Dynamicweb Integrate Dynamicweb All-In-One-Platform with Microsoft Dynamics 365 Business Central
ODT Service 365 by Open Door Technology Enhances jobs adding service tickets, field service, and maintenance
Tech Trade Essentials by WSB Solutions BV Essential for any wholesale company: import items & prices, copy them and get notifications in orders
Localization for Serbia by Localization Consortium for Serbia, Croatia, and Slovenia Adriatic localization is compliant with local laws and regulations for Serbia
Bank of Canada by E Foqus Canada Inc. Exchange rates from Bank of Canada
Norwegian Business Register by Blue Software AS Easily add customers, vendors and contacts from Norwegian Business Register
Customer Vendor Compensation by EOS Solutions Compensate accounting items (customer/vendor documents)
Customer Vendor Compensation for Italy by EOS Solutions Compensate accounting items (customer/vendor documents)
foxdox smart connect by Konica Minolta Business Solutions Deutschland GmbH Is your document filing still a manual process? Let us help you automate it.
Multi-Entity Management by Binary Stream Software Inc. Consolidate many business transactions into one with Multi-Entity Management
Manufacturing Application by Vox ISM Inc Manufacturing application for Microsoft Dynamics 365 Business Central
Finance Month End Activities Dashboard by ASQiT Ltd. A quick glance at outstanding month end activities for finance teams
Soft4Lessee for ASC 842 lease accounting by Soft4 Simplify your transition to ASC 842 standard with Soft4Lessee lease accounting software solution
Intelligent Cloud Sync for Dynamics NAV 2018 by Microsoft Set up data replication from Dynamics NAV 2018 to Dynamics 365 Business Central online
iDynamics Warehouse by iDynamics Business Solutions Revolutionize the management of your warehouse, simplifying your employees’ tasks
Simulated General Ledger Entry for Italy by EOS Solutions Post simulated GL entries
Folio3 Shopify Integration Connector by Folio3 Dynamics AX Services Integrate your Shopify store
Adriatic Starter Pack by Adacta d.o.o. Helps you to be compliant with regulatory requirements for the Adriatic region
Folio3 WooCommerce Integration Connector by Folio3 Dynamics AX Services Sync your WooCommerce store & Microsoft Dynamics 365 Business Central
Purchase Order Management by Abakion Gives you an actionable overview of all requests unresponded by suppliers
Envoice Connector by Columbus Estonia Tool for purchase & expense management to automate manual data entry and all recurring tasks
Serbian Language for Serbia by Localization Consortium for Serbia, Croatia and Slovenia Serbian Language for Microsoft Dynamics 365 Business Central Users
Localization Pack for Thailand by AMCO Business Solutions Withholding Tax and VAT functionality to help you ensure compliance with Thai regulations
LeBit Multilanguage App by LeBit Software & Consult GmbH Multi-Language G/L Account and Account Schedule
IN Self Setup ES by Innova Advanced Consulting Enables a quick setup of the system in order to start developing new enterprises
MediusFlow – AP Automation by Medius AB Cloud-based accounts payable workflow. Eliminate manual work. Gain efficiency & financial control
General Ledger Application by EOS Solutions Link GL Entries and mark them to keep subtotals
iVend Retail Connector by CitiXsys – iVend Retail A complete omnichannel platform with seamless integration to Microsoft Dynamics 365 Business Central
Visual Production Scheduler by NETRONIC Software GmbH Visually schedule and manage your production orders and capacities
Visual Jobs Scheduler by NETRONIC Software GmbH Ease your project and resource planning with an interactive Gantt planning board
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:
Advanced Sales Promotion by AP Commerce Keep track and offer sales promotions such as buy one get one free
PSA365 Starter for Dynamics 365 Business Central by GAC Business Solutions Enables project oriented companies to work cost efficient and add value for customers
PSA365 Plus for Dynamics 365 Business Central by GAC Business Solutions Enables project oriented companies to work cost efficient and add value for customers
PSA365 Enterprise in Dynamics 365 Business Central by GAC Business Solutions Enables project oriented companies to work cost efficient and add value for customers
iDynamics EDI by iDynamics Business Solutions EDI solution
Vendor Bank Approvals by ASQiT Ltd. Prevent illicit changes to vendor bank accounts and have peace of mind when paying your suppliers
Mobile NAV by MULTISOFT KFT Professional Mobile Business Solution
Purchase Request by EOS Solutions Manage purchase requests of goods/services; create quotes/orders
WMS Lite by Calsoft Boost accuracy, efficiency, and visibility of your warehouse with this ERP-integrated solution
Microsoft Dynamics SL History SmartLists by Plumbline Consulting LLC Microsoft Dynamics SL History SmartLists from the Intelligent Cloud Replication
IN Data Manager by Innova Advanced Consulting The solution that allows modifying or removing system records
365Performance dox42 Data Source by Business Systemhaus AG Design documents in Word and integrate live data
Document Flow Navigator by Awara IT Solutions LLC Enriches document flow functionality
Trade365 for Dynamics 365 Business Central by GAC Business Solutions Enables wholesale companies to work cost efficient and add value for customers
Loans by Sothis tecnologias de la informacion Allows users to perform a financial management or simulation of different types of loans
Tinx E-Commerce Connector by Tinx-IT E-Commerce connector: Magento, WooCommerce, Shopify, Amazon
Electronic VAT Settlement for Italy by EOS Solutions Create XML files for Italian VAT periodic communication
Advanced Dimension Management by isatech Speed up dimension setup for new entities and autopopulate dimension values
Folio3 Amazon Integration Connector by Folio3 Dynamics AX Services Connect your Amazon store to sync and automate data
Ledger Entry Letter by Cap Vision View ledger entries applied together by assigning a readable letter
FE LITE CLOUD by NAV-lab Electronic invoice management
Esterometro Foreign Invoice Communication by EOS Solutions Create XML files for Italian ESTEROMETRO
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
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
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.
No Free Trial Available
Judging by pictures of the software it looks very clean and clear.
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.
No Free Trial Available
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!