Order dollars by state

Yahoo Archive
1
Judd,

Thanks for your response but I don't have Corvu.

Sandy Morse
BVR Technologies Company
2
I need to have a report that shows the order dollars shipping by
state/country for this fiscal year. I have tried but the order release
does not have the customer number in it and the order detail does not
have the shipto in it. Without both you get multiple records for each
release. Does anyone know how I can get this to work?

Thanks!
Sandy Morse
BVR Technologies Company
3
If you start with InvoiceDtl and link to other tables you should not get
duplicates unless you linked incorrectly.

InvoiceDtl to InvoiceHead
InvoiceDtl to OrderRel
InvoiceDtl to OrderDtl
InvoiceDtl to Orderhead




Patrick Winter


-----Original Message-----
From: Sandy Morse [mailto:smorse@...]
Sent: Friday, June 04, 2004 3:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order dollars by state

I need to have a report that shows the order dollars shipping by
state/country for this fiscal year. I have tried but the order release does
not have the customer number in it and the order detail does not have the
shipto in it. Without both you get multiple records for each release. Does
anyone know how I can get this to work?

Thanks!
Sandy Morse
BVR Technologies Company





------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->

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
Yahoo! Groups Links
4
We recently started using the Quality Assurance Module for incoming
inspection. I have not been able to verify my Received Goods account since
we started using QA. When I run Inventory/WIP Account Reconciliation for
INS-SUB the last batch of credits are in Account: Unknown.

My G/L Account Recap Looks like this:
Acct# Debit Credit Description
1313 34,661.90 WIP -
Subcontractor
2025 23,087.46 Received
Goods
Unknown 11,574.44 Unknown ACCOUNT
DESCRIPTION

Has any one seen this before? The $11,574.44 is what my received goods
account is off. When I run my Trial balance everything balances out okay,
and there is no account listed called Unknown. I know I need to move this
$11,574.44 to my received goods account but I don't know what the off
setting account number is? I'm hoping someone out there can help!

Thanks,
Kathy Hambleton
Electron Energy Corporation




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

See if the attached RB report will work for you. It's from the files
section on Yahoo, with some slight changes made to it.

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.507

-----Original Message-----
From: Sandy Morse [mailto:smorse@...]
Sent: Friday, June 04, 2004 4:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order dollars by state

I need to have a report that shows the order dollars shipping by
state/country for this fiscal year. I have tried but the order release
does not have the customer number in it and the order detail does not
have the shipto in it. Without both you get multiple records for each
release. Does anyone know how I can get this to work?

Thanks!
Sandy Morse
BVR Technologies Company



[Non-text portions of this message have been removed]
6
Oops, did I do that? Sorry about that, group; the last message was supposed
to go to Sandy directly.

Regards,
Scott

-----Original Message-----
From: Lepley, Scott A. [mailto:sal@...]
Sent: Friday, June 04, 2004 4:31 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Order dollars by state

Sandy,

See if the attached RB report will work for you. It's from the files
section on Yahoo, with some slight changes made to it.

Regards,
Scott Lepley
Systems Administrator
Mauell Corporation
Phone: 717-432-8686, ext. 14
Fax: 717-432-8688
Email: sal@...
Vantage version: 6.10.507

-----Original Message-----
From: Sandy Morse [mailto:smorse@...]
Sent: Friday, June 04, 2004 4:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order dollars by state

I need to have a report that shows the order dollars shipping by
state/country for this fiscal year. I have tried but the order release
does not have the customer number in it and the order detail does not
have the shipto in it. Without both you get multiple records for each
release. Does anyone know how I can get this to work?

Thanks!
Sandy Morse
BVR Technologies Company



[Non-text portions of this message have been removed]
7
What do you have in the control accounts for Inspection and DMR?

-----Original Message-----
From: Kathy Hambleton [mailto:kbh@...]
Sent: Friday, June 04, 2004 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Unknown GL Account


We recently started using the Quality Assurance Module for incoming
inspection. I have not been able to verify my Received Goods account since
we started using QA. When I run Inventory/WIP Account Reconciliation for
INS-SUB the last batch of credits are in Account: Unknown.

My G/L Account Recap Looks like this:
Acct# Debit Credit Description
1313 34,661.90 WIP -
Subcontractor
2025 23,087.46 Received
Goods
Unknown 11,574.44 Unknown ACCOUNT
DESCRIPTION

Has any one seen this before? The $11,574.44 is what my received goods
account is off. When I run my Trial balance everything balances out okay,
and there is no account listed called Unknown. I know I need to move this
$11,574.44 to my received goods account but I don't know what the off
setting account number is? I'm hoping someone out there can help!

