Skip to main content
Question

Way to combine multiple lines of a sales Order into a single line using multiple joins?

  • September 22, 2025
  • 3 replies
  • 46 views

Forum|alt.badge.img

Is there a way to combine multiple lines of a Sales Orders into a single entry? I thought it might be possible to have multiple joins with SO Line Nbr being the criteria for each one, but I can’t seem to figure a way to have a number be a join criteria. Is there a way to do this?

3 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • September 22, 2025

Hi ​@kkraus ,

Is this a report or a generic inquiry?  What are you trying to accomplish in the results?  Please provide a little bit more context.


Forum|alt.badge.img
  • Author
  • Freshman II
  • September 23, 2025

Hi ​@kkraus ,

Is this a report or a generic inquiry?  What are you trying to accomplish in the results?  Please provide a little bit more context.

Generic Inquiry. I’m trying to get all of the lines of a Sales Order into a single entry line. That way, I can display all the parts of a Sales Order in a Teams Update. As it stands with the current table, I can only select the first line of the order.


Chris Hackett
Community Manager
Forum|alt.badge.img
  • Acumatica Community Manager
  • November 5, 2025

Hi ​@kkraus were you able to find a solution? Thank you!