Sales by State

Kara,

The credit memos that are created from cash receipts posting of overpayments
by customers do not affect your G/L sales. They will credit your A/R
account. If you have some of these, your rb report will be less than your
income statements. If your report is not joining to InvcHead table, you can
filter at the Invcdtl table. The part number will be blank and the
description starts with "Unapplied".

Jim Stetter
-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 2:17 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Sales by State


Jim,
I am using the total sales number on my income statement. This consists
of
sales from 2 locations less sales allowances & discounts from each
location.
All credit memos should be reflected in the regular sales accounts. My RB
report is less than my income statement. I will try to look at misc
charges
alone and see if that's my difference.

Thanks,
Kara

> -----Original Message-----
> From: Jim Frice [SMTP:Jim.Frice@...]
> Sent: Tuesday, November 20, 2001 10:45 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> Kara,
>
> Looking at the report downloaded from the site it uses the extended
price
> which is calculated as the (ShipQty/PricePer) * UnitPrice. If you have
any
> tax or misc. charges they will not be in the price or accounted for on
the
> report. What report are you using to try and match to? G/L Distribution?
> Sales Analysis? If the report builder report is less you may want to
look
> at
> your misc. charges and taxes for the month and add them to the report
> builder report total and see if that is your difference. Hope that
helps.
>
> > -----Original Message-----
> > From: kstoller@...
> > [mailto:kstoller@...]
> > Sent: Tuesday, November 20, 2001 8:49 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Sales by State
> >
> >
> > I've created a Sales by State report using InvcHead as my master
> > table and Customer as a related table. The total sales on the report
> > never equal our actual sales, they are always less. I did month by
> > month comparisons and found that I was off each month. I tried
> > downloading the Sales by State report of this site, and it gave me
> > the same results. Does anyone know what I'm missing?
> >
> > Kara Stoller
> > Accouting Manager
> > CNC Metal Products, Inc.
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to
> > enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
> > <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > <http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
> > <http://groups.yahoo.com/group/vantage/links>
> >
> > Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
> >
> >
> >
>
>
>
> Yahoo! Groups Sponsor
>
>
<http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
>
7183:HM/A=812075/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1783498000
> 57000>
>
>
<http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812075/rand=699577564>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder
and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.

Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
I downloaded the Sales by state report, and I seem to be about 1
million over. Can sombody help explain what the ext price is and if
I might be getting data from the wrong field.

Ken Devorak
Ken,

The extended price price does not reflect discounts given to customers.

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

-----Original Message-----
From: kend@... [mailto:kend@...]
Sent: Friday, February 16, 2001 6:48 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales by State

I downloaded the Sales by state report, and I seem to be about 1
million over. Can sombody help explain what the ext price is and if
I might be getting data from the wrong field.

Ken Devorak
I've created a Sales by State report using InvcHead as my master
table and Customer as a related table. The total sales on the report
never equal our actual sales, they are always less. I did month by
month comparisons and found that I was off each month. I tried
downloading the Sales by State report of this site, and it gave me
the same results. Does anyone know what I'm missing?

Kara Stoller
Accouting Manager
CNC Metal Products, Inc.
Do you give discounts? If so the calculation for selling price may need to
reflect this. See which field is being used to calculate the sales $ and
that should tell you which figure is being used.

Regards,

Darren Mann
IT Manager
Miller Products Co.

