Commission Report needed before Invoice wihtin Sales Order

system · October 28, 2006, 12:55pm

Although you may be able to do this in Crystal with a SQL Expressions.
It is easier to do this with SQL views written off your SQL or progress
database, using the data administration tools for the later.

You then write reports off the back of those views.

Gary Parfrey

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of processbarron
Sent: 27 October 2006 15:01
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Commission Report needed before Invoice wihtin
Sales Order

Within Vantage 8.0 and crystal report, I have not seen a way to split
an array so that a SQL can be done. Would this be done within the
crystal report?

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"Gary Parfrey" <garyp@...> wrote:

>
> Write it as part of the sales order acknowledgement in Crystal using
> ODBC and an SQL view do split out the Sales Rep array
>
>
>
> Gary Parfrey
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>

[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf

> Of processbarron
> Sent: 26 October 2006 15:19
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Commission Report needed before Invoice wihtin

Sales

> Order
>
>
>
> When printing the Sales Order, I need a second document that
> will print a Commission Report for that Sales Order. I know
> there is a commission report within the system but I need this
> report because we send notices out to the Reps concerning their
> commission.
>
> I have created an enhancement request document # 21687MPS with

Epicor.

>
> I would like to know anyone out there that would need this document

for

> Version 8.00.809. I would presume that it would work with 8.803

when

> it comes out fully.
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If

you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the author's prior permission. We have taken precautions to
minimize the risk of transmitting software viruses, but we advise you
to carry out your own virus checks on any attachment to this message.
We cannot accept liability for any loss or damage caused by software
viruses.

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

This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

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

system · June 28, 2006, 3:20pm

The way our business works... we have to send Commission allocation
sheets for each Sales Order or Job. Within Vantage, we havent been
able to do that. Is there anyone out there that may have developed or
is in development that could possibly help me with this issue.

Scope
-Get a commission report from the Sales Order by line item.
-All ready tried to do a subreport but commission is done by one
column within the table. Cannot get a clean SQL command and cant use
group headers because cannot have a subreport within a subreport.

Any suggestions will be greatful...

Kevin Berry

system · June 28, 2006, 4:18pm

Kevin,

What version of vantage are you running? I have a Report Builder report
that I modeled after one that Todd Caughey sent me that may work for
you. If you are running 6.1 or later and have report builder I can send
to you off list.

Chris Crosta

_____

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of processbarron
Sent: Wednesday, June 28, 2006 12:16 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Commission Report needed before Invoice wihtin Sales
Order

The way our business works... we have to send Commission allocation
sheets for each Sales Order or Job. Within Vantage, we havent been
able to do that. Is there anyone out there that may have developed or
is in development that could possibly help me with this issue.

Scope
-Get a commission report from the Sales Order by line item.
-All ready tried to do a subreport but commission is done by one
column within the table. Cannot get a clean SQL command and cant use
group headers because cannot have a subreport within a subreport.

Any suggestions will be greatful...

Kevin Berry

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

system · October 26, 2006, 10:22am

When printing the Sales Order, I need a second document that
will print a Commission Report for that Sales Order. I know
there is a commission report within the system but I need this
report because we send notices out to the Reps concerning their
commission.

I have created an enhancement request document # 21687MPS with Epicor.

I would like to know anyone out there that would need this document for
Version 8.00.809. I would presume that it would work with 8.803 when
it comes out fully.

system · October 26, 2006, 4:02pm

Write it as part of the sales order acknowledgement in Crystal using
ODBC and an SQL view do split out the Sales Rep array

Gary Parfrey

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of processbarron
Sent: 26 October 2006 15:19
To: vantage@yahoogroups.com
Subject: [Vantage] Commission Report needed before Invoice wihtin Sales
Order

When printing the Sales Order, I need a second document that
will print a Commission Report for that Sales Order. I know
there is a commission report within the system but I need this
report because we send notices out to the Reps concerning their
commission.

I have created an enhancement request document # 21687MPS with Epicor.

I would like to know anyone out there that would need this document for
Version 8.00.809. I would presume that it would work with 8.803 when
it comes out fully.

This e-mail is for the use of the intended recipient(s) only. If you have received this e-mail in error, please notify the sender immediately and then delete it. If you are not the intended recipient, you must not use, disclose or distribute this e-mail without the author's prior permission. We have taken precautions to minimize the risk of transmitting software viruses, but we advise you to carry out your own virus checks on any attachment to this message. We cannot accept liability for any loss or damage caused by software viruses.

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

system · October 26, 2006, 4:25pm

Gary,

How do you split the array for an SQL view? Would this work on the
scheduling tables? Can Corvu read SQL Views? I presume so but never
tried...

Thanks

--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Write it as part of the sales order acknowledgement in Crystal
using
> ODBC and an SQL view do split out the Sales Rep array
>
>
>
> Gary Parfrey
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of processbarron
> Sent: 26 October 2006 15:19
> To: vantage@yahoogroups.com
> Subject: [Vantage] Commission Report needed before Invoice wihtin
Sales
> Order
>
>
>
> When printing the Sales Order, I need a second document that
> will print a Commission Report for that Sales Order. I know
> there is a commission report within the system but I need this
> report because we send notices out to the Reps concerning their
> commission.
>
> I have created an enhancement request document # 21687MPS with
Epicor.
>
> I would like to know anyone out there that would need this
document for
> Version 8.00.809. I would presume that it would work with 8.803
when
> it comes out fully.
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the author's prior permission. We have taken precautions to
minimize the risk of transmitting software viruses, but we advise
you to carry out your own virus checks on any attachment to this
message. We cannot accept liability for any loss or damage caused by
software viruses.
>
>
>
> [Non-text portions of this message have been removed]
>

system · October 27, 2006, 10:05am

Within Vantage 8.0 and crystal report, I have not seen a way to split
an array so that a SQL can be done. Would this be done within the
crystal report?

--- In vantage@yahoogroups.com, "Gary Parfrey" <garyp@...> wrote:
>
> Write it as part of the sales order acknowledgement in Crystal using
> ODBC and an SQL view do split out the Sales Rep array
>
>
>
> Gary Parfrey
>
>
>
> ________________________________
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
> Of processbarron
> Sent: 26 October 2006 15:19
> To: vantage@yahoogroups.com
> Subject: [Vantage] Commission Report needed before Invoice wihtin
Sales
> Order
>
>
>
> When printing the Sales Order, I need a second document that
> will print a Commission Report for that Sales Order. I know
> there is a commission report within the system but I need this
> report because we send notices out to the Reps concerning their
> commission.
>
> I have created an enhancement request document # 21687MPS with
Epicor.
>
> I would like to know anyone out there that would need this document
for
> Version 8.00.809. I would presume that it would work with 8.803
when
> it comes out fully.
>
>
>
>
>
> This e-mail is for the use of the intended recipient(s) only. If
you have received this e-mail in error, please notify the sender
immediately and then delete it. If you are not the intended
recipient, you must not use, disclose or distribute this e-mail
without the author's prior permission. We have taken precautions to
minimize the risk of transmitting software viruses, but we advise you
to carry out your own virus checks on any attachment to this message.
We cannot accept liability for any loss or damage caused by software
viruses.
>
>
>
> [Non-text portions of this message have been removed]
>