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)

Hi @Naveen B thanks for replying, this is possible in the Acumatica Report Designer?

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.

Thank you for the replies, @Gabriel Michaud and @Naveen B!

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:

Hello All!

I’m trying to add Vendor_Lot# and MfgDate to a report. it is added to PO receipt as attributes in CSAnswer. however, cant pull them in schema.

 i tried to follow steps provided here, but i dont get to see attributes to add to GI or in report designer.

Thanks!

Arjan

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

Thanks @BenjaminCrisman !.

i just created a new thread to discuss this further here:
Add VendorLot#(attribute&value) and MfgDate(attribute&value) to a PO Receipt report. | Community (acumatica.com)