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!

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Sergei Minozhenko 23,093 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

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

RelationShip between items and Item Groups

Was this reply helpful? Yes No
Sergei Minozhenko 23,093 on at

Like (0)

Report
Copy link

Link copied!

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).

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

Nothing is showing in the list page

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (1)

Report
Copy link

Link copied!

Hi CBNestor,

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

Was this reply helpful? Yes No
CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Suggested answer

CBNestor 46 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No