Hi Everyone,
I have created a saved search on the ...
# suiteanalyticsn
Nilesh Patil
10/28/2020, 6:13 AMHi Everyone,
I have created a saved search on the Bill Payment and I want to show the Invoice number(present on the Bill which is connected to the Bill Payment) in that saved search but I can't find it under any field.
Kindly help me here to add the Vendor Invoice Number column in the results of this saved search!!!
Below is the criteria I have applied:
b
battk
10/28/2020, 6:20 AMtransactions are represented by multiple rows
n
Nilesh Patil
10/28/2020, 6:20 AMsorry I could't get u?
b
battk
10/28/2020, 6:21 AMand the paid transaction of a bill payment will be represented by multiple rows since it can pay multiple bills
battk
10/28/2020, 6:24 AMif you require multiple rows to be represented by a single row then expect to learn how to use a formula with LISTAGG
n
Nilesh Patil
10/28/2020, 6:24 AMyes, but it is showing duplucate rows even if i group it won't work
b
battk
10/28/2020, 6:24 AMor the more nonstandard and unsupported _NS_CONCAT_
battk
10/28/2020, 6:25 AMits showing multiple rows since there are multiple transactions a bill payment can pay