Display Attribute Values from Stock Items to Report

Hi @TharidhiP  To display the Stock Item attribute values, please join the below tables..

SOOrder (Order Type, OrderNbr) →  SOLine (Order Type, OrderNbr)

SOLine (InventoryID) →  Inventory Item ( InventoryID)

InventoryItem (NoteID) →  CSAnswers ( RefNoteID)

Sample Code for your reference → you can use the same in reports as well

PXSelectJoin<InventoryItem,
                                      InnerJoin<CSAnswers, On<InventoryItem.noteID, Equal<CSAnswers.refNoteID>>>,
                                      Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>,
                                      And<Where<CSAnswers.attributeID, Equal<BQLConstants.PRDTYPE>
                                      >>>>.Select(Base, objSOLine.InventoryID)

Yes, this is possible with Acumatica report designer

Hi @Gabriel Michaud   Actually, I forgot  :( and thanks a lot for sharing this.

@TharidhiP  We can avoid the CSAnswer table join, directly you can get the attribute values from the InventoryItem table (Attribute name will be AttributeIDName_Attributes) in Acumatica Report designer.

One common issue when looking for these attribute values is that if they have been recently added then they may not appear as an option to be able to select, which can be confusing.

To get around it make sure to refresh the schema of the report, this will ensure that the Attributes, however recently added, will be visible.

Open the build schema and on Tables tab > Load Schema > Refresh All:

Hi @arjan ! You have added the right table and the red box consists of the AttributeID, IsRequired, and Value seen in the CSAnswers table.

Once you add the needed fields (likely just AttributeID and Value) to the report you will be able to see these.

Make sure to join the CSAnswers table in also but if you get stuck I would recommend to make a new posting as this one is already answered, if you still need assistance we’ll help you in the new post :).