Adding a Stock Item Image on a Report
I am new to Acumatica but have been working with Reports for a few weeks. Based on custom attributes, I am able to conditionally print values on a printed form if certain conditions are met. I was wondering if anyone has been able to print the item picture (stock or non-stock) using a similar condition. For example, some of our products qualify for being "certified" by an agency. If a particular item has this certification, I would like to print the "certification seal" on the form. I thought including the seal in the image section for attributes might be work but haven't found a way as of yet.
We have customized Acumatica to show and print pictures on the line level. Let me know if you would like to discuss in more detail.
The item pictures are ultimately stored in UploadFileRevision.BlobData. You can link to this table by joining InventoryItem with NoteDoc (InventoryItem.NoteID=NoteDoc.NoteID) and then with UploadFileRevision on the FileID field. You can technically have multiple images per item so you'll either need to filter by file name (ex: image should always be called "CertificationSeal.png") or use a subreport that will print out all the images.
The Picture box control can be bound to a database field (Source=Database, Value=select the UploadFileRevision.BlobData field). The VisibleExpr property can be used to control whether or not the picture box shows. More information on the picture box can be found here.