Hi all,
How do I populate all the lot/serial number and expiry date per InventoryID in Report Designer like this:
This is the value from expression editor (InventoryID Description field)
=IIf(fARTran.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