Lot/Serial Attributes in Generic Inquiry

​@Fie are you on 25R1 using the Lot/Serial Attributes feature? or this is a customization package?

I’m using the standard lot/serial attributes in 2025 R1.

I am looking for a way to show this in the Purchase Receipts Primary List through generic inquiry

Hi ​@bwhite49,

May I request a screenshot of your GI, specifically in the Data Sources Tab?

I cannot find the LotSerinfo Table. 

Sorry, Looks like they renamed to “INItemLotSerialAttribute”. The screen is Lot/Serial Details.

​@bwhite49 , have you made any inquiries with this info yet? I checked that DAC and the ‘value’ field does not seem to exist. It looks like the data is stored in the INItemLotSerialAttributesHeader DAC but not as a ‘value’ field but each possible attribute is its own individual field. Which is fine at first but that issue I’m running into is that I need to group by the attribute value and you cannot seem to do that now. Whereas when everything was stored in CSAnswers, you could. Has anyone run into this issue or am I missing some other table?

Thanks!

 

Yeah, the attribute data is in the INItemLotSerialAttributesHeader, but I believe the data is stored in a KVExt table now like UDF attributes.

In order to access the raw data now which is often required in complicated inquiries, the table needs to be extended through a customization. Kind of a pain.

I don’t know why the KVExt tables are hidden. My preference is always that things get easier rather than harder, but apparently that was not an option here.