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
purchase invoice and the application is
05:10
telling me that I've run in a stock and
05:12
some other items and again thinking
05:16
about how do I take advantage of terms
05:18
I'll go ahead and say yeah let's go
05:19
ahead add additional items maybe I get
05:22
some better discounts save on shipping
05:25
and I can go ahead and post that so
05:28
again I walk through that scenario how
05:30
to manage our inventory and the benefits
05:32
are clear and showing you how to make
05:34
much better decisions but I think even
05:36
more so gaining greater insight into
05:39
inventory levels and demands