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!
Answer
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
Valentina, Technical Product Manager - Distribution
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
+10
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.
+10Sorry, Looks like they renamed to “INItemLotSerialAttribute”. The screen is Lot/Serial Details.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.