Small and medium business | Business Central, N...

Using Item Category Code in Logic

(0) Share

Report

Posted on by antmas

Would someone please point me to documentation on how to incorporate Item Category Codes in to the Logic used in AL Code?

For example, "... if Item Category Code of "Gizmos", then table relationship = ... else ... "

As always, thanks in advance...

-Anthony

I have the same question (0)

All responses (7)

Answers (0)

Suggested answer

YUN ZHU 92,382 Super User 2025 Season 2 on at

Like (0)

Report

RE: Using Item Category Code in Logic

Hi, For multiple relationships in TableRelation, you can refer to the No. field on SalesLines.

More details: https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-tablerelation-property

For example, for Item Category Code

Hope this helps.

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,037 Moderator on at

Like (0)

Report

RE: Using Item Category Code in Logic

[quote user="antmas"]
Thank you, Inge. I will take a look.
[/quote]
Please let me know if that was not a good enough sample and i can probably find some more.

You f.ex. will find it also in the general journal line where account type will define what table account no. is related to.

Was this reply helpful? Yes No
Suggested answer

Jeffrey Bulanadi 8,431 on at

Like (0)

Report

RE: Using Item Category Code in Logic

Hi Antmas,

The purpose of item categories is mainly to help you sort and find items.

https://docs.microsoft.com/en-us/dynamics365/business-central/inventory-how-categorize-items

If you wish to see some samples codes that uses item category, You can go to at the below details

Table 5722 - Item Category: It uses parenting and indentation logic.

Codeunit 5722 - Item Category Management

Item Category Relation to other tables

https://dynamicsdocs.com/nav/2018/w1/table/item-category

Please verify and like if you find my answer helpful. Have a nice day and thank you.

Cheers,

Was this reply helpful? Yes No
antmas 60 on at

Like (1)

Report

RE: Using Item Category Code in Logic

Thank you, Inge. I will take a look.

Was this reply helpful? Yes No
Suggested answer

Inge M. Bruvik 1,037 Moderator on at

Like (0)

Report

RE: Using Item Category Code in Logic

If you look at how they use Source Type and Source Code in the standard application. F.ex. in the Item Ledger Entry table. You will get a good sample there.

Was this reply helpful? Yes No
antmas 60 on at

Like (0)

Report

RE: Using Item Category Code in Logic

Vaishnavi, thank you for your reply.

I am adding a custom field to the Item table with a relationship to other (custom table(s)).

Which of these tables is related would depend on which of the Item Category Codes is selected.

As I understand it, the data type of this ICC field is code, but when I attempt to make the relationship, I receive errors as it seems to want data type option. I've been successful using a workaround by using yet another custom field with options or enums and drive the relationship from that, but this approach doesn't seem very efficient. I'd like to use whatever I can of base functionality.

thanks again

Was this reply helpful? Yes No
Suggested answer

Vaishnavi J 3,060 on at

Like (0)

Report

RE: Using Item Category Code in Logic

Hi antmas ,

Can you elaborate a bit more what is your requirement do you want to set some value or fetch some thing using Item category code and which table is needed?

FYI Item category code is assigned in Item master.

And if that item is used in Purchase and Sales documents then Item category code is set on their Purchase and Sales lines as well.

If my answer was helpful to you, please verify it so that other users know it worked. Thank you very much

Was this reply helpful? Yes No