why is the “Show in Filter Region” Greyed Out. need to use the document number as a filter. SOLUTION: As an alternate solution, use the Document Number/ID field instead. To set Document Number as an available filter: Navigate to List > Search > Saved Searches Click Edit next to a Save Search Under the Available… Continue reading Creating a Sales Order saved search and used the document number as a filter. The Show in filter reg
Tag: saved search filter
Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search
Scenario When users use CONCAT to join multiple fields, the expression as below is used: Concat({fieldidAAA}, concat(concat(‘ ‘, {fieldidBBB}), concat(‘ ‘, {fieldidCCC}))) However, when the said expression is used to join a character, it gives an Invalid Expression. Sample formula that shows this problem: Concat({fieldidAAA}, concat(concat(‘ ‘, ‘&’}), concat(‘ ‘, {fieldidBBB}))) Solution Sample formula that shows… Continue reading Using Formula Expression CONCAT to Join 2 Fields and Character “&” in Between Gives Error Invalid Expression in Saved Search
Saved Search Filter does not shows all the values in the List
The List will only display all the values if there are 995 or less records in the system (including the inactive records). If there are more than 996 values on the List, then it will only display the following as an Available Filter: – All – – Unassigned – – Mine – – My Team… Continue reading Saved Search Filter does not shows all the values in the List