BAQ: Parsing the Sales Rep List from Sales Order Header Table

Vista/Vantage 8
1

Running Vantage 8 and trying to extract the Sales Rep List into however many sales reps are there into individual reps there may be on the sales order (up to a max of 5).

Has anyone ever done this as a calculation in a BAQ before?

A little help please; I’m stumped.

Thank you,
Jeff Henslee
M-B Companies Inc.

2

You mean to say that, Display all reps of all orders where 1 order may have 1 or more reps ? right ?

3

Yes it is possible.

Jeffrey C Henslee
Information Technology / ERP Manager
M-B Companies Inc.
1615 Wisconsin Avenue
New Holstein, WI 53061
920-522-2684

4

Try something like Entry(1,OrderHed.SalesRepList,’~’). That should give you the first sales rep. Create a calculated field for each entry. You’ll have to extract the whole sales rep list then do the join in crystal.

5

Thanks – I’ll give it a shot.

Much appreciated.

6

I tried your function but could not get it to parse correctly all the sales rep from the list.

7

Did you ever get this to work in a BAQ to parse the rep list?

8

We use the command to parse the OrderHed.SalesRepList

[Ice].entry(1,OrderHed.SalesRepList,'~')....
9

And if you want to see the names of the reps the table join should be like this.

‘~’ + Orderhed.SalesRepList + ‘~’ Like ‘~’ + SalesRep.SalesRepCode + ‘~’

image
image888×129 5.1 KB