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

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
I have the same question (0)
  • Verified answer
    ipablocerdan Profile Picture
    ipablocerdan 111 on at

    Do you know configuration packages?

  • Julien PKF Cooper Parry Profile Picture
    Julien PKF Cooper P... on at

    Hi

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

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

    Thanks,
    Julien

  • ipablocerdan Profile Picture
    ipablocerdan 111 on at

    You’re welcome!!!

  • MCarrero Profile Picture
    MCarrero 774 on at

    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.

  • Suggested answer
    Julien PKF Cooper Parry Profile Picture
    Julien PKF Cooper P... on at

    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

  • Soren Groes-Petersen Profile Picture
    Soren Groes-Petersen Microsoft Employee on at

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

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 > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans