If I have a large list of sales order numbers (let...
# administrationd
Dan Warner
11/30/2023, 8:40 PMIf I have a large list of sales order numbers (let's say 100), what is the easiest way to then get a list of each invoice number associated with each sales order?
t
Tim Chapman
11/30/2023, 8:46 PMSaved Transaction search - Criteria = Type - Invoice
Main Line = True
Results -
Document Number
Created From
w
Watz
11/30/2023, 8:48 PMCriteria Formula(number): case when {fieldRefThatYouHave} in(listOfValuesSeparatedByComma) the else 0 end
Equal.to 0
Watz
11/30/2023, 8:49 PMEasiest is to probably to have {createdfrom} as the field and then the internal ids for all sales orders in the "in"-clause.