top of page

Microsoft Dynamics 365 Business Central: Manage Inventory

Updated: Aug 4, 2021




YouTube Transcript

in this demonstration we will show you

00:05

how to manage your inventory with

00:07

Dynamics 465 business central to

00:10

accomplish that we will walk through

00:11

five steps including how to review the

00:13

aged inventory review the top selling

00:16

items report review and check the

00:19

inventory and vendor lead time to make

00:22

sure we're making good buying decisions

00:23

enter the purchase invoice and post it

00:26

and then show you some new technologies

00:29

around predicting your inventory needs

00:32

let's begin by reviewing the aged

00:34

inventory so here I am on my home page

00:37

and I'll scroll down and I noticed that

00:42

I've got a report here called the aged

00:44

inventory and I could drill into items

00:45

that are over 120 days in my inventory

00:49

alright so these are key areas or

00:51

metrics that are accessible for me so

00:55

that one area of concern is in my

00:57

business is am i managing my investments

00:59

and/or is my inventory growing going

01:02

stale so when I drill into here I can

01:04

see all the items and the length and

01:07

time in which they've been in our

01:08

inventory next let's go ahead and review

01:13

the top selling items so I select items

01:16

and again I can see here on the Left all

01:19

the items and what I have an inventory

01:20

if I select the reports I get a number

01:23

of different reports I'm looking for the

01:25

inventory statistics report which is

01:28

drilled out here and it's the top ten

01:30

items so it's nice as I can see all the

01:33

items in the inventory but is again the

01:35

top ten we certainly have the Market on

01:37

the Athens desk the Atlanta white board

01:40

in the conference tables good to know

01:42

because providing that information is

01:44

important and essential to know how do I

01:47

manage my inventory next let me see if I

01:50

have enough do I need to think about

01:52

checking inventory and also if I do

01:55

what's the lead time and the cost so I

01:57

have better margins for my business so

02:01

in this case here I want to leverage the

02:03

powerful search capability so I'll enter

02:05

in the search type in purchase advice

02:08

under the planning reports and now I can

02:11

see that my Athens desk

02:12

I've only have seven

02:13

on order I only have 11 in my quantity

02:18

that's not a good sign right

02:20

so the built-in capabilities gives me

02:22

that information I need to figure out

02:24

how do we get those in because it's

02:26

clearly our top-selling item let's close

02:29

out of that report I'm gonna go to the

02:30

vendors and in this report I'll select

02:33

the purchase the vendor item purchases

02:36

and I'll preview that report to

02:39

determine hey of the two vendors that I

02:42

have granted the sample data here

02:44

doesn't give me a lot but the lead time

02:46

as well as the average cost again if one

02:49

vendor provides me with more favorable

02:51

lead time or favorable terms I can see

02:55

that from this report now I'll go ahead

03:00

and enter that purchase invoice so back

03:02

here into either vendors or I can

03:05

certainly choose it on the main actions

03:07

button right there I'm gonna select

03:09

first up consultants they seem to be the

03:12

most responsive for me right now and I'm

03:15

worried too getting these items back

03:16

into inventory so I'll select on that

03:19

purchase invoice enter the purchase

03:21

number or the vendor or invoice number I

03:24

could type the item number make sure

03:26

those athens desc

03:27

let's get 25 of those in here right away

03:29

and I'll post that and then I've got the

03:32

posted purchase invoice there if I drill

03:36

into the balance again you can see that

03:38

I've got this brand new purchase invoice

03:40

in the amount of $20,000 for fabric ham

03:46

now while managing inventory and

03:49

tracking trends on the top selling items

03:51

is key to managing investments and

03:54

certainly managing your cash business

03:56

central helps organizations to even

03:58

better manage products and services to

04:00

avoid any issues and I'm going to show

04:04

you that using some technology around

04:06

artificial intelligence and using

04:08

something called with Cortana

04:09

intelligence to forecast my needs so I'm

04:12

going to come back into the items and

04:14

you'll notice here on the right hand

04:16

side I have this forecast app right so

04:20

viewing reviewing my vendor or inventory

04:23

items you see that the app is embedded

04:25

in the list page

04:26

and I can toggle between the sales

04:28

forecast which as I see here right so

04:31

this is the sales that I have and pretty

04:32

strong now if I select the inventory

04:36

forecast it tells me a much different

04:39

story and in fact I'm concerned because

04:41

in two months if we don't take action

04:44

based on the current inventory demands

04:47

we'll be short and I'll need to create

04:49

invoice and supply right so again

04:52

thinking about the productivity gains

04:54

I'd have to probably find where I go do

04:56

purchase invoices or I could just simply

04:59

stay right here and the forecast app and

05:01

I can either create the purchase invoice

05:03

or a purchase order and so I'm in the

05:07