How to populate the lotserial and expiry date per inventory ID in report designer

  • 4 October 2022
  • 3 replies

Userlevel 3

Hi all,


How do I populate all the lot/serial number and expiry date per InventoryID in Report Designer like this:


The lot/serial or expiry date need to display per InventoryID

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 (


This is my build schema:

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:



I think I missed a table to combine the relation. Can you help me with my concern?





Best answer by acumaticapm182 8 October 2022, 06:00

View original

3 replies

Userlevel 7
Badge +4

Hi @acumaticapm182! Have you tried basing your report off the Lot/Serial Number (IN613000) report?

This is setup to already show the items, the lot/serial, and the expirey date.


Userlevel 3



I found another solution on how to populate beside of inventory item the Expiration Date and the Lot/Serial number


Here’s the code in Variable field


=IIf([ARTran.InventoryID_description]<>Null, [ARTran.InventoryID_description]+'{br}','')

+IIf([ARTran.ExpireDate]<>Null, [ARTran.ExpireDate]+'{br}','')

+IIf([ARTran.LotSerialNbr]<>Null, [ARTran.LotSerialNbr]+'{br}','')







Userlevel 7

Thank you for sharing your solution with the community @acumaticapm182 !


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved