Hi Lauren,
You can use Crystal Reports to extract the Reps from the RepList field.
Here is a sample to get the first Rep code in the list:
stringvar array Reps;
numbervar NumReps;
stringvar RepCode;
Reps := split({InvcHead.SalesRepList},"~");
if ubound(Reps) > 0 then
Rep := Reps[1]
else
Rep := ""
;
Hth,
Linda
Original message:
Is there a field anywhere in Vantage that gives Sales $$ by Sales Rep? I
know there is a field on the Customer Tracker showing this information
by customer, but it is not reportable. I cannot get to this field
through Crystal Reports. I am trying not to have to pull all shipments
and calculate.
Anyone have any ideas?
Thank You,
Lauren L. Hellings
Systems Administrator
Ericson Manufacturing Co.
[Non-text portions of this message have been removed]
You can use Crystal Reports to extract the Reps from the RepList field.
Here is a sample to get the first Rep code in the list:
stringvar array Reps;
numbervar NumReps;
stringvar RepCode;
Reps := split({InvcHead.SalesRepList},"~");
if ubound(Reps) > 0 then
Rep := Reps[1]
else
Rep := ""
;
Hth,
Linda
Original message:
Is there a field anywhere in Vantage that gives Sales $$ by Sales Rep? I
know there is a field on the Customer Tracker showing this information
by customer, but it is not reportable. I cannot get to this field
through Crystal Reports. I am trying not to have to pull all shipments
and calculate.
Anyone have any ideas?
Thank You,
Lauren L. Hellings
Systems Administrator
Ericson Manufacturing Co.
[Non-text portions of this message have been removed]