Hi all,
How do I populate all the lot/serial number and expiry date per InventoryID in Report Designer like this:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/2717e221-90c1-48cb-9d98-d9dbec3eeaa0.png)
This is the value from expression editor (InventoryID Description field)
=IIf([ARTran.InventoryID]<>Null, Format( '{1}', [ARTran.InventoryID],[ARTran.TranDesc]),[ARTran.TranDesc])
I found other topics from here in community and I followed their combination in Build Schema but it’s not working for me
Link: (Print Batch/Lot no. and expiry date on invoice | Community (acumatica.com))
This is my build schema:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/7a6cae6f-6782-47b3-b812-a66e2db06022.png)
I added the ARTran Left INLotSerialStatus table and the parent field below
INLotSerialStatus.inventoryID Equal ARTran.inventoryID
INLotSerialStatus.lotSerialNbr Equal ARTran.lotSerialNbr
This is all my table:
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/946853c9-480b-4404-8029-6f2233603c53.png)
I think I missed a table to combine the relation. Can you help me with my concern?
Thanks
Best answer by acumaticapm182
View original