BC LifeHacks: 10 Things Every User Should Know About Business Central

This blog post is sharing of YouTube content that I participated in creating, but does not live on my YouTube channel. This is to create an easy way for LifeHackers to find my content and support the events I participate in, at the same time! Click here for full listings!

Event NameDate
DynamicsCon VirtualSeptember 2021

Transcript of Content (Disclaimer – Auto Generated):

[Music]

0:10 well hello there everyone my name is Shawn Dorward i am the practice manager at dynamic consulting i am super super

0:17 excited to be here today to present to you the dynamics con community 10 business central life hacks that

0:24 every end user should know not the only 10 but just 10. so i want to make sure i

0:30 give a big shout out and thank you to everyone who took the time to not only submit sessions but to take the time to

0:36 vote on them look at this great lineup over these these few days how awesome is this to have a virtual event where we

0:42 can all get together and learn cool things so without further ado let’s go ahead and get started

0:50 so as i mentioned today we’re going to be talking about 10 business central life hacks that every end user should

0:55 know we’ll go through them at a little bit of a slower pace if you’ve ever been in my sessions before and uh talk about

1:01 them a little bit uh don’t forget to use the chat over here throughout the session i’m i’m gonna be monitoring this

1:08 throughout we can discuss them at the end and i may even uh be able to answer some throughout so be sure to use that

1:13 so i mentioned a little bit about myself we’ll talk more about that toward the end let’s get right in and talk about

1:19 life hack number one so the first one here is managing new

1:25 features and i think this one is really important if you’re pro everyone is probably aware that microsoft is constantly improving

1:33 business central so both in a wave one roll out in the spring and a wave to roll out in the fall lots of new

1:39 features and functionality right we i think you know that but what’s really interesting about this is when microsoft

1:45 rolls them out they don’t immediately give you them as a as a default option

1:51 so i’m going to search for manage feature management pop that open

1:57 and in here are some of the features that have not been forced into your into your company or your environment in

2:04 business central so if you want to take advantage of these maybe you’re just a little apprehensive you’re waiting for some of

2:09 the bugs to be worked out and that does happen uh and not not too often but it does happen so in order to get those new

2:17 features not all of them but just certain ones that are like a little bit larger that get inserted into the code base

2:23 you have to enable them early as you can see on my screen here there are a few

2:29 in here and they’re going to automatically be enabled when version 19 rolls out which is at the end of the

2:35 year but if i want them a little sooner i have to come in here and enable them so i have my screen zoomed in pretty far

2:42 let me zoom out just a little bit so you can see that for this particular company it’s

2:47 these are all disabled life hack number two in this session is going to be part of

2:52 one of these features so we need to enable it so let’s go ahead and do that so let’s see where is it

3:01 um maybe it’s not

3:06 there it is right there in the middle that was too easy uh check financial journals and background so let’s just go

3:12 ahead in here and we’re going to enable this for all users

3:18 now it’s enabled we get a notice saying that we have to sign out and then back in so let’s do that

3:25 actually i’m going to make sure i leave this page first i’m not sure if you have to just makes me feel better

3:43 and so now i’m logged back into business central let’s go ahead and look at feature management again

3:49 just to confirm that that feature is enabled for all users and it is be sure

3:54 to check that out as new rollouts occur if right from this page you can easily click learn more it takes you to the

4:00 microsoft docs site about what that feature and functionality is all about pretty cool i hope you like that little

4:07 tip there life hack number one let’s move on to life hack number two speaking

4:12 of those new features that we enabled background error checking for general journal entries this one

4:20 is pretty cool so i’m going to go back into my finance section and go to my

4:26 general journals notice here on my general journals page i now have this option called background

4:32 error check to select it’s optionally turned on by default it’s turned off so

4:39 what we need to do is edit this list and i’m going to go ahead and turn it on for my monthly

4:45 journal entry and then we’ll talk about what this does so it’s turned on let’s go into the

4:51 monthly journal entry batch and if we turn on our fast tabs don’t forget if you have questions about this

4:57 hit me up in the chat if we turn on the fast tabs here by hitting the

5:02 i over here if yours isn’t on already notice this new fast tab

5:09 journal check so as we’re typing in our journal entries

5:16 you’ll see that it’s automatically every time we make a change it’s checking in the background and looks hey we’ve got

5:21 one thing that’s got an issue so let’s take a look here up still just one right

5:27 out of balance so if we click on that oh account must not amount must not be empty so it tells us as we go through

5:34 the journal entry and in the background checking it to tell us that there is

