Skip to main content
Solved

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


Forum|alt.badge.img

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 (acumatica.com))

 

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?

 

 

Thanks

Best answer by acumaticapm182

Hi

 

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}','')

 

 

 

Result:

 

 

View original
Did this topic help you find an answer to your question?

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 711 replies
  • October 7, 2022

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.

 


Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 38 replies
  • Answer
  • October 8, 2022

Hi

 

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}','')

 

 

 

Result:

 

 


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • 2756 replies
  • October 14, 2022

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings