Post Author: redstar
CA Forum: General
Hello,
I am trying to write a report on stock levels etc
Only problem is that we have variances on the same item e.g. unfinished, size, colour
What I want to do is get all these variances together so we have a count of that item combined.
example of stock id's:
19/9418WX
19/9418WXDOWN
19/9418WXUP
19/9418X
19/9418XDOWN
19/9418XUP
19/9423WX
19/9423WXDOWN
19/9423WXUP
19/9423X
19/9423XDOWN
19/9423XUP
So, I would like the details of all of the variances of 19/9418 to be grouped, likewise 19/9423 and thousands more - so we can get a count, profit projections, etc
Fortunately, all of the stock follows xx/xxxx pattern i.e. first 7 chars
Any ideas?
Thanks