5:40 something going on now we have two it says hey it’s that one is out of balance and i need a gl account knucklehead uh

5:47 that’s checking for errors in the background um while you’re doing general journals you can turn it on and

5:53 off like i said but what’s really cool about this is that you can click the the error messages and immediately see them

6:00 yeah pretty cool hope you like that give me a thumbs up in the chat if you like that number three

6:06 drag and drop dock attach now let me let me start out by saying this

6:12 first of all if you’re not aware there’s an a marketplace or an app store called

6:17 appsource for business central and all things in dynamics and you can access that directly from in

6:24 uh in business central it’s extension actually let’s go to extension management

6:33 in extension management kind of talking about this a bit more globally here’s a list of all of your extensions

6:39 but if i wanted to shop around or i know that there’s one i want to add on my system now i guess it would be pretty

6:46 um fair to say that i would recommend you check with your partner your trusted microsoft partner uh to at least let

6:54 them know that you’re considering or that you’re going to install this they might they might be aware of gotchas uh those kind of things or at least just

7:00 to keep them in loop and keep that partnership and tight in place so extension marketplace let’s come in here

7:11 and in here is where i can shop for all of the extensions out there now there

7:16 are some that are free like legit free um and there are some that are free trial um and there are some that you

7:24 know you’re just gonna have to you have to buy uh for business for business central this is

7:31 let’s see let me just search for this is by insight works and it’s called dock extender

7:38 right here and what this free add-in extension

7:44 does is it allows you on records instead of

7:49 having to um pick the file to attach so now that’s ex that’s

7:56 installing um instead of asking let me go into vendors let me get myself

8:02 organized here if i wanted to attach something to the vendor let’s say i want to attach a w9 to the vendor if you

8:09 didn’t know you could do that that’s over here on the attachments now the behavior that you’re looking at now is

8:14 with doc extender a free insight works add-in it does not cost anything

8:19 it’s very secure very safe it’s a great product it’s to me it’s a must-have because now i can just simply drag and

8:26 drop from an email into there and it uploads it to that record so it says hey

8:33 uh oh i didn’t configure it yet because i just installed it oh by the way i’m glad it did that because i wanted to let

8:38 you know that these are going to be stored on your sql database in your in your business central tenant or

8:44 optionally you can point this to sharepoint so as you drag and drop it’s also uh it’s putting on your sharepoint

8:49 site which i think is pretty cool all right so now we got that

8:55 let’s go ahead we’ve attached it here it is we can preview it naturally that’s going to open up

9:02 open up that w9 i can delete it if i need to just by clicking on the three dots here and delete it i can have

9:10 different versions of this so imagine a scenario in this case where the vendor’s address changes and

9:15 they send you a new w9 so you can kind of archive one and keep the others there

9:21 and that can be on transactions or gl accounts if you want to attach the excel file that you

9:26 use to create your reclass entry pretty cool i think that’s a must-have i would install it in my tenant without

9:32 blinking an eye there may be others out there who do the same thing i just tend to use the one by

9:38 insight works uh because i i’ve worked with them so much and i trust them and their products

9:43 if you know of another one that does this or something different let me know in the chat and we could chat about it after this session’s over

9:50 all right life hack session or excuse me life hacks number four

9:55 workflow now i’m not going to be able to go into the details of a workflow specifically here

10:01 during our time today dynamics con but what i can do is talk about this from a management level

10:07 workflow is within built in business central and i hear a lot of people say that it’s too complicated or that it’s

10:14 not robust enough and you can also use workflow

10:20 with power automate the flow is built uh can be attached to business central

10:25 through power automate um i guess you know i’m wondering if anybody’s using workflow

10:30 let me know in the chat and if you are um what kind so for me an easy no brainer is the example we just talked

10:37 about with the um the vendor and the w9 so

10:42 very very easy internal control create a workflow for vendor creation so that

10:47 sean can’t go into your system and create a vendor um that shouldn’t be created if you know what i’m saying and

10:54 create a workflow around that and have that w-9 even be presented to the approver there’s plenty of options in

11:01 the system for workflow you have to have a workflow approver they have to be set up as well but there’s templates so you

11:07 don’t have to start from scratch in fact you can see on my screen here i’ve got some for finance for general journals

11:13 i’ve got document workflow through the integrations there we go vendor approval workflow real easy and purchase stock

11:20 sales stocks you name it that’s a lot of templates in the system be sure to check it out now you can

11:25 build your own you can customize you can add filters so if you want um you know vendors that are

11:31 in this state to go to this person for approval or something like that you can do that

11:37 so be sure to check out workflow at very least implement it for your vendors as a little bit of internal controls

11:45 in a whole nother world power automates you can also create flows

11:51 which is a workflow engine and i implore you to look in dynamics con here i’m

11:56 certain someone is talking about that maybe mary is talking about that today so check that out

12:03 life hack number five dimension correction this just came out

12:09 in the spring this is one of those changes that i think everybody should just be made aware of you may not use it it’s not for

12:15 everyone admittedly i think that there are reasons why maybe some folks wouldn’t use it

12:21 but it is a very good change to allow someone the ability to modify the

12:27 dimension that a gl level transaction was posted to

12:32 so we’ll go ahead and take a look at that in over here in business central i’m going to go to the chart

12:39 let’s see i’m going to go to my checking account which is looking like it’s doing excellent

12:45 these are my transactions in in my chart and so what i can do is

12:50 let’s say this particular transaction is not posted to the right dimension

12:56 which i don’t have on here okay so what i want to do is go under entry

13:02 and correct dimensions so correct dimensions going to open up

13:08 this change is attached to that transaction i can give it a description hey i talked to sherry she said it was

13:15 it’s okay it’s a mistake whatever you need in my case i don’t have a dimension

13:22 currently set up so it’s not just for those transactions that

13:27 originated with a dimension it could be oops i forgot have you ever done that

13:33 i feel like somebody has so i’m going to go ahead and just pick my new dimension

13:39 now what happens here is this gets this change gets loaded into a job and the job queue and runs and when it runs so i

13:46 can run it now so mine is the earliest start time is 10

13:52 pm so i want to choose to just run it immediately that’s another little tip there some folks think that it has to

13:59 sit in that job queue and then they’ll go to the job queue and manually run the job when i say someone i don’t know who has

14:05 done that before but that little box up there that little ticker box run immediately so let’s run it

14:12 successfully run let’s go back into our entry and history of dimensions and you can

14:17 then see that hey i have an audit trail where i made a change from no value to this value i

14:23 think that’s pretty cool that’s brand new as a spring this year i think it was spring this year and you

14:30 can immediately start using that i think that’s pretty cool what do you think do you like it do you love it wouldn’t use

14:35 it think it’s a bad idea i’ve heard some people say they think it’s a bad idea but you know

14:40 until you can have the that’s sort of like reclassing a journal entry at least to me i digress let’s check out lifehack

14:47 number six company hub most companies that i work with nowadays

14:53 tend to have multiple entities within their umbrella whether that’s a shelter of some sort

14:59 real estate entity or something like that and business central as you probably know handles those entities

15:05 quite well what i love about this company hub though is if you have multiple companies

15:10 that you’re using it’s sort of like a great starting point and while i talk about this i want to

15:16 remind everybody that you’re not limited to one tab in business central so it’s a web browser right but you’re not limited

15:22 to one tab you can have company a on this monitor and company b on this monitor

15:27 and be super productive take a long lunch but right from the company hub i can see all of my companies here i can

15:33 see their cash account balances over to purchase invoices etc

15:38 and i can refresh this too so what else i really like about this is it’s a very convenient way just to get

15:45 to that company so i clicked on cronus usa it’s going to open a new tab

15:50 just the end user experience that i want leaving my other company open in the other other tab

15:56 and there i am right in that company so that’s company hub um there’s a different brand a different

16:02 version of that that um maybe about a year or so ago i’m not sure when was it if you know when that

16:08 came out hit me up in the chat let me know i think it was last year um but not many

16:14 people are using it i think it’s a great starting point life hack number seven let’s check this

16:19 one out what do we got oh very important so recently i was working with a customer who had made some inventory

16:26 changes in their production environment and when those changes were made it was

16:31 quickly realized that it was an error but it affected many transactions very

16:36 very difficult to sort of undo with a journal entry a lot of inventory adjustments needed to be made as a

16:43 result however i want to make you aware or make sure that you’re aware of the restore

16:49 option that is is just part of your environment your install of business central you get up to 30 days and i’ll

16:55 talk about the up to in a minute of point in time restore availability you can restore it to another

17:02 environment in your to on your tenant you know because you got tenant environment company right that’s sort of

17:08 like a hierarchy you can install it to restore it to a sandbox

17:13 without calling your partner if you have access to the admin center that’s an option in there and if you

17:18 don’t probably somebody in your it department uh should and if you don’t maybe you’re a smaller company you need to reach out to the partner i’m sure

17:25 they could do this quite easily the up to 30-day part is the one that i really

