# Sales by State Report **Category:** [Yahoo Archive](https://www.epiusers.help/c/yahoo-archive/9) **Created:** 2001-02-01 13:04 UTC **Views:** 437 **Replies:** 6 **URL:** https://www.epiusers.help/t/sales-by-state-report/1950 --- ## Post #1 by @system
I've just created an Aged Debtors report which duplicated the total
invoice balance for each line on the invoice.
I solved the problem by removing the link to the Invoice Detail table.
Maybe you could try this on Sales as well
HTH
Sophie

> -----Original Message-----
> From: Giallombardo, Ed [SMTP:egiallombardo@...]
> Sent: 01 February 2001 17:06
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Sales by State Report
>
> I've had similar problems with other reports totaling more than they
> should.
> I believe it has something to do with the InvoiceDtl adding more than
> once.
> I've fixed this problem in similar reports by messing around with the
> sort
> and group settings.
> -----Original Message-----
> From: kend@... [mailto:kend@...]
> Sent: Thursday, February 01, 2001 7:44 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State Report
>
>
>
> I have been trying to get a sales by state report. I tried using the
> one on the groups, but I'm not getting any data. I tried to create
> one from scratch, but I get very weird data. I'm getting about 10
> times the sales than we really have. I can send somebody the report
> I have been working on if you would like to take a look at it.Â
> Please somebody help me out.
>
> Thanks
>
> Ken
>
>
>
> Yahoo! Groups Sponsor    Â
>
>
>
> <
> <http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1
> 700007>
> 183:N/A=567189/R=1/* <http://www.domains.com>>
> <
> <http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1
> 700007>
> 183:N/A=567189/R=2/* <http://www.domains.com>> Â Â Â Â Â
>
> www.Â
>
>
> <
> <http://us.adserver.yahoo.com/l?M=176325.1307935.2900315.1248727/D=egr
> oupmai>
> l/S=1700007183:N/A=567189/rand=573197873> Â Â Â Â Â
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
>
> <http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1
> 700007183:N/A=572092/R=1/*http://www.domains.com>
> <http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1
> 700007183:N/A=572092/R=2/*http://www.domains.com>
> www. .comÂ
>
> <http://us.adserver.yahoo.com/l?M=176325.1307935.2900315.1248727/D=egr
> oupmail/S=1700007183:N/A=572092/rand=971493865>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
>
--- ## Post #2 by @system
I downloaded the sales by state report, and I'm having problems
getting it to work. I can get the report to run, but I get all zeros
for everything. Can somebody please tell me what I need to do?

Ken Devorak
--- ## Post #3 by @system
I'm having problems getting the sales by state report to work. I
downloaded it off the download section. I can get the report to
work, but I get all zeros for everthing. Can sombody please help me
out here?

Thank You

Ken Devorak
--- ## Post #4 by @system
Check the filters that the report is using, and make sure they work for you
company/ your data.
--- ## Post #5 by @system
Ken,

What version of Vantage are you using? Verify that the filter is
applicable.

Regards,
Darren Mann
Miller Products Co.

> -----Original Message-----
> From: kend@... [mailto:kend@...]
> Sent: Monday, January 15, 2001 10:50 AM
> To: vantage@egroups.com
> Subject: [Vantage] Sales by State Report
>
>
> I'm having problems getting the sales by state report to work. I
> downloaded it off the download section. I can get the report to
> work, but I get all zeros for everthing. Can sombody please help me
> out here?
>
> Thank You
>
> Ken Devorak
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com
>
>
>
>
--- ## Post #6 by @system
I have been trying to get a sales by state report. I tried using the
one on the groups, but I'm not getting any data. I tried to create
one from scratch, but I get very weird data. I'm getting about 10
times the sales than we really have. I can send somebody the report
I have been working on if you would like to take a look at it.
Please somebody help me out.

Thanks

Ken
--- ## Post #7 by @system
I've had similar problems with other reports totaling more than they should.
I believe it has something to do with the InvoiceDtl adding more than once.
I've fixed this problem in similar reports by messing around with the sort
and group settings.
-----Original Message-----
From: kend@... [mailto:kend@...]
Sent: Thursday, February 01, 2001 7:44 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales by State Report



I have been trying to get a sales by state report. I tried using the
one on the groups, but I'm not getting any data. I tried to create
one from scratch, but I get very weird data. I'm getting about 10
times the sales than we really have. I can send somebody the report
I have been working on if you would like to take a look at it.
Please somebody help me out.

Thanks

Ken



Yahoo! Groups Sponsor



<http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1700007
183:N/A=567189/R=1/*http://www.domains.com>
<http://rd.yahoo.com/M=176325.1307935.2900315.1248727/D=egroupmail/S=1700007
183:N/A=567189/R=2/*http://www.domains.com>

www.


<http://us.adserver.yahoo.com/l?M=176325.1307935.2900315.1248727/D=egroupmai
l/S=1700007183:N/A=567189/rand=573197873>

To unsubscribe from this group, send an email to:
vantage-unsubscribe@egroups.com






[Non-text portions of this message have been removed]
--- **Canonical:** https://www.epiusers.help/t/sales-by-state-report/1950 **Original content:** https://www.epiusers.help/t/sales-by-state-report/1950