We use serial tracked products that sometimes get consumed into other internal orders but sometimes get sold as is to the customer. We are having a hard time finding a way to get a list of serial tracked items that have neither been consumed into other orders nor sold to the customer. Any guidance of how to best pull together this information into a GI that employees can check against?
I’m thinking probably some combination of ARTran and AMMTran info
Best answer by dgodsill97
The data is in INLotSerialStatus which is the data you see on the Inventory Summary when you check the box to show the lot/serial data/
+6
The data is in INLotSerialStatus which is the data you see on the Inventory Summary when you check the box to show the lot/serial data/
+1Hello
I understand that you are looking to review Lot/Serial Numbers that have not been used (sold or consumed).
The simplest solution would be as
If a Lot/Serial Number is On Hand, then is has not been consumed or sold.
However, I also want to share the Lot/Serial Attributes (a core function starting in 2025R2, customization before this version).
Both the customization and the new experimental core function adds the “Lot/Serial Details” form, which might help your team:
It also creates a “History” tab for each Lot/Serial Number, so you can track where the Lot/Serial Number was used.
Lastly, I want to share the Summit 2026 Manufacturing Break Out Sessions, specifically Session “Inventory Tracking: Unlock the Power of Acumatica Lot/Serial Traceability” (Summit 2026 Breakout Presentations - Manufacturing | Community)
This presentation speaks to the topic of tracing Lot/Serial Numbers in Acumatica!
I hope this information helps!
That Inventory Summary screen doesn’t look like mine, so was just curious.
+1Hi
The screenshot comes from a 2025R2 instance (Build 25.200.0248) with Modern UI enabled!
AcumaticaERP_2025R2_Modern_UI_Features_Overview.pdf
Hope that helps!
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
