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

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Sortorder of Attribute values can't be changed?

(0) ShareShare
ReportReport
Posted on by

I'm entering my attribute values and when they are shown I get the last enter value last. I wan't however to decide myself in what order they should be showed.

I give you an example,

I start selling T-shirts

I do an attribute called size.

In the start I selling the sizes (attribute values) S, M, L

The I decide to sell size XL as well, that works fine since the sizetable will show S, M, L, XL.

BUT deciding to sell also the size XS it goes wrong, the table will then show S, M, L, XL, XS and that's not so userfriendly, I would like to show the table in sizeorder, XS, S, M, L, XL.

How can I change to order of the attributes value?

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Marcellus Profile Picture
    2,735 on at

    Hi Matsjepsen,

    The order of the attribute values will be determined based on the ID field (this is not visible on the Item Attribute Values page). This field is auto incremented by the application when you create new attribute values so it is not allowed to modify it.

    You will also have these attribute values assigned already to items and you may also have translations. All of these records are using the ID. If you have tried to delete an attribute value before you know that the application will present you with a confirmation dialog:

    This item attribute value has been assigned to at least one item.

    Are you sure you want to delete it?

    ---------------------------

    No   Yes

    ---------------------------

    I think you need a customisation and my idea would be to add a new field to the attribute values called "Sort ID" where you can specify the order of the values and you need a routine that you can invoke with an action button on the ribbon to sort your attribute values based on the custom field.

    This routine will have to re-create your attribute values in the defined order and update the relevant Item Attribute Value Mapping and Item Attr. Value Translation records.

    Let's see what others think.

  • Community Member Profile Picture
    on at

    Hi Marcellus

    Thanks for you reply.

    Customisation is not an option for me, I really was expecting MS to have a better attribute functionality than what we see now. I was very happy when MS announced the attribute launching NAV2017. Hopefully MS will come up with an improved attribute functionality in an update or at least in NAV2018.

    Let see if anyone else have an other idea.

    Regards

    Mats

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

Responsible AI policies

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

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans