Solved

Printing the Subitem segmeted value descriptions

  • 4 January 2021
  • 2 replies
  • 85 views

I have a client that uses Subitems and I have modified some reports to show the sub item along with the inventory ID but they need the segment value description to print instead of the segment value. 

In this setup, there are 5 subitem segment IDs, e.g. W-AE-FRS-PA -1/10 where W = Wild, AE = UAE, FRS = Frescomar, PA = Panulirus argus and 1/10 = 1/10 lb. 

Is there a way to link by the subitem back to the individual segments and pull the description for any or all of the subitem segments that make up the subitem so instead of printing the subitem as W-AE-FRS-PA it would print as Wild-UAE-Frescomar-Panulirus Argus-1/10lb.

icon

Best answer by bchilders37 18 October 2021, 17:32

View original

2 replies

Userlevel 2

Hi @bchilders37 
As far as I know there is no such facility in the box, but out of the box you can use SQL view to achieve the desired output, for this you need a singnificant knowledge in SQL querying and Acumatica customization, Let us know about your capability in Acumatica customization so we can guide you   

I was able to accomplish this, on the Sales order report SO611010, by building separate schema relationships on the  InSubItem and SegmentValue tables for each segment value and then extracting the specific segment value descriptions as needed in the report.

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