-----Original Message-----
From: kstoller@...
[mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales by State


I've created a Sales by State report using InvcHead as my master
table and Customer as a related table. The total sales on the report
never equal our actual sales, they are always less. I did month by
month comparisons and found that I was off each month. I tried
downloading the Sales by State report of this site, and it gave me
the same results. Does anyone know what I'm missing?

Kara Stoller
Accouting Manager
CNC Metal Products, Inc.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Darren,
Thanks for your suggestion. We do give discounts, but the number is small
in comparison to the number I am off by. I am using the field
InvcHead.InvoiceAmt to get my number. I probably am not accounting for
discounts in my current report and should be, but I think there is still
something else wrong.

Kara
> -----Original Message-----
> From: Darren Mann [SMTP:dmann@...]
> Sent: Tuesday, November 20, 2001 10:05 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> Do you give discounts? If so the calculation for selling price may need
> to
> reflect this. See which field is being used to calculate the sales $ and
> that should tell you which figure is being used.
>
> Regards,
>
> Darren Mann
> IT Manager
> Miller Products Co.
>
> -----Original Message-----
> From: kstoller@...
> [mailto:kstoller@...]
> Sent: Tuesday, November 20, 2001 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State
>
>
> I've created a Sales by State report using InvcHead as my master
> table and Customer as a related table. The total sales on the report
> never equal our actual sales, they are always less. I did month by
> month comparisons and found that I was off each month. I tried
> downloading the Sales by State report of this site, and it gave me
> the same results. Does anyone know what I'm missing?
>
> Kara Stoller
> Accouting Manager
> CNC Metal Products, Inc.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1533402700
> 03000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812074/rand=115456271>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
Is you're total sales based on orders or invoices? Our orders are often made
months before the jobs get invoiced so we have Booked Sales and Invoiced
Sales Reports for every month. Our booked sales is always significantly
higher than our invoiced sales.


- Ed

-----Original Message-----
From: kstoller@... [mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales by State


I've created a Sales by State report using InvcHead as my master
table and Customer as a related table. The total sales on the report
never equal our actual sales, they are always less. I did month by
month comparisons and found that I was off each month. I tried
downloading the Sales by State report of this site, and it gave me
the same results. Does anyone know what I'm missing?

Kara Stoller
Accouting Manager
CNC Metal Products, Inc.



Yahoo! Groups Sponsor

<http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=17050071
83:HM/A=812075/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b17834980005700
0>

<http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupmai
l/S=1705007183:HM/A=812075/rand=518306425>

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<http://groups.yahoo.com/group/vantage/messages>
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
Ed,
Our total sales are based on invoices not orders.

Thanks,
Kara

> -----Original Message-----
> From: Giallombardo, Ed [SMTP:egiallombardo@...]
> Sent: Tuesday, November 20, 2001 10:30 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Sales by State
>
> Is you're total sales based on orders or invoices? Our orders are often
> made
> months before the jobs get invoiced so we have Booked Sales and Invoiced
> Sales Reports for every month. Our booked sales is always significantly
> higher than our invoiced sales.
>
>
> - Ed
>
> -----Original Message-----
> From: kstoller@... [mailto:kstoller@...]
> Sent: Tuesday, November 20, 2001 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State
>
>
> I've created a Sales by State report using InvcHead as my master
> table and Customer as a related table. The total sales on the report
> never equal our actual sales, they are always less. I did month by
> month comparisons and found that I was off each month. I tried
> downloading the Sales by State report of this site, and it gave me
> the same results. Does anyone know what I'm missing?
>
> Kara Stoller
> Accouting Manager
> CNC Metal Products, Inc.
>
>
>
> Yahoo! Groups Sponsor
>
> <
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 71>
> 83:HM/A=812075/R=0/*
> <http://www.verisign.com/cgi-bin/go.cgi?a=b17834980005700>
> 0>
>
> <
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ai>
> l/S=1705007183:HM/A=812075/rand=518306425>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> < <http://groups.yahoo.com/group/vantage/files/.>>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> < <http://groups.yahoo.com/group/vantage/messages>>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
> < <http://groups.yahoo.com/group/vantage/links>>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> < <http://docs.yahoo.com/info/terms/>> .
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812075/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1783498000
> 57000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812075/rand=479977161>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
Kara,

Looking at the report downloaded from the site it uses the extended price
which is calculated as the (ShipQty/PricePer) * UnitPrice. If you have any
tax or misc. charges they will not be in the price or accounted for on the
report. What report are you using to try and match to? G/L Distribution?
Sales Analysis? If the report builder report is less you may want to look at
your misc. charges and taxes for the month and add them to the report
builder report total and see if that is your difference. Hope that helps.

> -----Original Message-----
> From: kstoller@...
> [mailto:kstoller@...]
> Sent: Tuesday, November 20, 2001 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State
>
>
> I've created a Sales by State report using InvcHead as my master
> table and Customer as a related table. The total sales on the report
> never equal our actual sales, they are always less. I did month by
> month comparisons and found that I was off each month. I tried
> downloading the Sales by State report of this site, and it gave me
> the same results. Does anyone know what I'm missing?
>
> Kara Stoller
> Accouting Manager
> CNC Metal Products, Inc.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> must have already linked your email address to a yahoo id to
> enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report
> Builder and Crystal Reports and other 'goodies', please goto:
> http://groups.yahoo.com/group/vantage/files/.
> (2) To search through old msg's goto:
> http://groups.yahoo.com/group/vantage/messages
> (3) To view links to Vendors that provide Vantage services goto:
> http://groups.yahoo.com/group/vantage/links
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
Kara,
Credit Memo's will also distort the Sales Picture from the custom reports because they are not readily available on the Invoice Table. Vantage takes CM's into account when calculating Sales.

Troy Funte
(the non-accountant who has to write Accounting reports)
Liberty Electronics
----- Original Message -----
From: kstoller@...
To: vantage@yahoogroups.com
Sent: Tuesday, November 20, 2001 9:49 AM
Subject: [Vantage] Sales by State


I've created a Sales by State report using InvcHead as my master
table and Customer as a related table. The total sales on the report
never equal our actual sales, they are always less. I did month by
month comparisons and found that I was off each month. I tried
downloading the Sales by State report of this site, and it gave me
the same results. Does anyone know what I'm missing?

Kara Stoller
Accouting Manager
CNC Metal Products, Inc.


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
If you are using InvcHead.InvoiceAmt it will include any misc charges, for
example shipping charges, as well as discounts. Credit memos would also be
reflected with negative values. Does this help?

Darren


-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 9:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Sales by State


Darren,
Thanks for your suggestion. We do give discounts, but the number is small
in comparison to the number I am off by. I am using the field
InvcHead.InvoiceAmt to get my number. I probably am not accounting for
discounts in my current report and should be, but I think there is still
something else wrong.

Kara
> -----Original Message-----
> From: Darren Mann [SMTP:dmann@...]
> Sent: Tuesday, November 20, 2001 10:05 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> Do you give discounts? If so the calculation for selling price may need
> to
> reflect this. See which field is being used to calculate the sales $ and
> that should tell you which figure is being used.
>
> Regards,
>
> Darren Mann
> IT Manager
> Miller Products Co.
>
> -----Original Message-----
> From: kstoller@...
> [mailto:kstoller@...]
> Sent: Tuesday, November 20, 2001 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State
>
>
> I've created a Sales by State report using InvcHead as my master
> table and Customer as a related table. The total sales on the report
> never equal our actual sales, they are always less. I did month by
> month comparisons and found that I was off each month. I tried
> downloading the Sales by State report of this site, and it gave me
> the same results. Does anyone know what I'm missing?
>
> Kara Stoller
> Accouting Manager
> CNC Metal Products, Inc.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1533402700
> 03000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812074/rand=115456271>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Darren,
That is one of the first things we questioned, whether or not the report was
including credit memos and misc invoices. It is and I want it to because
the general ledger accounts that I'm comparing to also reflect those
amounts.

Thanks,
Kara

> -----Original Message-----
> From: Darren Mann [SMTP:dmann@...]
> Sent: Tuesday, November 20, 2001 10:42 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> If you are using InvcHead.InvoiceAmt it will include any misc charges, for
> example shipping charges, as well as discounts. Credit memos would also
> be
> reflected with negative values. Does this help?
>
> Darren
>
>
> -----Original Message-----
> From: Kara Stoller [mailto:kstoller@...]
> Sent: Tuesday, November 20, 2001 9:17 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Sales by State
>
>
> Darren,
> Thanks for your suggestion. We do give discounts, but the number is small
> in comparison to the number I am off by. I am using the field
> InvcHead.InvoiceAmt to get my number. I probably am not accounting for
> discounts in my current report and should be, but I think there is still
> something else wrong.
>
> Kara
> > -----Original Message-----
> > From: Darren Mann [SMTP:dmann@...]
> > Sent: Tuesday, November 20, 2001 10:05 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Sales by State
> >
> > Do you give discounts? If so the calculation for selling price may need
> > to
> > reflect this. See which field is being used to calculate the sales $
> and
> > that should tell you which figure is being used.
> >
> > Regards,
> >
> > Darren Mann
> > IT Manager
> > Miller Products Co.
> >
> > -----Original Message-----
> > From: kstoller@...
> > [mailto:kstoller@...]
> > Sent: Tuesday, November 20, 2001 8:49 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Sales by State
> >
> >
> > I've created a Sales by State report using InvcHead as my master
> > table and Customer as a related table. The total sales on the report
> > never equal our actual sales, they are always less. I did month by
> > month comparisons and found that I was off each month. I tried
> > downloading the Sales by State report of this site, and it gave me
> > the same results. Does anyone know what I'm missing?
> >
> > Kara Stoller
> > Accouting Manager
> > CNC Metal Products, Inc.
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have
> > already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and
> > Crystal Reports and other 'goodies', please goto:
> > < <http://groups.yahoo.com/group/vantage/files/.>>
> > (2) To search through old msg's goto:
> > < <http://groups.yahoo.com/group/vantage/messages>>
> > (3) To view links to Vendors that provide Vantage services goto:
> > < <http://groups.yahoo.com/group/vantage/links>>
> >
> > Your use of Yahoo! Groups is subject to
> > < <http://docs.yahoo.com/info/terms/>>
> >
> >
> >
> > Yahoo! Groups Sponsor
> >
> > <
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> >
> > 7183:HM/A=812074/R=0/*
> <http://www.verisign.com/cgi-bin/go.cgi?a=b1533402700>
> > 03000>
> >
> > <
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> >
> > ail/S=1705007183:HM/A=812074/rand=115456271>
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> > have already linked your email address to a yahoo id to enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report Builder
> and
> > Crystal Reports and other 'goodies', please goto:
> > < <http://groups.yahoo.com/group/vantage/files/.>>
> > (2) To search through old msg's goto:
> > < <http://groups.yahoo.com/group/vantage/messages>>
> > (3) To view links to Vendors that provide Vantage services goto:
> > < <http://groups.yahoo.com/group/vantage/links>>
> >
> > Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> > < <http://docs.yahoo.com/info/terms/>>.
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812075/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1783498000
> 57000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812075/rand=836054059>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
Chris,
I'll check this out- this may be my problem.

Thanks,
Kara

> -----Original Message-----
> From: Chris Hansen [SMTP:chansen@...]
> Sent: Tuesday, November 20, 2001 10:13 AM
> To: 'vantage@yahoogroups.com'
> Subject: FW: [Vantage] Sales by State
>
> Kara,
> In our accounting department, we occasionally have to make sales
> corrections with a journal entry. These corrections then affect the sales
>
> total, but will not come through using the InvcHead table on a report
> builder report. Because of this, many of the report builder sales reports
>
> are close, but never tie exactly to our sales on the financial statements.
>
> Chris Hansen
> Herker Industries, Inc.
>
> -----Original Message-----
> From: kstoller@...
> [SMTP:kstoller@...]
> Sent: Tuesday, November 20, 2001 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State
>
> I've created a Sales by State report using InvcHead as my master
> table and Customer as a related table. The total sales on the report
> never equal our actual sales, they are always less. I did month by
> month comparisons and found that I was off each month. I tried
> downloading the Sales by State report of this site, and it gave me
> the same results. Does anyone know what I'm missing?
>
> Kara Stoller
> Accouting Manager
> CNC Metal Products, Inc.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
>
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1533402700
> 03000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812074/rand=117908798>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
Kara:

Misc. Charges (as opposed to Misc. Invoices) are probably not included in
your RB report. When I went through a similar exercise, I ended up doing a
report for just the Misc. Charges.

If you typically have a lot of expedite, tooling or engineering charges,
this could be contributing to your discrepancy.

Lydia
You may not be getting the shipping charges included on the invoice with the
sales by state... Just a thought

-----Original Message-----
From: kstoller@...
[mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 8:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales by State


I've created a Sales by State report using InvcHead as my master
table and Customer as a related table. The total sales on the report
never equal our actual sales, they are always less. I did month by
month comparisons and found that I was off each month. I tried
downloading the Sales by State report of this site, and it gave me
the same results. Does anyone know what I'm missing?

Kara Stoller
Accouting Manager
CNC Metal Products, Inc.



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Are you including misc charges, shipping charges, etc...

Patrick

-----Original Message-----
From: Kara Stoller [mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 9:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Sales by State


Darren,
Thanks for your suggestion. We do give discounts, but the number is small
in comparison to the number I am off by. I am using the field
InvcHead.InvoiceAmt to get my number. I probably am not accounting for
discounts in my current report and should be, but I think there is still
something else wrong.

Kara
> -----Original Message-----
> From: Darren Mann [SMTP:dmann@...]
> Sent: Tuesday, November 20, 2001 10:05 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> Do you give discounts? If so the calculation for selling price may need
> to
> reflect this. See which field is being used to calculate the sales $ and
> that should tell you which figure is being used.
>
> Regards,
>
> Darren Mann
> IT Manager
> Miller Products Co.
>
> -----Original Message-----
> From: kstoller@...
> [mailto:kstoller@...]
> Sent: Tuesday, November 20, 2001 8:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Sales by State
>
>
> I've created a Sales by State report using InvcHead as my master
> table and Customer as a related table. The total sales on the report
> never equal our actual sales, they are always less. I did month by
> month comparisons and found that I was off each month. I tried
> downloading the Sales by State report of this site, and it gave me
> the same results. Does anyone know what I'm missing?
>
> Kara Stoller
> Accouting Manager
> CNC Metal Products, Inc.
>
>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have
> already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1533402700
> 03000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812074/rand=115456271>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.


Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Kara, you stated "they are always less". Which number is less? Sales
Report or actual sales (I assume actual sales come from your financial
statements)?

Actual sales could be less due to the fact that Misc Charges are included
in the InvcHead.InvoiceAmt but might be going to a non-sales account in your
G/L. I would check your misc. charge details to see what G/L acct they are
posted to. Look at the Invcmisc table for those details.

The Sales report could be showing less due to several reasons. Do customers
ever overpay invoices and you have to put the overpayment "on account".
This activity creates invoices (credit memo) that you might be including.
You can filter those out at the InvcHead. InvcHead.UnappliedCash<>Yes will
exclude from report.

HTH

Jim Stetter
Snow Filtration

-----Original Message-----
From: kstoller@... [mailto:kstoller@...]
Sent: Tuesday, November 20, 2001 9:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Sales by State


I've created a Sales by State report using InvcHead as my master
table and Customer as a related table. The total sales on the report
never equal our actual sales, they are always less. I did month by
month comparisons and found that I was off each month. I tried
downloading the Sales by State report of this site, and it gave me
the same results. Does anyone know what I'm missing?

Kara Stoller
Accouting Manager
CNC Metal Products, Inc.


Yahoo! Groups Sponsor



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
One thought is whether you have any deferred revenue type invoicing.
Advanced payment or Deposit invoices will go to deferred revenue instead of
sales. Also the final invoice will record the whole sale into the G/L but
your report would should only the balance of the invoice (sale-previously
billed amounts)

Just another thing to look at besides the things already mentioned.

Rick Lane
Intelligent Systems Integration, Inc.
600 Weber Drive
Wadsworth, OH 44281
PH: 330-335-5291
FX: 330-335-7275

"Helping Business Make Intelligent Use of Technology"
Jim,
I am using the total sales number on my income statement. This consists of
sales from 2 locations less sales allowances & discounts from each location.
All credit memos should be reflected in the regular sales accounts. My RB
report is less than my income statement. I will try to look at misc charges
alone and see if that's my difference.

Thanks,
Kara

> -----Original Message-----
> From: Jim Frice [SMTP:Jim.Frice@...]
> Sent: Tuesday, November 20, 2001 10:45 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> Kara,
>
> Looking at the report downloaded from the site it uses the extended price
> which is calculated as the (ShipQty/PricePer) * UnitPrice. If you have any
> tax or misc. charges they will not be in the price or accounted for on the
> report. What report are you using to try and match to? G/L Distribution?
> Sales Analysis? If the report builder report is less you may want to look
> at
> your misc. charges and taxes for the month and add them to the report
> builder report total and see if that is your difference. Hope that helps.
>
> > -----Original Message-----
> > From: kstoller@...
> > [mailto:kstoller@...]
> > Sent: Tuesday, November 20, 2001 8:49 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Sales by State
> >
> >
> > I've created a Sales by State report using InvcHead as my master
> > table and Customer as a related table. The total sales on the report
> > never equal our actual sales, they are always less. I did month by
> > month comparisons and found that I was off each month. I tried
> > downloading the Sales by State report of this site, and it gave me
> > the same results. Does anyone know what I'm missing?
> >
> > Kara Stoller
> > Accouting Manager
> > CNC Metal Products, Inc.
> >
> >
> >
> > Useful links for the Yahoo!Groups Vantage Board are: ( Note: You
> > must have already linked your email address to a yahoo id to
> > enable access. )
> > (1) To access the Files Section of our Yahoo!Group for Report
> > Builder and Crystal Reports and other 'goodies', please goto:
> > <http://groups.yahoo.com/group/vantage/files/.>
> > (2) To search through old msg's goto:
> > <http://groups.yahoo.com/group/vantage/messages>
> > (3) To view links to Vendors that provide Vantage services goto:
> > <http://groups.yahoo.com/group/vantage/links>
> >
> > Your use of Yahoo! Groups is subject to
> <http://docs.yahoo.com/info/terms/>
> >
> >
> >
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812075/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1783498000
> 57000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812075/rand=699577564>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.
Thanks Lydia, I'll look at this.

Kara

> -----Original Message-----
> From: Lydia Coffman [SMTP:lcoffman@...]
> Sent: Tuesday, November 20, 2001 11:20 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Sales by State
>
> Kara:
>
> Misc. Charges (as opposed to Misc. Invoices) are probably not included in
> your RB report. When I went through a similar exercise, I ended up doing
> a
> report for just the Misc. Charges.
>
> If you typically have a lot of expedite, tooling or engineering charges,
> this could be contributing to your discrepancy.
>
> Lydia
>
>
>
> Yahoo! Groups Sponsor
>
> <http://rd.yahoo.com/M=212180.1701098.3252983.1269402/D=egroupweb/S=170500
> 7183:HM/A=812074/R=0/*http://www.verisign.com/cgi-bin/go.cgi?a=b1533402700
> 03000>
>
> <http://us.adserver.yahoo.com/l?M=212180.1701098.3252983.1269402/D=egroupm
> ail/S=1705007183:HM/A=812074/rand=728978219>
>
> Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
> have already linked your email address to a yahoo id to enable access. )
> (1) To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please goto:
> <http://groups.yahoo.com/group/vantage/files/.>
> (2) To search through old msg's goto:
> <http://groups.yahoo.com/group/vantage/messages>
> (3) To view links to Vendors that provide Vantage services goto:
> <http://groups.yahoo.com/group/vantage/links>
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
> <http://docs.yahoo.com/info/terms/>.