Thanks,
Kathy Hambleton
Electron Energy Corporation




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



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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=129apk86h/M=298184.5022502.6152625.3001176/D=groups/S=1705007183:HM/EXP=1086467375/A=2164331/R=0/SIG=11eaelai9/*http://www.netflix.com/Default?mqso=60183351> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164331/rand=461273071>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
8
For inspection I have acct# 2026 which is the Receiving Inspection acct and
for DMR I have 6020 which is the COGS Variance acct. I think though that
that may be the problem. I recently changed the Inspection control acct on
someones recommendation and to be honest with you I don't recall what
account number was in there before that.

Kathy
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Friday, June 04, 2004 4:44 PM
To: vantage@yahoogroups.com
Subject: Spam:RE: [Vantage] Unknown GL Account


What do you have in the control accounts for Inspection and DMR?

-----Original Message-----
From: Kathy Hambleton [mailto:kbh@...]
Sent: Friday, June 04, 2004 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Unknown GL Account


We recently started using the Quality Assurance Module for incoming
inspection. I have not been able to verify my Received Goods account
since
we started using QA. When I run Inventory/WIP Account Reconciliation for
INS-SUB the last batch of credits are in Account: Unknown.

My G/L Account Recap Looks like this:
Acct# Debit Credit Description
1313 34,661.90 WIP -
Subcontractor
2025 23,087.46 Received
Goods
Unknown 11,574.44 Unknown ACCOUNT
DESCRIPTION

Has any one seen this before? The $11,574.44 is what my received goods
account is off. When I run my Trial balance everything balances out okay,
and there is no account listed called Unknown. I know I need to move
this
$11,574.44 to my received goods account but I don't know what the off
setting account number is? I'm hoping someone out there can help!

Thanks,
Kathy Hambleton
Electron Energy Corporation




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



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



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/SIG=129apk86h/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086467375/A=2164331/R=0/SIG=11eaelai9/*http://www.netf
lix.com/Default?mqso=60183351> click here

<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164331/rand=461273071>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

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

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



[Non-text portions of this message have been removed]
9
I have a report like this in vbi , If you have Corvu I do not have a problem
sending it to you.



Judd

Custom Hoists, Inc.



-----Original Message-----
From: Sandy Morse [mailto:smorse@...]
Sent: Friday, June 04, 2004 4:08 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Order dollars by state



I need to have a report that shows the order dollars shipping by
state/country for this fiscal year. I have tried but the order release
does not have the customer number in it and the order detail does not
have the shipto in it. Without both you get multiple records for each
release. Does anyone know how I can get this to work?

Thanks!
Sandy Morse
BVR Technologies Company





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>






Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/SIG=129ju9vbb/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086466106/A=2164338/R=0/SIG=11ed4vqbv/*http:/www.netfl
ix.com/Default?mqso=60183349> click here



<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164338/rand=570818545>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


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



[Non-text portions of this message have been removed]
10
Well that could be it if you didn't have an account number in there it would have gone to your suspense account number I think - It has been awhile since we put account numbers in there but I think that is where everything goes if not told an appropriate account number.

-----Original Message-----
From: Kathy Hambleton [mailto:kbh@...]
Sent: Friday, June 04, 2004 3:56 PM
To: vantage@yahoogroups.com
Subject: RE: Spam:RE: [Vantage] Unknown GL Account


For inspection I have acct# 2026 which is the Receiving Inspection acct and
for DMR I have 6020 which is the COGS Variance acct. I think though that
that may be the problem. I recently changed the Inspection control acct on
someones recommendation and to be honest with you I don't recall what
account number was in there before that.

Kathy
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Friday, June 04, 2004 4:44 PM
To: vantage@yahoogroups.com
Subject: Spam:RE: [Vantage] Unknown GL Account


What do you have in the control accounts for Inspection and DMR?

-----Original Message-----
From: Kathy Hambleton [mailto:kbh@...]
Sent: Friday, June 04, 2004 3:30 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Unknown GL Account


We recently started using the Quality Assurance Module for incoming
inspection. I have not been able to verify my Received Goods account
since
we started using QA. When I run Inventory/WIP Account Reconciliation for
INS-SUB the last batch of credits are in Account: Unknown.

My G/L Account Recap Looks like this:
Acct# Debit Credit Description
1313 34,661.90 WIP -
Subcontractor
2025 23,087.46 Received
Goods
Unknown 11,574.44 Unknown ACCOUNT
DESCRIPTION

Has any one seen this before? The $11,574.44 is what my received goods
account is off. When I run my Trial balance everything balances out okay,
and there is no account listed called Unknown. I know I need to move
this
$11,574.44 to my received goods account but I don't know what the off
setting account number is? I'm hoping someone out there can help!

Thanks,
Kathy Hambleton
Electron Energy Corporation




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



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



Yahoo! Groups Sponsor

ADVERTISEMENT

< http://rd.yahoo.com/SIG=129apk86h/M=298184.5022502.6152625.3001176/D=groups
/S=1705007183:HM/EXP=1086467375/A=2164331/R=0/SIG=11eaelai9/* http://www.netf
lix.com/Default?mqso=60183351> click here

< http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=
:HM/A=2164331/rand=461273071>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]



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


Yahoo! Groups Sponsor
ADVERTISEMENT





----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

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

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



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



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



Yahoo! Groups Sponsor

ADVERTISEMENT
<http://rd.yahoo.com/SIG=1299de8j3/M=298184.5022502.6152625.3001176/D=groups/S=1705007183:HM/EXP=1086468947/A=2164330/R=0/SIG=11eamf8g4/*http://www.netflix.com/Default?mqso=60183350> click here
<http://us.adserver.yahoo.com/l?M=298184.5022502.6152625.3001176/D=groups/S=:HM/A=2164330/rand=224932859>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]