This is part 2 of another post I created in which there is a list of articles that will change and it will only show them if there stock is bigger than zero. Thanks to Fluffy I was able to make it work, but there is still something missing that I don't know how to do it: There are articles that have more than one location and I want to show them all without repeating the same location, how can I do this?
Example: This is the current
A# A.Name Location Stock
567 Adios zcxz 3
What I want is to show all locations for that article without repeating same location:
A# A.Name Location Stock
567 Adios zcxz 3
567 Adios abcd 4
567 Adios xxxx 6
567 Adios adfg 8
567 Adios sfsqa 10
654 Dos zxca 44
678 Day asd 23
678 Day bcx 44
....
Example: This is the current
A# A.Name Location Stock
567 Adios zcxz 3
What I want is to show all locations for that article without repeating same location:
A# A.Name Location Stock
567 Adios zcxz 3
567 Adios abcd 4
567 Adios xxxx 6
567 Adios adfg 8
567 Adios sfsqa 10
654 Dos zxca 44
678 Day asd 23
678 Day bcx 44
....