Skip to main content
Solved

How to modify existing report to display an image based off the inventory ID stock item description?

  • April 12, 2024
  • 4 replies
  • 233 views
D
Freshman I
Forum|alt.badge.img

We have a production ticket report for production of canned beverages.

There are 50+ product specifications. These are 1 page documents/images.

 

Is there a good way to display a specific product spec that is pulled from the inventory ID stock item description and matched with the 1 page image?

The only way I can think to do this is have 50+ sections with visibleExpr that would each display the image only if the statement below was true:
=iif([InventoryItem.ItemClassID_description] = 'BERRY LEMONADE', 'TRUE',

 

This would require a lot of work to set up and maintain 50+ image files.

If these product specs were to change every month or so, what would be the best way to update or set up these reports? Would a database setup allow for the image files to change without having to change anything in the report?

 

Best answer by lauraj46

Hi @dylantheriault ,

I think you could do it like this:

  1. Attach the image files inside of Acumatica to a specific non-stock item or some other entity. 
  2. Use the universal search to copy the exact filename to the clipboard.
  3. Save the filename in the description field the item class
  4. Reference that field on the image control in the Report Designer.

In the screenshots below I used the description on the Sales Order itself, but you should be able to use the item class instead.

 

 

 

 

 

Hope this helps!

Laura

View original
Did this topic help you find an answer to your question?

4 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • 567 replies
  • Answer
  • April 16, 2024

Hi @dylantheriault ,

I think you could do it like this:

  1. Attach the image files inside of Acumatica to a specific non-stock item or some other entity. 
  2. Use the universal search to copy the exact filename to the clipboard.
  3. Save the filename in the description field the item class
  4. Reference that field on the image control in the Report Designer.

In the screenshots below I used the description on the Sales Order itself, but you should be able to use the item class instead.

 

 

 

 

 

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
D
2 people like this
  • Chris Hackett
    Chris Hackett
  • D
    dylantheriault
D
Freshman I
Forum|alt.badge.img

Hi @lauraj46 I tried following this but a bit stuck.

 

In my case,

I have a production order.

On the production order the inventory ID goes to a Stock Item for the specific liquid flavour/product. 

 

  1. Save the filename in the description field the item class (this I can not do, as the production order description calls a specific sub-report in the main production ticket report.)

Is there anyway instead to pull the image file from the Stock Item Attributes screen, this would then be added to the production details in report designer to call the specific product spec jpg. image based on the specific stock item?

D
Freshman I
Forum|alt.badge.img

Something like
=[AMProdMatl.ImageUrl] or

=[InventoryItem.ImageUrl]

Maybe? @lauraj46 

Thanks for your help.

lauraj46
Captain II
Forum|alt.badge.img+8
  • lauraj46
  • Captain II
  • 567 replies
  • April 25, 2024

Hi @dylantheriault ,

You can retrieve an attribute value from the stock item by joining on the CSAnswers table.  Join on InventoryItem.NoteID to CSAnswers.RefNoteID.  You also need to include the Attribute code in the join because a stock item can have multiple attributes.  Reference [CSAnswers.Value] on the image control.

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
D
2 people like this
  • Chris Hackett
    Chris Hackett
  • D
    dylantheriault

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
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 — 2024  Acumatica, Inc. All rights reserved