Inventory Managment Episode 3 Transfer Order Under delivery Inventory movement and Inventory Adjus
Nov 29, 2024
Inventory Managment Episode 3 Transfer Order Under delivery Inventory movement and Inventory Adjustment
Show More Show Less View Video Transcript
0:02
hello everyone welcome back uh to the new session today we are going to
0:08
discuss about transfer Auto under delivery so in previous episodes we discussed
0:16
about Warehouse site location creation transfer order stock order
0:23
for India localization we have discussed and currently we are
0:29
going to discuss about the transfer order and it is for
0:37
under delivery how to proceed it so let's try
0:44
so I am going to create a transfer order in inmf legal entity
0:50
let's try site Warehouse 11 and
0:56
Rose 20. and my product is POD
1:10
for example for quantity so as we discussed in previous episode
1:17
the first first step in the transfer order after creating the transfer order
1:23
after uh filling the details in the lines is generate picking list
1:33
so I'm picking least I'm generating for all
1:38
quantity that is 4 in this case
1:45
so once uh generate picking list done picking list registration
1:53
in the picking list registration what I am going to do is that I am going to split into two or two lines
2:01
for example two quantity in another line
2:11
and what I am going to do is that in this first line
2:18
select the first line and I am updating the selected that
2:23
means for picking purpose and the second line
2:30
I am canceling this picking line so these two quantity I'm canceling it and
2:38
two quantity I accepted the picking
2:45
so once this is done come back
2:54
just refresh it ship transfer order
3:00
so now I am going to ship only big quantity that is two
3:07
quantity in this case
3:25
so once this is done
3:32
once this is done I am doing
3:47
so once this is done I am receiving the product once shipping is done that is for uh
3:55
shipping shipment voucher that is two quantity
4:05
to quantity received and remaining quantity
4:31
in this case a four quantity we ordered and two quantity we received and two
4:38
quantity we uh canceled the shipment
4:46
so it's accepted though uh under delivery
4:52
so that means two only we received right it's accepted let's create one more
4:59
transfer order why it is accepted why it is not
5:06
accepting that I am going to show you in two scenarios
5:13
PRD
5:18
so I'm taking again four quantity once quantity updated
5:26
go to ship tab generate picking list for all quantity which we ordered
5:40
and picking list registration
6:02
I'll do three into
6:12
three in one and I'll accept this speaking of one
6:19
quantity and I'll cancel the
6:25
remaining Peak quantity
6:46
okay then try to save it
6:56
I'm going to to the shipment
7:13
so I cancel the delivery reminder then
7:19
receiving the product
7:25
the shipment is one quantity
7:34
so in this case we got an error message saying that under delivery line is 70 percent but a
7:44
load under deliveries only zero percent
7:49
so in this case what we did is that four quantity transfer order created
7:56
and three quantity we cancel the picking and delivery
8:03
reminder also canceled and one quantity we picked and shipped
8:10
and we are receiving the shipment
8:15
so at that time we got an error message saying that under delivery is not allowed
8:21
so for this K in this case to solve these error message
8:38
go to setup Inventory management parameters
8:43
oh excuse
8:50
accept under delivery so once this is accepted
9:00
go to transfer order
9:21
so now again got the error message under delivery of the line
9:29
is 75 percent here 75 percent that means uh for in four quantity we are we
9:38
receiving we are receiving that we means a destination Warehouse receiving only
9:44
one quantity that is 25 percent of the order transfer order
9:50
so and 75 percent is under delivery so it is accepting only 50 percent where we
9:57
mention fifty percent fifty percent is accepted but 75 percent is not accepted
10:03
that is what error message saying so to check that
10:10
go to product information management and release a product
10:22
our product is
10:29
PRD this one
10:39
on the main is cost tab
10:45
sorry manage co-star
10:50
under manage inventory tab we have under delivery
11:01
of 50 percent so that's why it is not accepting
11:08
maybe I'll give 80 percent
11:13
here
11:22
so again we'll go to transfer order
11:43
so I don't think it will work because it still it is
11:50
showing 50 because we updated after creating the
11:57
transfer order so let's try with
12:02
another transfer order it will accept in this now because we already changed it
12:10
to 80 percent for example same scenario four percent I am taking and I'm going
12:17
to ship ship Tab and generate picking list
12:23
all
12:35
okay speak English registration
12:40
here select it split the line into three quantity
12:56
this one update selected that means speak
13:06
and this one I'm going to cancel the line
13:17
once that is done do the shipment for the
13:23
one quantity that picked
13:31
so one quantity was picked and I'm doing the ship transfer order
13:39
once the ship transfer order done go to delivery reminder cancel the
13:45
delivery reminder later on go to received in the same
13:50
scenario last time we got an error message saying that under delivery not
13:56
accepted so now it will accept the receipt because we updated 80
14:04
percent of under delivery so this is the scenario under transfer
14:12
order for under delivery same uh same will applicable for over delivery as
14:19
well uh same thing you need to enable the feature in the inventory management
14:25
parameters accept over delivery and in the product master
14:34
update the over delivery percentage
14:39
okay then so that's about uh transfer order
14:48
then we'll discuss about other journals like
14:56
inventory moment Journal
15:02
in this in this episode itself will start with inventory movement journal
15:08
and the inventory adjustment Journal and this you know in this session itself
15:15
and maybe later on we'll discuss with a transfer journal or
15:23
bomb journal in the next episode so I'll go with a moment Journal now
15:32
So currently movement Journal uh is about
15:38
moving the product from like
15:48
so moving the inventory for some display purpose
15:54
display in the sense you want to display your product in some
16:01
trade uh trade location so you will move that product
16:10
from your inventory right so for that purpose normally we'll use the moment
16:16
Journal uh for this one
16:21
you need for to do this uh inventory movement Journal you need to ah you need
16:28
to create the journal uh Journal names under inventory in management
16:44
so first thing before going with uh
16:50
Journal names under Inventory management I'll provide you the details where we'll
16:57
map the main accounts for posting so Inventory management
17:03
postings so for inventory mode this we already
17:10
discussed inventory issue inventory expenditure loss here we need to map the
17:16
main accounts based on your requirement this is the first thing and
17:26
once that is done go to inventory Journal names
17:32
to create the inventory Journal uh let me show you the journal name
17:40
which is already created in this case invm is the name description and here
17:47
type we need to select the correct one uh for example I'll open new one we'll
17:52
have different types moment Journal inventory adjustment transfer bomb counting uh different types of journals
18:01
are there so based on your requirement you need to select it in our case in
18:07
present scenario it is moment Journal so we need to select the moment
18:15
taking this same example voucher number given
18:20
selection posting next [Music]
18:27
these are the major things Journal voucher name and journal type
18:38
so when I go to journal entries movement
18:47
will create new moment Journal see here when you take the
18:54
Journal type as moment then only it will appear in the drop down so this is the
19:01
moment Journal name so I selected once that is selected that
19:07
uh based on the number sequence it will provide the journal number and which
19:13
side you want to uh transfer
19:22
for example site one and Warehouse 11.
19:32
so offset account you need to select here
19:39
for example I'll use
20:06
um
20:12
I'll use any account of sector counter
20:23
maybe this second I'll use once you click ok
20:30
add the line which product number you want to
20:37
move quantity it's game one
20:44
and unit present at what price you are going to transfer this product
20:50
provide that offset account you have given in the uh
20:56
while creating the moment Journal
21:04
then try to post it [Music]
21:14
once it is posted we have postings
21:19
so this is physical and financial transactions if I go to financial transactions
21:26
so this is the transaction Ledger
21:32
physical virtue how it has been posted whatever the uh
21:39
account you have selected is credited and it is inventory movement right
21:46
inventory uh inventory sorry inventory movement in the sense this is uh
21:54
inventory received in this case which one I selected is
22:02
so in this case I have a given positive
22:08
inventory stock so that's why it is inventory coming in so inventory has
22:14
been debited as we given the quantity positive
22:19
so let's check the financial inventory uh it is whatever the offset account is
22:26
credited and inventory received it is debited
22:39
okay this is when this is the this is what happened
22:44
uh at the time of uh inventory movement
22:55
so actually inventory coming in and inventory expenditure profit account
23:02
supposed to be credited um one before going with the negative
23:08
quantity for comparison I need I want to
23:15
show one more thing
23:22
that you can map the offset account here itself
23:28
for example I'll take I'll take this only
23:34
for just for testing purpose it is not the right account but I'll take this
23:40
circle if it is for inventory loss or profit account if if that account is
23:47
same Accord then it will use this one so
23:54
so in this case ah we are not no not supposed to give the offset account
24:01
because offset account is already mapped in the journal name level so I'll
24:08
click ok and let me add new
24:14
P or D so let's take
24:22
negative 2 quantity
24:29
so when I give negative quantity see here cost price I'm not able to update
24:36
it when I take positive amount sorry
24:41
positive quantity it will allow me to enter the amount
24:48
okay so when inventory is going from our system or our stock then it will be it
24:59
will take the running average cost when the inventory is coming in it will allow
25:05
you to enter the cost price so in this case I given the
25:11
minus one okay not selected the site and Warehouse well
25:18
giving while creating the
25:36
and
25:43
okay once done post it
25:53
so this was posted go to view postings
25:58
I'll go with financial transactions Ledger
26:04
pin shell watch see in this case among its scheme automatically based on
26:12
the your cost running cost
26:17
so inventory loss account will be debited inventory issue inventory is
26:25
going out so inventory will be the current asset right as for real account
26:30
it will be uh what is the rule of real account
26:38
what comes in debit what goes out credit so inventory is going out
26:43
so it will be credited so how uh triple 9 is coming
26:49
I think I already showed you in the last sessions
26:57
about how 319 is coming
27:05
uh pld
27:15
T item price so not from here
27:24
um
27:31
where
27:37
cost it cost estimates
27:57
manage inventory I think
28:04
so it's not in many inventory not engineer not plan
28:11
um manage projects no
28:21
cost objects here see
28:27
side one right 99.99.02
28:37
so this from here it is speaking the I'm old
28:51
this is all about uh inventory woman Journal
28:58
and let's take inventory adjustment it
29:03
is same similar to moment Journal but um
29:16
but this inventory adjustment normally use when uh we are not supposed to find
29:24
any reason why the product is why the inventory is missing then we uh then
29:31
we'll use inventory adjustment same offer this also postings required and
29:37
journal name Journal type will be uh
29:43
uh inventory adjustment type you need to select so let's go there
29:52
same setups first is postings and another one is Journal names
29:57
in this case uh inventory adjustment this is the one
30:03
see here in inventory adjustment type so one more thing I want to notice if it
30:11
is moment Journal of set account is enabled if it is inventory adjustment offset account is grayed out
30:19
so at the time of inventory adjustment no need to select the offset account
30:25
so let's create the
30:31
inventory adjustment Journal
30:37
um maybe site one
30:42
11 and click ok
30:49
add the new line
31:02
select the product minus one
31:30
so negative quantitative again right so view postings in this case inventory is going out
31:37
inventory will be credited and what will be the debit its loss account
31:45
inventory loss account
31:50
so let's see here
31:55
loss account will be debit and inventory issue will be uh
32:02
credited
32:10
okay one more thing if you want to put any default Journal types Journal names
32:18
that you can do from the parameters level
32:29
see here for moment Journal this is the default one there will be two three
32:36
moment Journal names but if you want to default it you can
32:42
default any Journal type
32:47
content and this is about
32:55
transferred or under delivery as well as in moment journal and inventory
33:01
adjustment so I hope everyone understood the concept how
33:09
entries will post and what are the output what is the setup so for moment
33:16
journal on digestion journal what are the setups required first is that postings in postings you
33:23
need to map inventory issue inventory received inventory profit or loss
33:29
account and inventory ah profit as well as loss account two different accounts
33:35
or same account you can give and once that is done you need to create the
33:41
journal names for Journal name for movement Journal Journal type will be
33:47
movement for [Music] inventory adjustment Journal Journal
33:54
type will be inventory adjustment once those are done you need you can pause the movement Zone you can create the
34:01
moment Journal as well as inventory adjustment moment Journal is its normal Leaf even when you are moving your stock
34:09
in um some
34:15
when you transfer your stroke for display purpose in the trade shows or ah
34:25
maybe uh what we can call it
34:33
to publicity your product you will put some you'll display your product right
34:41
in some Market places or some trade shows those type of things and inventory
34:48
adjustment when there is no reason how the inventory was missed we can post the
34:55
inventory adjustment Journal okay those are the two things
35:03
for inventory movement Journal uh offset account is required that we can map it
35:09
the journal name level as well but uh inventory adjustment it will be taken
35:16
both both the accounts debit and as well as credit accounts from the inventory postings
35:22
so I hope you understood the concept
35:28
as well as setup and the output how you will get after posting the entries
35:37
so I'll stop here I'll
35:44
continue with other topics in next
35:50
session mostly with some other different topic
35:58
till now we covered transfer Journal right sorry transfer order maybe in next
36:05
episode we'll go with transfer Journal okay
36:11
okay thank you all bye
#Management
#Business Services
#Shipping & Logistics
#Mail & Package Delivery
#Moving & Relocation
#Commercial Distribution
#Other
#Import & Export