17:30 want you to be aware of because around the time when the when the bigger waves happen in the spring

17:36 and the fall when the major and minor version change with the combination of the two change

17:42 the restores only available back to the point at which that change was made so if your system just updated yesterday

17:51 you can only restore back to yesterday it’s a little bit of a tricky situation

17:56 during those times i have it on my calendar just to do a restore uh we schedule our updates um so

18:03 and i do i do a restore to a separate environment to keep that copy of it available and that might be a little

18:10 side trick there too as well um and like i said you can restore to production or

18:15 a sandbox that’s in the admin panel if you don’t know what the admin panel is maybe you don’t have access to it uh and

18:22 don’t sometimes there’s a good reason right so find out who does and and then you know

18:29 who your restore restore point of contact is that’s in the admin center we’ll go in there in just a minute

18:37 life hack number eight copying and pasting into general journals journal entries

18:43 so maybe everyone’s aware of this maybe

18:48 and i say that because i was recently working with a customer who kind of was a little frustrated

18:53 at how long it was taking the key in this particular journal entry and she was re-keying it

18:59 in from excel and i just happened to be part of that conversation and backed the conversation

19:06 up a little bit and showed them um the copy and into copy and paste into

19:11 journal entries and naturally that is part of an implementation training those little uh

19:17 fine nuggets of functionality this was a newer person and no one really showed show them how to do it so i thought i

19:23 would make sure that everybody’s aware of it here real easy to do you can make this part of your journal entry file

19:28 i’m going to account myself and i know it’s a hard habit to break i keep

19:34 copying excel file save it as you know august 2021 and save it save it as

19:39 september 2021. you can keep this as like just a tab in your excel file that properly lines up with the layout

19:47 of your general journal window um in in business central so if i go into

19:54 my monthly here let’s see so what i mean by that is if i have

19:59 extra columns in here i need to make sure i have the extra columns over here in in my excel file as well

20:06 so i’m just going to copy these i’m going to drop this out maybe i’ll make this 100 if something make it obvious

20:14 and i’m just going to copy these four i’m going to go over to business central i’m going to select all these i’m going

20:20 to use my shift and down arrow to do so i’m a keyboard person so then i’m going to do control v

20:25 and what to paste and so now it’s going to paste those four records over top of this in here

20:32 which is pretty handy i mean it’s quite handy actually and now certainly there

20:37 are the other options of editing in excel and you can certainly do that under edit

20:42 in excel here let me pin this so i can take this and move this into excel modify the the data

20:50 directly in excel and then publish it back um into into business central but a lot of times

20:56 accountants are doing a lot of analysis in excel reconciliation etc so the end

21:01 result is in excel anyway so you’re gonna have to copy it from your file into the edit in excel and

21:06 then publish it so to me it’s almost like why not copy it from excel and just paste it in business central uh

21:13 do you use that do you like it let me know in the comments i use it it’s a little quirky i have to admit but the

21:18 keyboard helps make things a lot easier let’s talk about life hack number nine

21:24 that’s a little trippy filters uh wild cards and filters another

21:30 another end user experience brought to you through the magic of dynamics con and share it as a life

21:36 hacks here um it’s not that we’re not that folks aren’t

21:42 learning this on an implementation but if you’re not using it often or perhaps you’re new

21:47 you don’t know uh the filters and the wild cards are pretty cool so i’m going to go into just a list

21:54 and i’m going to turn my filter on right here so here’s my list of transactions that make up

21:59 my 10 100 account and it’s filtered by that right there so maybe what i want to do

22:05 is i want to get everything from uh maybe i’ll use um

22:12 let’s see i use document date or posting date excuse me and i want to get everything

22:19 from april 1st 2019 through april 30th 2019. now that’s

22:25 going to be arranged that dot dot is from that this to that and that works

22:31 just as well in in

22:36 non-date field so let’s do description um we can use

22:43 uh the contains let me jump over to my cheat sheet here uh let’s do pipe we’ll use that for

22:50 another one so ah strike let’s do that so if i want to say

22:56 any it starts with anything which is the asterisk but somewhere in there is the word up and ends with anything

23:02 there we go if i want to make sure it starts with first but ends with anything

23:09 else there we go and the same i’m just going to clear

23:14 that so we can get another example we’ll do wide it starts with wide and ends with anything else i can get them

23:21 pretty easily now think of a scenario a lot of times these are amounts right so

23:28 we’re looking for a dollar amount and so because of a dollar amount we can say

23:33 you give me uh make sure i’m in the right filter

