Solved

Generic inquiries - Add Attribute Value ID

  • 3 April 2023
  • 5 replies
  • 370 views
R
Rank
Userlevel 5
Badge +1

Hi, In the Result Grid Tab, when i add a column and I set it to the attribute, it show the Attribute description by default. 

How to show the Attibute Value ID instead of the Description?

I already tried a lot of workaround like Attibute.Value without any succes.

I don’t want to use “schema field” because i will need to put this in formula .

My starting point is from the Non stock list PX.Objects.IN.InventoryItem

Thanks

 

 

icon

Best answer by raphrf 17 May 2023, 23:46

View original
Raphael

5 replies

BenjaminCrisman
Rank
Userlevel 7
Badge +4

@raphrf The attribute should already be part of the item, the field would look like:

[InventoryItem.FILGAUGE_Attributes]

The attributes themselves are stored in the CSAnswers table and joining to InventoryItem table on NoteID = RefNoteID you can display the value off CSAnswers if needed, though it should appear as expected in the InventoryItem table, like this:

Otherwise I guess I may need to see your result to better understand the issue

R
Rank
Userlevel 5
Badge +1

Hi , first thanks for the quick answer. I’m not sure to understand the answer

I tried to add the CSanswer table with an inner join as explained.

But i have lot more row than the beginning, it repeat each row for each attributes.

 

I have more then one attribute related with the row, but i want to do this with only one attribute

 

I put more image to help :

We want this :

 

The attribute is the last one here

 

It map the description and not the attribute value in the GI: 

 

Raphael
Chris Hackett
Rank
Userlevel 7
Badge

Hi @raphrf were you able to find a solution? Thank you!

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
R
Rank
Userlevel 5
Badge +1

Hi Chris,thanks for the reminder !

Yes I am able now!

I added the table CSANSWER:

Relation added for CSANSWER:

 

Added the rows into Result Grid(i splitted it for my own needs)

 

Result as wanted :) :

Thanks for all 

Really appreciated!!!  😁

This community is awesome

Raphael
Chris Hackett
Rank
Userlevel 7
Badge

Thank you for sharing your solution with the community @raphrf !

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved