Solved

print digital images on a production workorder

  • 8 August 2022
  • 1 reply
  • 29 views

I researched all the articles that came up and not sure I am getting to an answer.

We have a client that creates production from a sales order.  In the BOM they have pictures at the step level.  prior to Acumatica it was done in word which is a no brainer. But now that they are automating, they want to produce the router with the image on the print out.

 

icon

Best answer by Gabriel Michaud 8 August 2022, 19:39

View original

1 reply

Userlevel 7
Badge +9

The Acumatica Report Designer allows you to link to any table and then show the pictures attached to a row.

When you attach pictures to a rom in your BOM,  the pictures are ultimately stored in  the UploadFileRevision.BlobData field. You can link to this table by joining the relevant AMBom**** table with NoteDoc (ex: AMBomStep.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 "PartDiagram.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.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2022  Acumatica, Inc. All rights reserved