By using this website, you agree to our Terms of Use (click here)
My client wants to print the vendor item number on a PO only if the item number is Stock Item. They don't want this for non-stock items. In the Expression Editor, I tried to use [POLine.IsStockItem]=True but that did not seem to work. I tried this expression as a test =IIf( [POLine.IsStockItem]=True, 'Stock', 'Not' ), the result is always 'Not' Using =False gets the same result.
Is there another way to test if an item on a PO line is a Stock Item?
I don't see that POLine field in my version of Acumatica. Join to the InventoryItem table and your expression works just fine.
=IIF([InventoryItem.StkItem]=True, 'Stock', 'Not')
Thanks for this. Strange that you don't see the POLine field. I'll link the Inventory table and use the field you've suggested. Thanks again.
Online Members
