Rank a search result by the sum of amount, grouped by item. Solution: As you are aggregating the results (MIN, MAX, SUM etc) you also need to aggregate the expression in the ORDER BY clause, so that the results returned by the ROW_NUMBER() function match up with the summarized results of the rest of the saved search. All you would… Continue reading Sequence Number column for a summarized saved search
Tag: row sequencing
Display Row Numbers in Saved Search Results
1. Navigate to Lists > Search > Saved Searches > New. 2. Select the Search type. (e.g. Transaction).3. Enter a search name in the SEARCH TITLE field.4. Under the Criteria tab, enter the preferred filters.5. Under the Results tab, enter the preferred fields and include the following: Formula (Numeric) field > Under the FORMULA column enter rownum. Note: Select the Formula (Numeric) row and move it to the top by clicking the Move To Top button. 6. In the SORT BY field select Formula (Numeric) –… Continue reading Display Row Numbers in Saved Search Results
Group the items in Picking Ticket print based on ‘Customize via’ field
This article is to group the items in the Picking ticket print of SO based on a field.