Hi Pranav,
For example:
I have record of CustInvoiceJour, CustInvoiceJour2, CustInvoiceJour3,
so if i pass these three records in the LIST function, it creates a list with three records.
It also helps in conversion of record to list when we need to compare with same data. As many functions support only LIST as a parameter, so to pass the record we convert the same.
LISTJoin functions supports to create a UNION join using multiple lists. So it differs from LIST functions in this manner that LIST functions takes records as parameters, but LISTJOIN takes record list a parameters.
for example, we want to club CustInvoiceData, InventTransferJour and make a report with all relevant fields like document number, document date, then we can use LISTJOIN function to make a combined recordlist.
I have lot of different examples, if you need the same, i can share few.
One more thing, not to advertise but for knowledge purpose, you can buy my book "Electronic Reporting - The Hidden Gem", it will give you answers for most of the queries.
I am happy to help you here on MS community as well, looking forward for more such queries.
Regards,
Neeraj Kumar
Author of the book - Electronic Reporting - The Hidden Gem