23:38 let’s go to amount and i’m going to say greater than

23:44 or less than 100 so now i’ve got everything less than 100

23:51 dollars if i’m looking for um maybe exactly minus 995 i could just

23:59 type that in the filter but for wild cards we can say

24:04 from minus a thousand to zero

24:10 pretty cool that’s a little bit about filters there’s also pipes so let me show you pipe

24:15 and pipe we can use on um

24:21 pretty much anything i’ll say fabric ham or use description so fabric cam

24:28 got to make sure it’s typed perfectly pipe or which is in or node publishers

24:34 and if you type it properly whew i did i’m surprised actually um

24:40 you can use the pipe as an or you’re not limited to one i could put another one in there so a nice tip there is if

24:45 you’ve got a few like 15 things or something like that use some formula magic in excel

24:50 to build up that uh value that you copy and paste in there and naturally uh greater than less than i think i

24:57 showed you but there’s two single quotes if you want to get an empty return to empty i think that’s important

25:03 so in this document type this is a little bit of a trick too

25:09 you can check oh that’s not a good example let me do department

25:15 let’s do department code department code there it is

25:21 that’s a drop down as well but we can do single quote single quote tab and that’s

25:28 going to return what there when there is no value in there notice i said single quote single quote

25:34 not double quote i don’t believe that the double quote works nope the double quote does not work so

25:40 it’s single quote single quote returns where there is no value in that field uh

25:46 for that um for that search in that wild card okay let’s move on life hacks number ten

25:55 all right last one here uh let’s see duplicate vendors or customers hmm

26:03 very very good so this particular one imagine a scenario we’ve got two three five vendors who are all really the same

26:10 but you just kind of tolerate it because well there’s not really much you can do about it and you don’t want to delete them or

26:17 have somebody purge them so but there is a combiner available and the way this works

26:23 is you want to if you have multiple vendors you want to combine what you want to do is start on the vendor

26:30 that you want to be the destination where you want them all brought to

26:36 uh if that makes sense so i’m going to go to vendors and i don’t have two real duplicates but

26:42 i’m going to open up i’m going to combine sean’s cool company um and

26:48 bring everything from first up consultants so i’m going to go into this vendor and i’m going to say

26:55 actions functions merge right at your fingertips i know actions functions

27:02 merge sounds like an adam sandler skip uh anyway merge with we’re going to open up

27:07 the merge window and we’re going to pick which one we want to merge this with and i’m going to

27:12 say first up consultants and what that’s going to do it’s going to evaluate all the records

27:19 all the history everything in the system and let you choose if you want to exclude certain things i’m just going to

27:24 let mine do that work and basically merge those together

27:29 so that all of the history and information with the one vendor is now part of the other vendor so a little bit

27:36 of of time saving there let’s take a look if see if we have

27:42 um an example and that may take a little while which is why i have these screenshots in here for that

27:48 for you now we still have a little bit of time let me check we still have a little bit of time which

27:54 is awesome so i have a bonus life hack actually if you’re good little boys and girls there are two uh bonus life hacks

28:00 so let’s talk about the first one here which is change posted description again this i think is a handy little thing

28:07 that not everybody is aware of by the way this is loaded now i can go ahead and run it i’m going to abandon that right now

28:13 we’re going to go into our posted transactions at the general ledger level so let me go back into my chart of

28:19 accounts i’m going to go into an account and right here on this window let me tuck this away

28:25 right here in this window is our description and if i try to click in this right now i can’t change that these

28:31 are posted transactions you might feel like well that makes sense i can’t i can’t change them right so

28:37 let’s see how we do this if we click on edit list now it opens up and we can change

28:44 certain things see i can’t change the amount but i can change the description

28:52 so i’m just going to say new description but i thought i was

28:57 did i not type it there we go i didn’t type it told you it was terrible keyboard new description

29:02 boom now i have that saved and i could change the posted description

29:08 nice little tip i think that’s super cool and be sure to charge that out do

29:14 you use that do you think that’s like a you know an audit no no maybe uh maybe so make sure you use security controls

29:21 to protect who can and who can’t make that change and our last bonus life hack here today

29:27 is something that i think you should make sure when you get back to your office that you check out make sure you check with your team or your partner and

29:33 make sure that someone is added in the admin center as a notification recipient

29:39 this is really important it’s pretty it’s pretty helpful through the upgrade

29:45 process i will tell you um and what this is and this is the admin panel right here this is notification

29:52 recipients you just add one or multiple people to this and they’re going to get an email from

29:59 microsoft when certain things occur and so let’s talk about what some of those examples are

