Up next in 10
Fixed Asset Determination Rules in D365 for Finance and Operations or Fixed Asset capitalization
Nov 29, 2024
Fixed Asset Determination Rules in D365 for Finance and Operations or Fixed Asset capitalization
Show More Show Less View Video Transcript
0:09
foreign
0:54
today uh we are going to discuss about pixel asset capitalization or
1:00
determination rules in the 360 cells so uh actually the concept behind is
1:08
that so for example uh if one of the set you have a set value
1:17
is less than 5000 it's not supposed to create a fixed
1:23
asset if the uh any purchases be exceeds 5000 or equals
1:31
to 5000 uh then it's supposed to create the
1:39
fixed asset in d365. so to do this what
1:45
are the setups required in d365 to achieve this functionality or uh
1:53
feature uh can we will proceed with each
1:58
and every step by step uh procedure and will get the output from the system
2:07
so uh actually uh we need some prerequisites uh before doing this uh
2:15
setup so actually uh these are the prerequisites required procurement
2:22
category is supposed to be there so I am proceeding with a usmf company and in
2:30
the usmf company uh to see the uh what is the procurement category assigned to
2:37
this particular legal entity uh you need to go to
2:46
first of all whether the procurement category is set up down or we need to
2:52
check so to check that procurement category procurement and resources
3:01
the consignment
3:15
under consignment procurement categories over there in the procurement categories
3:23
actually this is the procurement category SN for contesso entertainment
3:29
so to check uh which is the default uh procurement
3:34
category I sent for this legal entity to check that
3:42
um go to product information management
3:52
um in this
3:57
so here you can check procurement category for procurement category
4:03
hierarchy what is the category hierarchy
4:09
assigned for the usmf legal entity so this is one prerequisite required for
4:16
before doing the uh capitalization concept so this is one
4:23
prerequisites and all the uh all the fixed asset
4:30
is supposed to be already uh it's
4:36
we need already has already it's supposed to be set up
4:49
value models in the sense books in day 365 these all the setups has to be set
4:58
up in b365 this is previews results and
5:06
even in the fixed asset parameters uh you need to enable these a particular
5:14
purchase order Fields if you are purchasing from the fixed asset uh
5:20
fix it asset from the purchase order so these three Fields supposed to be
5:25
enabled this is another prerequisites
5:33
then coming to the setup to get the capitalization
5:41
go to the procurement and sourcing setup and the fixed asset uh you have
5:48
organization wide identifier so
5:56
where we need to go procurement and sourcing under procurement and sourcing
6:02
and collapse it let's set up fixed asset
6:09
oh come on
6:14
actually
6:21
yeah organization while fixed asset identifier so I have create I have
6:26
already created uh one of the organization uh wired fixed asset
6:33
identifier which is computer
6:40
and I have a Zen the fixed asset Group which is applicable to the usmf company
6:46
you can Define the fixed asset group for each legal entity whatever uh best run
6:55
your requirement uh like this individual legal entity wise
7:02
uh currently I am proceeding with usmf legal entity so I given compute I have
7:10
created one identifier and for usmf I I
7:16
have taken uh Co MP fixed asset group
7:23
so this is another step
7:30
so next setup is that uh you need to define the business rules for fixed
7:37
asset uh determination uh to do this uh same path you need to go uh procurement
7:47
and sourcing and under setup reset business rules for fixed asset
7:57
once you click on that I have already created one of the uh
8:03
business rule I'll give in the description uh I have
8:11
selected the procurement category I have selected the procurement category office
8:17
Machinery here so you can select any other as well if
8:24
you want to select if you want to add the procurement different procurement
8:30
category for the same same same rules for example vehicle
8:37
expenses I'm adding these as well uh for this particular procurement categories
8:44
these are the organizational wide rule for capitalization so this is another
8:51
step you need to map the procurement category which is which uh this
8:57
particular business rule needs to be applicable so this is another step and once this is
9:05
done and you have the uh business rule
9:10
how much amount uh how much amount you want to
9:20
taking the USD only
9:26
5000 USD currency if my condition is that my business
9:34
requirement is that if I if my expense
9:39
is more than or equal to 5000 of USD
9:45
it's supposed to be capitalized that that means it will create the fixed
9:51
asset so if my experiences for this particular office machinery
9:58
is less than 5000 then it will be it
10:03
will not create any fixed asset that means it will not capitalize the asset
10:10
so this is one thing uh effective date also I have given and expiration never I
10:18
have given organization wired fixed reset identifier which we have created
10:24
pre in the previous step identify your computer I have added here and
10:34
and here uh description I have given it's computer it's a computer and the uh
10:42
the fixed asset group has qualified as if it is as and then it will become
10:49
under the fixer asset group computer then if it is you can add another
10:55
condition if it is no then it will be
11:00
it it will be more go to another uh
11:06
fixed asset group you can add here as well if you want
11:31
but we have created only one identifier uh so one pixel asset group uh so
11:45
then you can create new one here and map it map in the
11:53
map in this place currently a
12:16
okay so uh that is the another step we need to Define uh where uh actually this
12:24
is the main shape where we uh mentioned that how much amount
12:40
of expiration everything will be available
12:48
and let's go uh so this is the setup for this particular uh
12:55
functionality and we'll start testing or testing this
13:01
activity after this whether it our requirement we achieved
13:09
or is there any set of is looking as per our requirement or not
13:17
Let's test it so let me go to accounts payable to create a fixed asset
13:26
sorry to create purchase order
13:33
it's a testing part uh we have done all our setups required for work fixed asset
13:41
capitalization purpose and let's test this setup whatever we
13:49
did till now so let's take the vendor account
13:56
and click ok
14:04
see here I'm selecting the procurement category
14:10
office appliances under office appliances calculator or accessories I
14:15
am giving and
14:20
quantity I have given one
14:25
Unit E so if I take four thousand nine ninety
14:32
nine please look into this particular area
14:37
the line section pixel asset if I select 4999
14:44
see here see this part nothing is there okay
15:01
provide additional information about your fixed asset
15:07
okay additional information is what it's computer
15:15
yes it's computer see automatically new fixed asset and
15:23
fixed asset group
15:28
so if I
15:45
so identifier we selected only one so I'm taking computer automatically so
15:52
once you give the 5000 amount it will ask for uh additional information about
15:59
your fixed asset if I select 4999 and save it
16:28
it's just refresh issue it's went let's select 4000 it is nothing is there
16:38
and take four thousand nine ninety nine
16:46
and save it no asset is creating here
16:55
if I select 5000 and save it it will ask for
17:04
just refreshesion
18:02
let's just refresh issue let's see
18:09
foreign
18:29
let me close this form and reopen it
18:35
it's just I believe it's it's just refreshing thing and my system
18:42
uh it's a bit slow actually
18:57
let me remove the line
19:28
see it's just refresh issue if we give 5000 it will ask for additional
19:35
information if actually that identifier is selected
19:46
so if I select it's a computer automatically it will ask it will create
19:52
new fixed asset and computer is enabled etcet group
19:59
so if we uh let me create new purchase order and compare
20:07
both the purchase orders so that you'll get better picture of the output is
20:21
so now I am going to create one more purchase order with 4999
20:28
for the same vendor
20:34
will compare the output so that will get end to end
20:43
about this particular functionality so I'll take the same things
20:51
but only the amount
21:04
look at the fixed reset tab just save it
21:09
nothing is
21:14
enabled now no fix it as a group nothing else let's
21:30
so I'm just showing you uh both the scenarios when the amount
21:38
is less than 5000 if the amount is less equal to or greater than 5000 how the
21:47
functionality uh will work based on our setups
22:01
so I'll go to another purchaser order as well and I'll confirm this one as
22:08
so instead of waiting till confirmation
22:14
I'm confirming both the purchase orders which is 5001 and 4991
22:22
so it's processing
22:27
so one is confirmed so both are confirmed now
22:33
let's go to
22:38
receive Tab and I'm going to book the product receipt
22:45
say that nothing is there here in the fixed asset tab so let's take
22:59
that amount as a product receipt number four thousand nine ninety nine
23:06
and click same way I'm going to do the product
23:12
receipt for that 5001 a thousand purchase order
23:21
I'll give five thousand here
23:42
so if I go to product receipt entry
23:47
water
24:22
okay uh maybe it will take a few seconds
24:29
so meanwhile I'll post the invoice
24:40
for both the purchase orders
25:03
system bit slow actually
25:13
please bear with me so it's a bit slow in doing uh
25:21
simultaneously
25:28
so this is 5001 hello
25:51
my status so this is done
25:57
post it
26:04
so both I am doing at a time so purchase or the invoicing is happening
26:12
for both the budget zoodles
26:48
okay
27:00
so one is done what is this 499 F4 triple line one is completed
27:08
let's go and check the voucher
27:15
so just not showing
27:21
let me check the
27:39
so watch us not posting right
27:45
why it is not posting go to general journal
27:53
um and uh periodicus is where it is let me
28:00
collapse it
28:08
thank you oh nothing here
28:31
it's just a refreshing thing let's wait yeah see
28:37
so this is uh five thousand invoice one see it went to uh
28:45
what is that so two layers one is uh current and tax
28:53
layer leave it leave the tax layer uh concentrate on the current layer it has
29:01
been posted to the tangible fixed asset debit asset debit and vendor credit this
29:09
is the entry which was posted for the uh five thousand one
29:14
let's go and check for four thousand nine ninety nine
29:25
see it has booked to miscellaneous expenditure so
29:32
what if the amount is less than 5000 it's going to expense account we are not
29:41
capitalizing that amount it's going to the expense and vendor is the credit
29:47
this is our uh um invoice entry
29:57
so if we want to see the product received
30:06
you can see that as well it will be normal entry of
30:12
expense Journal nothing much of the product receipt
30:19
uh okay so I'll show one more thing for
30:25
the uh 5000 purchase order
30:32
so it's supposed to be capitalized so that's why it's created the fixed
30:40
asset of comp so 0 8 is the fixed asset which is
30:46
created after posting this particular purchase order so if I go to the fixed
30:52
research and to the uh to this particular fixed asset I can check the
30:58
books it has been acquired and the status will be uh open status and the
31:05
acquisition value is 5000 so it will create basically if it is more than the
31:11
5000 it will the create the fixed asset if it is less than 5000 it will directly
31:17
go and sit in the expense
31:24
so how uh if you have any other doubt like uh
31:32
invoice so for example if if I go to invoice uh
31:38
for the 5000 purchase order is went and sit in the uh
31:44
fixed asset account uh
31:50
let me show it so that it will be easy so it will post it to 180 one hundred
31:57
two double zero one double double one zero is uh vendor account it will come from the
32:05
vendor posting profiles and 180 100 uh
32:10
it is a tangible fixed asset how uh why it's picked this particular account
32:16
means uh it's it has it is an acquisition Journal
32:22
right it is an acquisition Journal as well as
32:27
the book is slsl and the fixed asset group is that
32:34
um pixel asset group is uh
32:41
come so if I go to uh fixed reset posting
32:47
profiles um
32:53
let's show you from where this particular account is
32:58
faked asset um
33:04
hosting profiles
33:15
slsl 180 100 this is the account right
33:20
so from here it's it has been so another for another voucher
33:29
another entry like four thousand triple line one if I go to invoice it has been
33:37
picked uh purchase expenditure for expense account from where it has been
33:43
come picking uh means uh it is from the
33:49
inventory posting set for the expense
33:56
combination six one eight nine hundred from six one eight nine hundred
34:04
remember it will be Inventory management
34:27
and purchase expenditure for expense
34:39
and six one eight nine hundred this is the
34:45
contact inspecting the combination is all all so category yeah that particular
34:52
category level we don't have any combinations so system is going for all
34:59
all if there is a particular individual category table level uh relation and it
35:08
will pick that particular account so this is the uh
35:15
concept I want to explain in this video so I hope uh everyone understood uh some
35:24
uh end-to-end setup and output and how
35:29
it will work those type of stuff uh for this majorly
35:36
setups or organization wildfix data set identifier and business rules in the business rule
35:45
we will Define all the things like for which procurement category this rule has
35:52
to be applicable and for which identifier and what is the
35:59
amount for capitalization so these all the things are in
36:07
the same form right
36:13
you can test the scenario
36:18
so that's about uh capitalization concept so okay uh we'll come up with a
36:27
new topic in next uh episode or next
36:33
video
#Business Finance
#Physical Asset Management