Skip to main content
Answer

Joining tables through text/description field?

  • March 27, 2025
  • 1 reply
  • 34 views
J
Semi-Pro I
Forum|alt.badge.img

I am building a GI that would link service orders with sales order. In this case, the service order is not created from the sales order, so they are not inherently linked. Instead, the sales order number is entered manually in the description of the service order.

So I am looking to join the service order and sales order tables through the service order description text field. How would I do this join?

The join above is not getting me any results.

 

Best answer by BenjaminCrisman

​@jwarren If the DocDesc is strictly the order number, then I think it could work, but if there is any other text or spaces then I think it won’t work. A good join to Sales Order table though will also contain the DocType, do you have a way to properly link to DocType also?

I tested locally and it worked for me:

 

1 reply

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • Answer
  • March 27, 2025

​@jwarren If the DocDesc is strictly the order number, then I think it could work, but if there is any other text or spaces then I think it won’t work. A good join to Sales Order table though will also contain the DocType, do you have a way to properly link to DocType also?

I tested locally and it worked for me:

 

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
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