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 InventoryIDThis 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 belowINLotSerialStatus.inventoryID Equal ARTran.inventoryIDINLotSerialStatus.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
Hi Can you help me how to fix this issue. I want to create a Sales Order but I have a problem, when I’m doing SO I found out that I have no Inventory Balance but when I checked the items are there. What should I do? This is the Sales Order (Inventory ID - 00002647) This is the Inventory Balance I’ve already checked in Recalculate Inventory (IN505000) but it nothing happen Thanks
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.