Vantage Sales $$

Yahoo Archive
1
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]
2
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]
3
Did you try the commission report? It is the only one that lets you
choose by Sales Rep.

Jim

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Lauren Hellings
Sent: Monday, April 21, 2008 9:21 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage Sales $$



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]






[Non-text portions of this message have been removed]
4
We actually do not use the sales commission report because it does not
calculate correctly. We are on 8.03.305k and the commission report pulls
sales $$ in by Invoice and we pay commissions on payments not invoices.
Plus, the commission report is not a Crystal report, so I cannot look at
the logic behind the scenes. I can do the calculation for sales by rep,
but it would be helpful if there was some sort of summarized sales field
to pull from.



Thank You,



Lauren L. Hellings
Systems Administrator
Ericson Manufacturing Co.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Jim Frice
Sent: Monday, April 21, 2008 10:39 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Vantage Sales $$



Did you try the commission report? It is the only one that lets you
choose by Sales Rep.

Jim

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Lauren Hellings
Sent: Monday, April 21, 2008 9:21 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Vantage Sales $$

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]

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
5
In Workforce Entry can't you just change the commissions from
Invoice to Payment
--- In vantage@yahoogroups.com, "Lauren Hellings" <LaurenH@...>
wrote:
>
> We actually do not use the sales commission report because it does
not
> calculate correctly. We are on 8.03.305k and the commission report
pulls
> sales $$ in by Invoice and we pay commissions on payments not
invoices.
> Plus, the commission report is not a Crystal report, so I cannot
look at
> the logic behind the scenes. I can do the calculation for sales by
rep,
> but it would be helpful if there was some sort of summarized sales
field
> to pull from.
>
>
>
> Thank You,
>
>
>
> Lauren L. Hellings
> Systems Administrator
> Ericson Manufacturing Co.
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of Jim Frice
> Sent: Monday, April 21, 2008 10:39 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Vantage Sales $$
>
>
>
> Did you try the commission report? It is the only one that lets you
> choose by Sales Rep.
>
> Jim
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> Of Lauren Hellings
> Sent: Monday, April 21, 2008 9:21 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vantage Sales $$
>
> 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]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
6
We already have Payment selected for each Sales Rep. The commission
report, as written is incorrect. Tech support gave us the SCR number,
but they do not have a release date for the fix yet.



Thank You,



Lauren L. Hellings
Systems Administrator
Ericson Manufacturing Co.





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Michael McWilliams
Sent: Monday, April 21, 2008 11:39 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Vantage Sales $$



In Workforce Entry can't you just change the commissions from
Invoice to Payment
--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Lauren Hellings" <LaurenH@...>
wrote:
>
> We actually do not use the sales commission report because it does
not
> calculate correctly. We are on 8.03.305k and the commission report
pulls
> sales $$ in by Invoice and we pay commissions on payments not
invoices.
> Plus, the commission report is not a Crystal report, so I cannot
look at
> the logic behind the scenes. I can do the calculation for sales by
rep,
> but it would be helpful if there was some sort of summarized sales
field
> to pull from.
>
>
>
> Thank You,
>
>
>
> Lauren L. Hellings
> Systems Administrator
> Ericson Manufacturing Co.
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of Jim Frice
> Sent: Monday, April 21, 2008 10:39 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Vantage Sales $$
>
>
>
> Did you try the commission report? It is the only one that lets you
> choose by Sales Rep.
>
> Jim
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%
40yahoogroups.com> ] On
> Behalf
> Of Lauren Hellings
> Sent: Monday, April 21, 2008 9:21 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Vantage Sales $$
>
> 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]
>
> [Non-text portions of this message have been removed]
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
7
has anyone written a Crystal report for the Sales Commissions? It is
a little tricky of a report because all the salesmen are in one field
so if you spit them out, you can't really group them and sum their
commission dollars. If someone has written something, i would be
interested in seeing it.


--- In vantage@yahoogroups.com, "Lauren Hellings" <LaurenH@...> wrote:
>
> We already have Payment selected for each Sales Rep. The commission
> report, as written is incorrect. Tech support gave us the SCR number,
> but they do not have a release date for the fix yet.
>
>
>
> Thank You,
>
>
>
> Lauren L. Hellings
> Systems Administrator
> Ericson Manufacturing Co.
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of Michael McWilliams
> Sent: Monday, April 21, 2008 11:39 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Vantage Sales $$
>
>
>
> In Workforce Entry can't you just change the commissions from
> Invoice to Payment
> --- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
> "Lauren Hellings" <LaurenH@>
> wrote:
> >
> > We actually do not use the sales commission report because it does
> not
> > calculate correctly. We are on 8.03.305k and the commission report
> pulls
> > sales $$ in by Invoice and we pay commissions on payments not
> invoices.
> > Plus, the commission report is not a Crystal report, so I cannot
> look at
> > the logic behind the scenes. I can do the calculation for sales by
> rep,
> > but it would be helpful if there was some sort of summarized sales
> field
> > to pull from.
> >
> >
> >
> > Thank You,
> >
> >
> >
> > Lauren L. Hellings
> > Systems Administrator
> > Ericson Manufacturing Co.
> >
> >
> >
> >
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf
> > Of Jim Frice
> > Sent: Monday, April 21, 2008 10:39 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> > Subject: RE: [Vantage] Vantage Sales $$
> >
> >
> >
> > Did you try the commission report? It is the only one that lets you
> > choose by Sales Rep.
> >
> > Jim
> >
> > ________________________________
> >
> > From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > [mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%
> 40yahoogroups.com> ] On
> > Behalf
> > Of Lauren Hellings
> > Sent: Monday, April 21, 2008 9:21 AM
> > To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> <mailto:vantage%40yahoogroups.com>
> > Subject: [Vantage] Vantage Sales $$
> >
> > 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]
> >
> > [Non-text portions of this message have been removed]
> >
> >
> >
> >
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>