web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / How to Map Item attrib...
Small and medium business | Business Central, N...
Suggested Answer

How to Map Item attributes!!

(0) ShareShare
ReportReport
Posted on by Community Member

Is It possible to mapp item attribute values after creating  new item attributes like normal mapping

ItemR.Validate(Description, SMBItemStagingL.Designation);
I am try to create 100 items through a function and i have some item attribute so how can i map them
STEP1: I have created new item attribute values Item Attribute (7500) table 
STEP2:I have a setup page like inventory setup where i have mentioned the item attribute ID
STEP3: When i create new item through function is it possible to map the item attribute ..Any reference will be great,Thanks.
Categories:
Dynamics 365 Business Central
Dynamics 365 Business Central
I have the same question (0)
  • Suggested answer
    DAnny3211 Profile Picture
    DAnny3211 11,401 Super User 2026 Season 1 on at

    hi

    look this

    learn.microsoft.com/.../inventory-how-work-item-attributes

    DAniele

  • Community Member Profile Picture
    Community Member on at

    Thanks for the reply, but here it shows only the functional part, but how we can map the item attribute for multiple records how to  manually add them 

    ITEM NO Diameter length width height
    101 ABC 1 3 2
    102 ACB 2 2 3
    103 BAC 3 1 1

    If I create these item through a function how can insert attribute and mapp them

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 97,366 Super User 2026 Season 1 on at

    Hi, You need to pay attention to the following table. Item and Item Attribute are related through this table.

    table 7505 "Item Attribute Value Mapping"

    pastedimage1675128141319v1.png

    pastedimage1675128180402v2.png

    Hope this helps.

    Thanks.

    ZHU

  • Community Member Profile Picture
    Community Member on at

    Now The item attributes caption is coming while creating item I dont understand why the value is coming not , Any idea where I went wrong.

    pastedimage1675422223017v2.png

         

     local procedure SetItemAttibuteValue(Reference: code[20])
    var
        ItemAttributeL: Record "Item Attribute";
        ItemAttributeValueMap: Record "Item Attribute Value Mapping";
        ItemAttributeValue: Record "Item Attribute Value";
        SMBImportSetupL: Record "SMB Import Setup";
        ItemL: Record Item;
        SMBItemStagingL: Record "SMB Item Staging";
        DiameterIntegerL: Integer;
    begin
        IF SMBItemStagingL.Get(Reference) THEN BEGIN
            if SMBImportSetupL.Get() then begin
                //Diameter:
                SMBImportSetupL.TestField("Diameter mm");
                Evaluate(DiameterIntegerL, SMBItemStagingL."Diameter mm");
                SetAttribute(SMBItemStagingL.Reference, SMBImportSetupL."Diameter mm", DiameterIntegerL, 0, '');
            end
        end;
    end;
    
      local procedure SetAttribute(ItemNoV: Code[20]; AttributeIDV: integer; IntegerValueV: Integer; DecimalValueV: Decimal; TextValueV: Text)
    var
        ItemAttributeL: Record "Item Attribute";
        ItemAttributeValueMap: Record "Item Attribute Value Mapping";
        ItemAttributeValue: Record "Item Attribute Value";
        SMBImportSetupL: Record "SMB Import Setup";
        ItemL: Record Item;
        SMBItemStagingL: Record "SMB Item Staging";
        DiameterIntegerL: Integer;
        StrapIntegerL: Integer;
    begin
        if SMBImportSetupL.Get() then begin
            ItemAttributeL.Get(SMBImportSetupL."Diameter mm");
            ItemAttributeValue.SetRange("Attribute ID", AttributeIDV);
            if IntegerValueV <> 0 then
                ItemAttributeValue.SetRange("Numeric Value", DiameterIntegerL);
            if DecimalValueV <> 0 then
                ItemAttributeValue.SetRange("Numeric Value", DecimalValueV);
            if TextValueV <> '' then
                ItemAttributeValue.SetRange(Value, TextValueV);
            if not ItemAttributeValue.FindFirst() then begin
                ItemAttributeValue.Init();
                ItemAttributeValue."Attribute ID" := ItemAttributeL.ID;
                ItemAttributeValue."Attribute Name" := ItemAttributeL.Name;
                if IntegerValueV <> 0 then
                    ItemAttributeValue."Numeric Value" := DiameterIntegerL;
                if DecimalValueV <> 0 then
                    ItemAttributeValue."Numeric Value" := DiameterIntegerL;
                if TextValueV <> '' then
                    ItemAttributeValue.Value := TextValueV;
                ItemAttributeValue.Insert(true);
            end;
            ItemAttributeValueMap.Init();
            ItemAttributeValueMap."Table ID" := 27;
            ItemAttributeValueMap."No." := ItemNoV;
            ItemAttributeValueMap."Item Attribute ID" := ItemAttributeL.ID;
            ItemAttributeValueMap."Item Attribute Value ID" := ItemAttributeValue.ID;
            ItemAttributeValueMap.Insert(true);
        end;
    end;

  • Suggested answer
    Pushparaj Profile Picture
    Pushparaj on at

    Hi Can you Try The Below Written Code

    local procedure SetItemAttributeValue(Reference: code[20]; AttributeName: Text; AttributeValue: Variant)

       var

           ItemAttribute: Record "Item Attribute";

           ItemAttributeValueMap: Record "Item Attribute Value Mapping";

           ItemAttributeValue: Record "Item Attribute Value";

           SMBImportSetup: Record "SMB Import Setup";

           Item: Record Item;

           SMBItemStaging: Record "SMB Item Staging";

       begin

           if SMBItemStaging.Get(Reference) then begin

               if SMBImportSetup.Get() then begin

                   ItemAttribute.SetRange("Name", AttributeName);

                   if ItemAttribute.FindFirst() then begin

                       ItemAttributeValue.SetRange("Attribute Name", AttributeName);

                       if AttributeValue.IsInteger then

                      ItemAttributeValue.SetRange("Numeric Value", AttributeValue);

                       if AttributeValue.IsDecimal then

                      ItemAttributeValue.SetRange("Numeric Value", AttributeValue);

                       if AttributeValue.IsText then

                      ItemAttributeValue.SetRange("Value", AttributeValue);

                       if not ItemAttributeValue.FindFirst() then begin

                           ItemAttributeValue.Init();

                           ItemAttributeValue."Attribute ID" := ItemAttribute.ID;

                           ItemAttributeValue."Attribute Name" := ItemAttribute.Name;

                           if AttributeValue.IsInteger then

                          ItemAttributeValue."Numeric Value" := AttributeValue;

                           if AttributeValue.IsDecimal then

                          ItemAttributeValue."Numeric Value" := AttributeValue;

                           if AttributeValue.IsText then

                          ItemAttributeValue.Value := AttributeValue;

                           ItemAttributeValue.Insert(true);

                       end;

                       ItemAttributeValueMap.Init();

                       ItemAttributeValueMap."Table ID" := 27;

                       ItemAttributeValueMap."No." := SMBItemStaging.Reference;

                       ItemAttributeValueMap."Item Attribute ID" := ItemAttribute.ID;

                       ItemAttributeValueMap."Item Attribute Value ID" := ItemAttributeValue.ID;

                       ItemAttributeValueMap.Insert(true);

                   end;

               end;

           end;

       end;

  • Community Member Profile Picture
    Community Member on at

    Thank you for your support,I copied the same procedure and run but now it doesnot show any changes,Do you I need to make any changes in your code 

    pastedimage1675434030517v1.png

    pastedimage1675434075619v2.png

  • Pushparaj Profile Picture
    Pushparaj on at

    Hi what are this SMBitemstaging and SMBitemimportsetup?

    Are these Customized Table? If they are, then

    Make sure that the SMBItemStaging table has data that matches the "Reference" code passed to the SetItemAttributeValue procedure and Verify that the SMBImportSetup table has the correct setup for the "Diameter mm" attribute.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,170 Super User 2026 Season 1

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,283 Super User 2026 Season 1

#3
YUN ZHU Profile Picture

YUN ZHU 1,104 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans