By using this website, you agree to our Terms of Use (click here)
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.
Hi Ron,
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.
Thank you
Gary
Hey Gary, that sounds pretty amazing. I do not think that we have an application for getting to that level yet but, I will definitely reach out if I get the request.
I appreciate the offer.
Best regards,
Ron
Hi Ron,
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.
Great Information Gabriel, a big help! I will give it a go and let you know.
Thank you very much!
@ront05 As Gabriel pointed out you can customize the report and use the image component and show the images, also you can do a small modification to Item profile where you upload all images, add a custom boolean field and if it's enabled then that's a certification seal image and then just use that image to print on the report, that would make it easier for users to check any image to be the one which gets printed out ...
We do this approach in 3 of our plugins eSignature, Printshop and Jewelshop, where we print product images on reports ...
Is it possible to also show the item picture in a generic inquiry?
@jesst560 Not that I know of. I think you'll need to use Report Designer unfortunately.
@jesst560 GI - generic inquiries doesn't allow to show product images/pictures, however if you create custom screen and add the grid control then you can show product images.
We have implemented this in our plugin JewelShop, ability to show jewelry product images in custom screen and GI, but definitely needs customization, as Tim said report designer is also an option to show images as well.
Thanks Tim!
Online Members
