Hi Acumatica Community,
We add a lot/serial attributes to a specific item and tag this upon purchase receipts.
I have a challenge to add this information to the Generic Inquiry.
Is there a way to show this info in a generic inquiry?
Thank you!
Solved
Lot/Serial Attributes in Generic Inquiry
Best answer by bwhite49
It used to be that you needed to connect to the LotSerInfo table in a join that looks like the screenshot below. For each attribute you needed to create a new join to the lot ser info table (with aliases)
In your case you would swap the InLotSerialStatus table with the POReceiptSplit table.
Your data is store in the LotSerInfo value field,
+1
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
+12
It used to be that you needed to connect to the LotSerInfo table in a join that looks like the screenshot below. For each attribute you needed to create a new join to the lot ser info table (with aliases)
In your case you would swap the InLotSerialStatus table with the POReceiptSplit table.
Your data is store in the LotSerInfo value field,
Hi
May I request a screenshot of your GI, specifically in the Data Sources Tab?
I cannot find the LotSerinfo Table.
+12Sorry, Looks like they renamed to “INItemLotSerialAttribute”. The screen is Lot/Serial Details.
Thanks!
+12Yeah, 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.