top of page

A Shot of Business Central and A Beer | Episode 29

Updated: Sep 29, 2021

Welcome back to episode 29 of A Shot of Business Central and A Beer, presented by Solution Systems, a Gold Microsoft Partner. Today’s episode includes the latest Business Central news, an in-office interview with Karen Brudvig and Dave Bollenbach from Avalara, a review of the Shipping Connector App, and an overview of the Inventory Adjustment Feature in Business Central.

Podcast Segments

0:00 Podcast Opening

1:21 Business Central News

09:23 Stump Ken

11:45 Avalara Interview and Beer Review

44:47 Shipping Connector App Review

51:52 Inventory Adjustment Feature Overview

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

Business Central News

On our last episode, when we were discussing the storage changes for Business Central, Erol Kunman wrote in and told me that: “There was misinformation in the podcast about storage. Concerning Database Capacity changes the 40GB for blobs is gone. So, Microsoft marketed the changes as a win to everyone but actually it was a win for companies with 20 or more full users and a loss for everyone else.”

Erol, you care correct. The 40GB file storage limit is no longer separate and is counted toward the overall database storage capacity. Thank you for keeping us and especially me on our toes!

Ken, do you agree with Erol that Microsoft marketed the changes as a win to everyone but actually it was a win for companies with 20 or more full users and a loss for everyone else?


"Starting July 1, 2021, along with introduction of lower-priced capacity add-ons and per-license capacity quota extensions, the capacity occupied by the files or Blob data stored in the Business Central database (the content of the Tenant Media and Tenant Media Thumbnails tables) is counted towards the overall database storage capacity of the customer (tenant)."


Existing customers with Business Central Premium or Essentials subscriptions purchased before October 1, 2020 will keep their existing environment entitlements (three production and three sandbox environments) for one year, until October 1 2021 or until their subscription is renewed or ended, whichever occurs last.

Version 19 Teaser Tip

In version 19, Delegated Admins will not be created as SUPER users like they were in the past. They will be given D365 Full Access which can obviously be adjusted as you want.

I saw a video of the Word Templates being used in the Business Central email editor. It’s pretty nice. If they were to add automation to it, it could be next level.

Stump Ken

Ken, I was updating some of our older more popular blog posts and one of these posts describes how to see what version of Business Central you are currently on. My question to you is, does the systems information page contain your version of Business Central?

Answer: No. The Systems Information no longer exists in Business Central.

Avalara Interview

Michael Intro:

Avalara helps businesses of all sizes get tax compliance right. In partnership with leading ERP, accounting, ecommerce, and other financial management system providers, Avalara delivers automated, cloud-based compliance solutions for transaction tax, including sales and use, VAT, GST, excise, communications, lodging, and other indirect tax types.


1. Can you tell us a little bit about yourselves, what your current role at Avalara is, and which beer are you drinking?

a. Karen is drinking this fabulous gluten free number that you should hurry to your local watering hole to try out.

b. Dave…

2. Can you explain to us what Sales Tax Nexus is?

a. Nexus at it’s core is where you need to collect sales tax on sales

b. In 2018, sales tax in the US changed forever following the decision in South Dakota v. Wayfair, Inc. allowing states to impose sales tax on remote sellers regardless of their physical presence in their state.

c. Today, just 3 years later, all 45 states with sales tax in the US have some form of economic nexus laws.

d. What adds to the complexity created by owing sales tax in multiple states is the fact that every state can define their laws how they see fit.

e. For example, Kansas imposes economic nexus on any remote sale made into the state, while Alabama only imposes it once a seller surpasses $250,000 in sales in the state.

3. With the Supreme Court’s decision on Wayfair and the state legislation, the face of online sales really changed through new regulations. Can you give us some examples of what state governments do to enforce these regulations?



4. Avalara recently rolled out their annual mid-year sales tax changes whitepaper, what are some highlights for tax law changes this year? How has Covid impacted this?

a. States are offering expanded tax relief to businesses

i. Maryland, California, and Massachusetts offering extended sales tax deadlines

ii. New York and Colorado offering special tax relief to businesses in the food industry

iii. Nevada offering a tax amnesty program

iv. Several states have implemented sales and use tax exemptions for Personal Protective Equipment (PPE)

b. Several states have said they will not establish nexus based on remote employee location – Indiana, Maryland, Massachusetts, Minnesota, Mississippi, New Jersey, North Dakota, Ohio, Pennsylvania, D.C.

c. Originally it was thought that states saw a significant decline in revenue, but most fared well – the original numbers were skewed because of filing being pushed from May to July.

i. States that showed the largest declines were those reliant on tourism – ie. Florida, Texas, Hawaii, or those reliant on natural resources – I.e., Wyoming, Alaska, North Dakota

d. Many states are looking to expand excise tax with legalizing marijuana or taxation of e-cigarettes.

e. Although most fared better than expected, states are still uncertain of what the total impact will be of the pandemic, and what it will look like when federal aid expires.

5. What’s the benefit of a Business Central user working with Avalara?

a. When will look at the positive impact of automation, we find that businesses benefit in many of the areas that previously burdened them.

b. Accurate calculations, improved reporting, as well as freed up resources and peace of mind – something businesses owners rarely get, right?

c. At a baseline, cloud-based tax solutions are essential for a successful digital transformation strategy.

d. Here are some of the reasons why cloud-based models are preferred.

i. Subscription model pricing

ii. Simpler set up

iii. Easy integration

iv. Broader tax support

6. Why should businesses choose Avalara to automate sales tax?

a. Avalara is consistently ranked as a leader in the space and we’ve been a pioneer in the industry since we were founded by bringing the industry to the cloud.

i. You should consider Avalara when your business:

1. Needs to improve accuracy of sales tax calculations

2. Must reduce compliance risk and time managing returns

3. Begins selling in new geographic areas

4. Acquires a company

5. Launches a new product or service

6. Experiences a sales tax audit

7. Changes to ERP, shopping cart, or billing system

Yes or No Speed Round Questions

1. Do you envision a world where online Sales Tax rates and compliance will be the same no matter which state you are doing business in?

2. Have you ever had a dream that involved Sales Tax?

3. Currently 45 states collect statewide sales taxes. Do you think these states will make any changes to their current tax laws?

4. Do companies selling to mainly exempt customers need to worry about sales tax?

5. Are you team gravy or team sauce?


Well, you’ve reached the end of another episode of A Shot of Business Central and A Beer podcast. Connect with us at 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!


Follow Us!

Recent Articles

bottom of page