Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Item attributes in Bus...
Business Central forum

Item attributes in Business Central

(0) ShareShare
ReportReport
Posted on by Julien PKF Cooper P...

Hello,

There seems to be no way to 'Edit in Excel' the table containing item attributes.

I have been able to use the 'Edit in Excel' function to mass upload attribute values, but now I can't mass apply values to items.

With 2,500+ items to do, this makes this feature unusable for historical data.

Does anyone have a suggestion?

Many thanks,

Julien

Categories:
Business Central
Inventory and warehouse management
  • Soren Groes-Petersen Profile Picture
    Soren Groes-Petersen on at
    RE: Item attributes in Business Central

    See also related discussion: community.dynamics.com/.../268569

  • Suggested answer
    Julien PKF Cooper Parry Profile Picture
    Julien PKF Cooper P... on at
    RE: Item attributes in Business Central

    Hello,

    You need to use the 'Item Attribute Value Mapping' table. (table 7505).

    You probably will want to export tables 7500 and 7501 also so that you can get the code for the item attribute and the item attribute, to use in the value mapping table.

    I hope that helps!

    Julien

  • MCarrero Profile Picture
    MCarrero 772 on at
    RE: Item attributes in Business Central

    Can you please elaborate as to how you tie the attribute/values to the item number using config pkg?  I am having troubles doing so.

  • ipablocerdan Profile Picture
    ipablocerdan 111 on at
    RE: Item attributes in Business Central

    You’re welcome!!!

  • Julien PKF Cooper Parry Profile Picture
    Julien PKF Cooper P... on at
    RE: Item attributes in Business Central

    Hi

    Yes rapid start wasn't available in Finance and ops.

    I've just realised it's now available in Business Central! :)

    Thanks,
    Julien

  • Verified answer
    ipablocerdan Profile Picture
    ipablocerdan 111 on at
    RE: Item attributes in Business Central

    Do you know configuration packages?

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

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,430 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans