I have made the join and the filter in the previous message, but now the report
runs forever without returning anything. Any help would be greatly appreciated,
as I am slowly running out of hair to pull out.

>Thanks
>Marvin R. Myers
>Computer Systems Engineer
>marvin@...

At 12:36 PM 08/24/2000 -0500, you wrote:

>You will need to do a join between the InvcDtl and InvcHead. Then you can
>use the filter below. Invoice Header is not one of the tables in the report
>as it currently stands. I made the change to verify that records weren't
>going to be duplicated and it worked.
>
> > -----Original Message-----
> > From: Eric Tolliver [mailto:e.tolliver@...]
> > Sent: Thursday, August 24, 2000 11:09 AM
> > To: vantage@egroups.com
> > Subject: RE: [Vantage][Report Builder]
> >
> >
> > If the report has the Invoice fields you can use "Posted" Yes/No.
> >
> > Eric Tolliver
> > IT\MIS
> > Continental Industries Inc.
> > 5456 E. Mcdowell Rd.
> > Mesa, Az 85215
> > http://ciirelays.com/
> > mailto:e.tolliver@...
> >
> > -----Original Message-----
> >
> > I am in need of a little help modifying the Sales By State report that was
> > posted to the list.
> > My controller says that the report needs to only include those
> > amounts that
> > were actually
> > invoiced. I can't seem to figure out a proper filter to make this happen.
> > Any help would be
> > greatly appreciated.
> >
> > Thanks
> > Marvin R. Myers
> > Computer Systems Engineer
> > marvin@...
>

I am in need of a little help modifying the Sales By State report that was
posted to the list.
My controller says that the report needs to only include those amounts that
were actually
invoiced. I can't seem to figure out a proper filter to make this happen.
Any help would be
greatly appreciated.

Thanks
Marvin R. Myers
Computer Systems Engineer
marvin@...

If the report has the Invoice fields you can use "Posted" Yes/No.

Eric Tolliver
IT\MIS
Continental Industries Inc.
5456 E. Mcdowell Rd.
Mesa, Az 85215
http://ciirelays.com/
mailto:e.tolliver@...

-----Original Message-----

I am in need of a little help modifying the Sales By State report that was
posted to the list.
My controller says that the report needs to only include those amounts that
were actually
invoiced. I can't seem to figure out a proper filter to make this happen.
Any help would be
greatly appreciated.

Thanks
Marvin R. Myers
Computer Systems Engineer
marvin@...

Marvin, do you mean the actual sales amount versus the total invoice amount
which includes sales tax, freight, and any other misc. charges?
Jim Stetter
Snow Filtration
-----Original Message-----
From: Marvin Myers [mailto:marvin@...]
Sent: Thursday, August 24, 2000 11:58 AM
To: vantage@egroups.com
Subject: [Vantage][Report Builder]

I am in need of a little help modifying the Sales By State report that was
posted to the list.
My controller says that the report needs to only include those amounts
that
were actually
invoiced. I can't seem to figure out a proper filter to make this happen.
Any help would be
greatly appreciated.

Thanks
Marvin R. Myers
Computer Systems Engineer
marvin@...

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

What we are looking for is the actual amount that was invoiced, not the
total amount
of the sales order.

Thanks
Marvin R. Myers
Computer Systems Engineer
marvin@...

At 12:31 PM 08/24/2000 -0400, you wrote:

>Marvin, do you mean the actual sales amount versus the total invoice amount
>which includes sales tax, freight, and any other misc. charges?
>Jim Stetter
>Snow Filtration
> -----Original Message-----
> From: Marvin Myers [mailto:marvin@...]
> Sent: Thursday, August 24, 2000 11:58 AM
> To: vantage@egroups.com
> Subject: [Vantage][Report Builder]
>
>
> I am in need of a little help modifying the Sales By State report that was
> posted to the list.
> My controller says that the report needs to only include those amounts
>that
> were actually
> invoiced. I can't seem to figure out a proper filter to make this happen.
> Any help would be
> greatly appreciated.
>
> Thanks
> Marvin R. Myers
> Computer Systems Engineer
> marvin@...
>
>
>
>
>

You will need to do a join between the InvcDtl and InvcHead. Then you can
use the filter below. Invoice Header is not one of the tables in the report
as it currently stands. I made the change to verify that records weren't
going to be duplicated and it worked.

> -----Original Message-----
> From: Eric Tolliver [mailto:e.tolliver@...]
> Sent: Thursday, August 24, 2000 11:09 AM
> To: vantage@egroups.com
> Subject: RE: [Vantage][Report Builder]
>
>
> If the report has the Invoice fields you can use "Posted" Yes/No.
>
> Eric Tolliver
> IT\MIS
> Continental Industries Inc.
> 5456 E. Mcdowell Rd.
> Mesa, Az 85215
> http://ciirelays.com/
> mailto:e.tolliver@...
>
> -----Original Message-----
>
> I am in need of a little help modifying the Sales By State report that was
> posted to the list.
> My controller says that the report needs to only include those
> amounts that
> were actually
> invoiced. I can't seem to figure out a proper filter to make this happen.
> Any help would be
> greatly appreciated.
>
> Thanks
> Marvin R. Myers
> Computer Systems Engineer
> marvin@...