I tried this out, found an issue when there's multiple tenders per invoice. E.G. if someone does a payment by two different tender types

to fix this I did the following:

1.  Update the join

LEFT JOIN (
 SELECT
 iInvNumID,
 STRING_AGG(TenderDescription, ', ') WITHIN GROUP (ORDER BY iTenderID) AS ConcatenatedTenderDescription
 FROM _bvPOSXZTenderTxFull
 GROUP BY iInvNumID
) XZ ON I.AutoIndex = XZ.iInvNumID

2. Update the Field Name to be:

ConcatenatedTenderDescription

Thank you so much for your valuable contribution, Nehal Pi !

Hello Bennie, 

This link isn't working at the moment

Hi Arthur

I just tested it and it's working fine:

https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=251013143906890&page=1&position=0&q=251013143906890

Can you please try again?