Skip to Content
0
Former Member
May 29, 2008 at 05:06 AM

combining similar id numbers

16 Views

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