Add Color id and Item Group in Release Product List Page Ax2012R3

(0) Share

Report

Posted on by CBNestor

Hello,

As many of you may know I am trying to update an old Axapta3.0 into Ax2012,

One simply Inquiry that I would like you guys is to show me how to add the Color number id and the Item group into the Products page list of items I want it permanent inside the model so every user has the same view/Configuration.

Here I show you how it looks in ax3.0 (I have renamed the COLOR dimension into REV.)

into ax 2012

I know for you Is a very simple solution, Not that much for me :) , I hope I can learn the best practices from you

Your help is highly appreciated,

thanks a lot!

All responses (8)

Answers (1)

Suggested answer

CBNestor 44 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Hi Sergei,

thanks for the help

It was actually pretty straight forward, just needed to know the real actual column name, in case of the default color Id was : StandardItemColorId.
CBNestor 44 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Hi Sergei,

Excellent. It needed to be reset hehe. Did not know that. what does that happens?

I'll try with the next field of color Id and i will let you know
Verified answer

Sergei Minozhenko 23,089 on at

Like (1)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Hi CBNestor,

Strange, The field even doesn't appear on the form. Try to reset personalization on the form and open it again.
CBNestor 44 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Nothing is showing in the list page
Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Hi CBNester,

If you want to add an item group, you need to drag and drop a field ItemGroupId from InventItemGroupItem. The data source for the grid should remain as is but for the field, it should be filled with a correct data source for a field (InventItemGroupItem).
CBNestor 44 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

In Fact I could add the field with the Normal personalizations though the

RelationShip between items and Item Groups
CBNestor 44 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Hi Sergei,

Thanks for answering. I been reading the docs you gave. But I think I little more work has to be done.

I don't find the Field ItemGroupId or ModelGroupId in the InventTable datasource fields.

I have dragged the field from one the other Datasources in the query which is ModelGroupId and also the itemGroupId from IventIntemGroupItem data source But anything shows up in the

EcoResProductPerCompanyListPage

What should I do to add ItemGroupId into the Fields group inside the IvenTable Data source?
Suggested answer

Sergei Minozhenko 23,089 on at

Like (0)

Report

RE: Add Color id and Item Group in Release Product List Page Ax2012R3

Hi CBNestor,

You are trying to modify ListPage form and these kinds of forms using Query as a data source.

So steps to perform this change are

1. Identify the correct name of the form (Right-click on the form - Personalization - Information tab - Form name)

2. Check what query used on the form

3. Modify query if needed

4. If the query was modified in point 3, refresh it on the form to see new fields

5. Drag'n'Drop fields from data sources to the grid.

Here are some docs as well docs.microsoft.com/.../how-to-add-fields-to-the-list-page-grid