30:07 first one here is when a rollout is coming your way um if you

30:13 want to know that a rollout is coming instead of waiting for somebody to find it on twitter or you know your part you

30:19 hear from your partner uh you can find out directly from microsoft when it’s available and then take that next step and go schedule uh your upgrade at the

30:26 for the right date so you get whoever’s on that distribution list and that notifications list gets these emails uh these

30:33 notification emails everyone that i’m talking about here and there’s a few good examples so this

30:38 is an easy one and then another one

30:44 is when your system is updated so you get alerted hey your system has been updated um not so bad and also when

30:51 here’s a nice little link to get a release notes uh an idea what the release notes were

30:58 how about the the ever important if your system

31:03 failed to update now you might know that if you log into the admin panel and purposely look but

31:10 this notification gets sent out if it fails microsoft does a really good job of listing the errors in that email

31:17 hopefully you’re working and being proactive to get the

31:24 release notes and and try the upgrade on a production sandbox environment because

31:29 you know you can do that you can do that earlier in the sandbox then you can then you do in production

31:35 then you can reschedule if you make the fixes um or if microsoft has trouble

31:42 they’ll let you know that they’re pausing it so if you think you’ve scheduled it for friday but they pause them on thursday and don’t restart them

31:48 they’re going to let you know um and you can see more information about it or when they reinstate that rollout they’ll

31:55 notify you just like in this email here and that’s it ladies and gentlemen thank you so much for your attention during uh

32:03 life hacks 10 things every end user should know about business central my name is sean dorward i hope you enjoyed

32:08 this session i look forward to seeing you over in the chat thanks again for supporting dynamics con and the user

32:13 group community [Music]

32:23 well hey there john how are you hey sean how are you pretty good pretty

32:28 good well how about it dynamics con fall well let’s just call it um octo or

32:36 september 2021 day number two what do you all think of that uh what’d

32:41 you think of that life hack session there the 10 not the only 10 john it’s very important to remember there’s many

32:48 more things but what do you think of those tips was it a life hack to say don’t settle for 10 at least 12.

32:55 yeah yeah very very true um i hope everyone’s having a great morning i know there were some questions a lot of a lot

33:02 of traction in the chat you know um there was some some help from others as well so did you have

33:09 any questions that you’re able to capture from from the discussions there yeah i i was trying to keep up at the

33:14 end and maybe if we go a little bit in reverse but um there were a number of questions kind of on on the wild card

33:21 piece seem to be a pretty popular topic and some of the other filtering that was there

33:26 so i was trying to see if i know some people are helping answering so that’s awesome great community involvement

33:33 one was around if there’s any special characters can you enclose that in quotes

33:40 do you know the answer to that one sean or you know kind of how to deal with if there’s some of those special characters

33:45 in there not off the top of my head i mean i think just you have to be careful because some of the special characters

33:51 are wild cards themselves so i’d look to either test it myself to be sure but it

33:57 if there’s anybody in the chat who has some feedback on there love to hear that i actually didn’t know about the at

34:04 uh symbol being a a to uh flag to mark the case insensitive so um

34:10 my mission to learn something new every day is already finished here at 9 a.m 9 30 a.m eastern time uh so thanks for

34:16 that um yeah so not really straight up to test it myself but looking to hear from others as well

34:22 all right um awesome so look down the list here

34:30 um i think earlier so um thanks to mary as well so you kind of uh

34:36 both uh kind of had a premonition there that she’d be answering some questions i think but mary was helping answer some um so just

34:45 one maybe if if you wanted to spend a minute or two um she kind of said she’d love to hear some of the pros and cons

34:51 of the dimension correction and you mentioned you fell in the middle do you want to

34:56 maybe mention one of each of those or some thoughts around that yeah yeah for sure so first of all uh

35:02 thanks to mary for for participating in the chat and helping others as well check out mary’s session i think it’s

35:08 today um she’s gonna be talking about power automate and workflows from that perspective um

35:14 so the dimension correction you know there there probably is a little bit of a debate over because as as an

35:20 accountant or someone who is um you know kind of in that mindset there’s

35:26 there is a a a link that exists between things on the general ledger and the

35:31 subsidiaries and we like to have those things in a perfect world always reconcile

35:38 so no different than the kind of forgiveness we give ourselves when we

35:44 post journal entry re-classes that’s how i think of this dimension correction

35:50 it’s one of those things that i wouldn’t rely on as my go-to method if you have

35:55 to reclass it using dimension correction i think you have to stop

36:00 collaborate and listen no or in the name of not sure but you have to stop and really say do i need to change a

36:06 business process upstream so that i don’t have to consistently make these corrections and you want to

36:12 make sure at least in my mind you want to make sure that those are um the exception dimension corrections just

36:18 like reclasses are the exception not the rule so if you can automate it in a subsidiary that’s probably the best way

36:23 to go yeah i guess i’m just chiming in a little bit to my mind some of the dimensions to me are you know kind of

36:30 the the direct extension of the gl and in the accounts that are in there and some are more tracking so i’m more

36:36 comfortable seeing corrections made on some and not on others depending on how they’re used

36:41 so it sounds like similar thought process there but um definitely kind of the way i start to think about that

36:47 there john that’s a great point and i don’t want to get hung up on this topic too much but you open this can so it another

36:54 element of it like anything else is it really depends on how you’re reporting on this data and how you’re relying on

37:00 it so if you’re making a dimension correction you’re expecting your subsidiary power bi report to get

37:06 updated that’s not going to happen so um you just have to make sure that you’re making the correction in the right place

37:11 and that the expected outcome for your reporting is what you’re is what you’re really trying to do

37:17 all right sounds good i’m trying to keep up with the chat as it looks like it’s still scrolling here too so um looks

37:24 like there was um one towards the end about the dimension correction or sorry i’m on the last topic yet

37:31 around the journal check um and i know there was one earlier um seeing some inconsistencies about it so

37:38 um anything anything you’ve seen at all i know it’s probably environment specific there but

37:44 anything any comments on on kind of um you know maybe implementing or getting

37:50 that consistency with that that check or anything you’ve seen around that on the journal entry check tool so it’s

37:57 new uh so i really haven’t seen inconsistencies myself i’d be interested

38:02 in taking a little bit of a deep dive into that um uh

38:08 yeah so i really haven’t it to me seems quite useful quite helpful um so feel

38:13 free whoever posted that question to reach out to me uh either direct message me on twitter or my emails on the slide

38:19 deck also just mary mentioned in the comment here what about a company starting with no dimension talking about the dimension

38:26 correction that’s a great example i mean if you go six months and you realize you weren’t tagging things

38:33 against a particular maybe you decide you want to have a a dimension code for vehicles or something you know so uh

38:40 certainly retroactively repairing those or cracking the transactions a perfect

38:45 example often when we do implementations uh from the partner perspective

38:50 company customers aren’t quite settled or resolved on what dimensions are and what value they bring

38:57 until they get a little bit of experience under the belt so yes that is a great example of how and why you might

39:02 be able to use that all right awesome awesome so one of the other questions i see a

39:10 recent one posted in there there was a question about restoring um also available from sandbox to production

39:17 so um sandbox 2 production i’m not sure if maybe vice versa says

39:24 well i know there’s some other options there but um do you wanna kind of answer

39:30 is it if if the question is can you restore from sandbox to production using the admit

39:36 panel not that i’m aware of um maybe an option there and i just missed it but i don’t know

39:42 that that’s an option i know in the past i’ve had to work with microsoft directly for that

39:48 um and that was also not in production production like production one it was into production too

39:53 so there might be more to that but um yeah i’m not really sure uh looks like we’re here and in the chat

40:00 it’ll be available in the next release in bc19 so the one just coming out real soon

40:05 interesting all right okay well scrolling through here a

40:11 little bit so you mentioned uh as we were talking about the dimension correction you mentioned um reporting

40:16 tools so um do you want to comment a question around favorite reporting tools to use kind of

40:22 an open question there but you can run with that how you want yeah certainly so um you know i come from the dynamics gp

40:29 space and management reporter or fx was you know something that we used often

40:36 and still use often for that platform so i tend to

40:41 appreciate account schedules for financial reporting at business central there are some things that i really wish it had by the

40:48 way be sure to check out the ideas site you can go to my website lifehacks365.com365.com

40:55 i have a page there with all of the ideas links and and vote up those business central

41:01 ideas for something specifically like maybe making a dynamic header in account

41:06 schedules it’s kind of painful that you can’t dynamically change the header so as the quarters change you have to go

41:12 into mainly changes so i use it i use account schedules for certainly some um and

41:19 tend to just think power bi beyond that and there are some good isvs for reporting in space for now for example um and others but um

41:27 you know power bi definitely is is a place that i tend to frequent

41:33 all right so a couple of housekeeping things here because i see some questions in there um

41:38 somebody was having problems seeing your email address so i’m seeing it on my screen but i might have a little different view

