Item Attributes in Dynamics 365 Business Central | PART-1
Read the related Short-Blog: ➡️https://navisionfunctionalexpert.com/...
----------------------------------------
Agenda of the Video▶️: To Share Some Basic Information related with Creation and Linking of "Item Attribute" & its Attribute Values" in Business Central.
Item Attributes: Item Attributes: Item Attributes (विशेषताएँ) are end-user or consumer specific classifications and definitions, that can be assigned to your items for ease of searching, filtering, and reporting purposes.
✅Hint: Here, we are using Configuration Package (tool) also.
----------------------------------------
Agenda of the Video▶️: To Share Some Basic Information related with Creation and Linking of "Item Attribute" & its Attribute Values" in Business Central.
Item Attributes: Item Attributes: Item Attributes (विशेषताएँ) are end-user or consumer specific classifications and definitions, that can be assigned to your items for ease of searching, filtering, and reporting purposes.
✅Hint: Here, we are using Configuration Package (tool) also.
Category
📚
LearningTranscript
00:00Friends, welcome to my channel.
00:02Today we are going to create item attributes.
00:06Attributes means speciality.
00:09How can you add attributes of any item?
00:15How can you add speciality of any item?
00:20We will check that today.
00:23Suppose there is a desk item.
00:26Suppose there is an athan text in this system.
00:29I will search it.
00:31Let's start with that.
00:33There are some attributes already created.
00:37I will show you that first.
00:39Open the item card on editable view mode.
00:44There is an option here.
00:47Fact box.
00:49Here you will see the picture of it.
00:51You can do it with the help of system camera.
00:55You can also import it.
00:57Export and delete.
00:59You can do it with the help of document retouch.
01:01After that, you can see the image.
01:04Here you can see the item attributes.
01:06It means speciality of the item.
01:08You can see it here.
01:10If it was in this, it would be visible here.
01:14Let's check whether it is on the system or not.
01:19There is a tab in the card.
01:22Attribute next to item attachment.
01:26You have to go to the step of the item card.
01:32Item tab in the item card.
01:37Third option.
01:38Attributes.
01:39View or edit the item attributes such as color, size or other characteristics that help to describe the item.
01:48It will help you to understand the item.
01:51It will tell the characteristics of the item.
01:55It will tell the speciality of the item.
01:57It can tell the depth of the item.
02:00It can tell the size of the item.
02:05Size related values.
02:07This is an attribute table.
02:10This is a value table.
02:12First, we will make attributes.
02:15This is a value table.
02:17To make attributes, you can select, full list or new.
02:23You can directly make a new.
02:25We will select full list.
02:27You will see the table.
02:29This is the table of item attributes.
02:31If you click on new on this table, it will let you make a new.
02:35What is shown in the list.
02:37Let's assume that I want to make colors.
02:41I don't want an option in text.
02:44I want multiple options.
02:46If you click here, it will take you to the item attributes.
02:52If it is not editable, click on editable list.
02:57If you want to make a new, click on new.
02:59The cursor is blinking.
03:02It will let you create a new.
03:04You can start writing.
03:06For example, red.
03:10The table we saw earlier.
03:12The card we are making.
03:15The deck was black.
03:17So I took black.
03:19If you have multiple options.
03:21If you have multiple options in your inventory.
03:24You can use that too.
03:26This will not be auto capital.
03:31If you want to keep capital from the start.
03:34You have to work hard.
03:36You have to be careful while writing.
03:39Assume that you want to add more colors.
03:43You have to apply variations.
03:45There can be many types of blue.
03:48Sky blue.
03:49Navy blue.
03:55Ivory blue.
04:01Light blue, dark blue.
04:03If you want to write anything else, you can write that too.
04:06You can add a lot of options.
04:08This is how it will be added.
04:10Item attribute values.
04:12This will be connected to the item attribute table.
04:16This is the item attribute table.
04:18Come back.
04:20Let's check what we made.
04:22Colors are on the option.
04:24Red, black, white.
04:26When you assign it on the item card.
04:28You can choose any single color.
04:32You can see it like this.
04:36If you want to edit something.
04:38You can edit it.
04:40I will show you one more thing.
04:42The text.
04:46If the material description is wood.
04:48When you create on the system.
04:50Assign item attribute.
04:52It will let you write on the field.
04:54You have chosen the text.
04:56You want to write that it is wood or metal.
04:59Whatever it is made of.
05:01If it is a plastic chair.
05:03You want to write plastic.
05:05Material description.
05:07Metal, plastic, wood.
05:09Ethnic.
05:11Whatever it is, you can write it.
05:13You can use it like this.
05:15Decimal.
05:17I will show you.
05:19Width, height, depth.
05:21What do you have to select here?
05:23You have to select decimal.
05:25Unit of measure.
05:27Centimeter, inch.
05:29Whatever is according to you.
05:31You can write that.
05:33If you want to write 60 cm, 20 cm, 50 cm.
05:35You can write that.
05:37You can write that in inch.
05:39Because you have chosen decimal.
05:41What other values do you have?
05:43I have shown you by using the option.
05:45It is a date option.
05:47You will use the date option.
05:49When you want to show.
05:51Manufacturing date.
05:53If you want to show.
05:57If you want to show.
05:59You can use the date option.
06:03If you don't want to use.
06:05You can block it.
06:07If it is not editable here.
06:09When you.
06:11When you.
06:13When you create on invoice.
06:15While receiving.
06:17Or while shipping.
06:19Or while invoicing.
06:21When you use the laser entry.
06:23Then you will be in that field.
06:25It will let you write.
06:27Like that was text.
06:29And second.
06:31This was date.
06:33Where you don't want to create values.
06:35You can leave it there.
06:37It will let you write.
06:39When you will enter.
06:41Because there is no other field.
06:43And this is not editable.
06:45So in this way.
06:47We have made a date.
06:49We have also seen a description.
06:51Integer.
06:53If you want to understand integer.
06:55What is integer?
06:57It is a full value.
06:59Any number.
07:01In which there is no fraction decimal.
07:03You can write that.
07:05You can decide the unit of measure.
07:07With numbers.
07:09Model year.
07:11You can write here.
07:13In this way.
07:15You can use it.
07:17Everything is done.
07:19Now.
07:21Assume we have to assign colors.
07:27Now.
07:29What are we assigning for ethern desk?
07:31Which item did you bring?
07:33Ethern desk.
07:35There was black color image on the screen.
07:37So I took black.
07:39Ok.
07:41Now see carefully.
07:43Depth.
07:45Width.
07:47Whatever is assigned in this list.
07:49Plus.
07:51What is the color?
07:53Now it is black.
07:55And where is it coming from?
07:57It is coming from this list.
07:59Whatever you see in this list.
08:01If you don't want to show the depth.
08:03Then you.
08:05Remove.
08:09Click above.
08:11If it is assigned.
08:13And it is used somewhere.
08:15Then you.
08:17Don't change.
08:19It will tell you to delete.
08:23To remove from this list.
08:25It is already in this list.
08:27So either delete the line.
08:29That I don't want to show this depth.
08:31Or.
08:33If you want to show.
08:35Then leave it.
08:37So let's show.
08:39We have added all these things.
08:41So let's cancel.
08:43So whatever you don't want.
08:45You can show.
08:47And here also.
08:49You have a selection feature.
08:53What you select.
08:55Ok.
08:59And.
09:03In this way.
09:05You can use it.
09:07Now this is done.
09:11Now we will just view it.
09:13We can also view.
09:15And what we can do.
09:17We can open it in editable mode.
09:19As you wish.
09:21If you want to edit.
09:23Then changes will be applied.
09:25It will not let you edit in view mode.
09:27That's it.
09:29Now the point is.
09:35Sometimes it doesn't refresh.
09:37It doesn't come at once.
09:39It will not be visible on the screen.
09:41You can see.
09:43As soon as you refresh.
09:45It comes.
09:47Sometimes it hangs here.
09:49So ok.
09:51Now the main point is.
09:53We have added it manually.
09:55If we want to bring an automatic list on the system.
09:57Then we all know.
09:59That we use.
10:01Configuration package.
10:03Now in the configuration package.
10:05I have made.
10:07A configuration package.
10:09We need a table of item attributes.
10:11And we need.
10:13A table of item attributes values.
10:15So we need these two tables.
10:17Now this process is going on.
10:21See I have made this.
10:23Let's edit it.
10:27Here I have.
10:297500.
10:31Searched on the table.
10:33You write item attribute on the search box.
10:35It will show you by searching.
10:37It will show you.
10:39Which table it is.
10:41It came.
10:43So item attribute.
10:45And 7500.
10:47And 7500 for a value.
10:49So I checked the numbers of both.
10:51And the number of item table was.
10:53I have given the parent item.
10:55That it is 27.
10:57It will connect to that table.
10:59And this is for the parent item.
11:01And this is for the base main table.
11:03Item attribute.
11:05Now.
11:07Which field I want.
11:09Like available fields.
11:11Let's see.
11:13You have available fields.
11:15Name, ID, type, unit of measure.
11:17So the unique.
11:19Thing is ID.
11:21Primary key.
11:23And the rest.
11:25You can take the whole.
11:27Otherwise.
11:29What you can do.
11:31Editable.
11:33You can select.
11:35What you have to do first.
11:37Clear included.
11:39The whole will be clear.
11:41The field will be auto selected.
11:43I want the name.
11:45The field should be editable.
11:47Edit list.
11:49I want type.
11:51I want unit of measure.
11:53That's it.
11:55As soon as you come out.
11:57Because you have selected.
11:59You checked.
12:01Included.
12:03Go to available.
12:05Edit list.
12:07The field I want.
12:11Tick that.
12:15Come out.
12:17And validate.
12:19What we did.
12:21Tick included.
12:23And if you have doubt.
12:25Validate relation.
12:27It will be validated.
12:29You have to go to available field.
12:31Tick available field.
12:33As soon as you validate.
12:35It will be updated in included.
12:37You can check.
12:39The block is removed.
12:41You will not see the block.
12:43Because you excluded it.
12:45So this field.
12:47Included.
12:49You will see it like this.
12:51Now what you have to do.
12:53Simple thing.
12:55You have to.
12:57In this way.
12:59Export to excel.
13:01Your file.
13:03Will be exported.
13:05After export.
13:07It will create two tables.
13:09You have to put values in it.
13:11And import it.
13:13Export and import.
13:15Method.
13:17Attach with item.
13:19We will continue this part.
13:21In next video.
13:23Subscribe to the channel.
13:25Thank you.