Good afternoon colleagues
I have 2 questions:
I have made Query in the Dev Environment which i use to output to excel
It has the following columns among others:
Purchase Order Document Number ( from table 38 PO Header)
Purchaser Code (also from table 38)
Expected Arrival Date ( also table 38)
Now I would like to add a column in which the item numbers (from table 39) for that PO will be concatenated
Each PO has only one or two items
Purchaser_Code | Document_No | Item No |
LH | IP-211274 | 10903, 20298 |
First question: Can anyone advise how to do this textjoin?
Second question: How do i order the report by the Expected Receipt Date?
Thank you in advance,