41:44 um see do you want to give that out as well here yeah i think somebody just put it in the chat well you see on the screen there

41:50 that’s my twitter handle uh i realize now that that might be confusing and look like an email address but it’s um

41:56 somebody put that in the chat for my work email address feel free to reach out to me or you can reach out to

42:01 my personal email address which i’ll put in there as well um or stalk me on twitter i you know

42:07 however you want to reach me all right and then there were some questions in there about the videos um i

42:13 didn’t mention that but um just to reiterate i think it’s about a week or so from now we’ll start to see the

42:19 videos posted on the youtube channel that’s right i think tomorrow you might be able to watch today’s video on the

42:26 brella tab i i may be wrong there but but it’s worth looking into i think that’s how it was last in the spring or in in the

42:34 first wave of the year okay all right i did notice a um kind of on a

42:40 different topic there was somebody asking about migrating from quickbooks and allowing an extension in the phone number field

42:49 looks like we just had an answer in the chat as well though that you can just fill that in as an extension from

42:55 there so any other advice on that one sean no you may just have to scrub your data a little bit if if the if the data

43:03 comes over uh with any non-numeric values i think that field is purely numeric so other

43:09 than that it should it should recognize the uh the extension all right and i did see a comment in

43:15 there um similar to that about scrubbing data there were a couple of comments i think around those special characters

43:20 being in fields um i was kind of a best practice if we can not have those special characters in

43:26 whatever field name address um just reporting and different tools does does

43:32 make life a little bit easier um avoid some issues with that so so um i missed who had that as my screen keeps

43:39 scrolling here but um you know definitely good advice there as well right for sure

43:45 all right so you covered you know some some newer things um some things have been out for a little bit here do you have a favorite

43:52 feature um from the last release here coming up that you want to highlight

43:58 sure um so for okay so one one that i talked to customers a lot about and i think it

44:04 just kind of flies under the radar it’s been out for a while a few years at least is

44:10 bulk loading of inventory items excuse me bulk loading of the

44:15 item images so if you have a 100 inventory items and you want to attach an image one image to

44:23 every one of those inventory items that seems like a relatively painful task to

44:29 do through the user interface but there is the feature where you if you name the image the same

44:35 as your item id and then you zip them up into a zip file you can upload them into

44:43 business central and it will automatically attach hundreds of images to

44:49 those items so that’s an old oldie but goodie um and the new the new

44:54 version it’s either out now where it’s coming out is the defaulting of the line

45:01 type on sales order documents and purchase order documents so what i’m referring to

45:06 is when you create these uh purchase order for example and you go you create your header and then you go into the

45:12 details section and you have an option to create that line item whether it’s a gl code an inventory item and other

45:18 things but if you’re frequently wanting that if you are predominantly wanting it to be gl account for example

45:25 you can now set that to default and i think that’s just a small but powerful change

45:31 that’ll help increase accuracy and reduce some keyboard frustration from end users

45:37 all right awesome great information um just doing a little time check i think we’ve got about two maybe three minutes

45:44 left before we we uh get the boot here we could probably talk for an hour or more but

45:50 we gotta give some other people some time um so was there was there any other

45:55 um kind of a favorite tip from a recent release or anything you want to call out here as we just have a couple minutes

46:01 left uh nothing to mind i mean those were sort of my two top mind i was going to get

46:07 them into this presentation um if you’ve ever spoken at an event john i know you you have and you have a session coming

46:13 up here on the gp track you tend to rehearse you put all this good work you want it

46:19 you want to help people um you know get value out of your session and you think you have your timing down

46:26 and it’s inevitable that you either run way over and or you don’t get all your content in or in my case it happened to

46:32 end sooner so thanks to everyone for all the questions and for the dialogue back and forth my emails up there you can

46:38 visit my website lifehacks365.com where i talk about things business central gp power bi

46:44 excel all kinds of other cool stuff um i will be speaking at um dynamics con

46:52 live so this virtual event the parent company of this virtual event is hosting their

46:57 first in person limited limited tickets available it’s november uh i should know

47:04 this it’s november 10th and 11th in anaheim california i’ll be speaking at that

47:10 event in person i’ll also be joining john my colleague john right here in uh

47:17 houston next month for summit north america so everyone thanks so much for joining us

47:23 john thank you for helping me manage the chat and all the questions have a great rest of your morning and

47:28 the rest of time here at dynamics con [Music]

47:43 you


Thanks for reading!

Shawn Dorward

Microsoft MVP, Business Applications

LifeHacks365.com | LinkedIn | Twitter

Leave a Reply