In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Questions Adding Item Type to expression
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.