Hi, I am trying to write query for sales order information, this query would provide all information related to sales order, I am finding difficulty with writing query for Pack no, this is what my results are, based on the query I have written its deriving duplicate pack number. Is there a way to c…

Are you just asking for 1 field that shows Order-line example being your first line 5-2? It would just be a calculated field where you say OrderDtl.OrderNum + ‘-’ + OrderDtl.LineNum That is if you are using the Order Detail table. Sub out the fields with what you are actually using.

Thanks Nick, Do I have to add a User define field in the data table in order to derive pack number from the shipdtl table

Not sure I fully understand. Are you just trying to show any packing slips related to that order and line?

Yes, I’m trying to show all the packing slip for that sales order and line

Discussed (And resolved) at Length on this thread. [image] BAQ: Calculated Field Concatenate Rows to single field Experts' Corner Is there a function/query that will allow multiple returned rows to be combined into a single field? I’m looking thru the PO Tables and findi…

Thanks Jose, I checked that thread, it provides solution to query from single field, i.e deriving PO to Job, but am looking for sales order and line no combination to derive packing slip, I had no issue in deriving invoice number, but am finding it difficult to program for combination. other option…

Make a calculated field in your BAQ. There is an editor for this that will show you all the fields and and most of the functions) you can use to make the new column (i.e. - calculated field)

my guess the dups are due to how the tables are being joined. OrdDtl has ordernum, order line ShipDtl has ordernum, orderline, and orderrelnum multiple release orders would cause dups for PackNum, Pack line How are you joining the tables? Posting the query phrase will help you get more assist…

[image] knash: are you joining the tables? Posting the query phrase will help you get more assista [Subq4] [Subq1]

What are the Displayed columns in SubQuery4? And are they grouped?

BAQ - Multiple info in One field

Epicor ERP 10

josecgomez (Jose C Gomez) September 4, 2020, 4:18pm 6

Discussed (And resolved) at Length on this thread.

Topic		Replies	Views
Baq Aggregation Question Kinetic ERP baq	16	1173	July 6, 2022
BAQ to search all lines Epicor ERP 10 baq	7	885	July 10, 2023
Number of shipments per sales order Epicor ERP 10 baq	2	572	July 22, 2019
What's going on here? Epicor ERP 10 e10 , baq	10	851	October 26, 2021
BAQ Multiple Rows Epicor ERP 10 baq	29	6381	October 27, 2020

BAQ - Multiple info in One field

Related topics