Inventory/WIP Acct Recon Report


(system) #1
Use an ODBC connection to the the PartTran table to write a query. I
know there is account information stored for the transaction as well as
a field called "PostedToGL". You should be able to write a query to
pull the information you are looking for.

Butch

________________________________

From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 8:35 AM
To: Vantage (Vantage List)
Subject: [Vantage]Inventory/WIP Acct Recon Report


Our CFO has asked if there is any way to gather the following
information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report
for
several different accounts (one at a time), and the run time for all of
them
takes about 1 1/2 hours. That's alot of time out of one persons day,
each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though
it
would be lengthy, but have not had much luck. I tried looking for
report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know
of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




[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
click here
<http://us.ard.yahoo.com/SIG=12911agud/M=298184.6191685.7192823.3001176/
D=groups/S=1705007183:HM/EXP=1112114346/A=2593423/R=0/SIG=11el9gslf/*htt
p://www.netflix.com/Default?mqso=60190075>

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=group
s/S=:HM/A=2593423/rand=816947529>

________________________________

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]

(system) #2
Our CFO has asked if there is any way to gather the following information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report for
several different accounts (one at a time), and the run time for all of them
takes about 1 1/2 hours. That's alot of time out of one persons day, each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though it
would be lengthy, but have not had much luck. I tried looking for report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




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

(system) #3
What is he using it for... the totals are on the bottom when you run all the accounts.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 11:35 AM
To: Vantage (Vantage List)
Subject: [Vantage]Inventory/WIP Acct Recon Report



Our CFO has asked if there is any way to gather the following information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report for
several different accounts (one at a time), and the run time for all of them
takes about 1 1/2 hours. That's alot of time out of one persons day, each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though it
would be lengthy, but have not had much luck. I tried looking for report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




[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 Links

(system) #4
He is inserting the totals into a spreadsheet using Total Sales/Revenue and
Total Cost of Sales to determine the Gross Margin Percentage.

He wants to put this information together on a daily basis for supervisors
to see, and the process for coming up with the numbers takes too much time.
He is looking for some way to shorten the amount of time invested in getting
the numbers.

Not being the accounting expert, I never thought about running the report
without choosing an account with that giving you the results of all the
accounts. However, it is still a large time investment and I was trying to
find a way to get the same information without it taking so long.

Marilyn

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 28, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report


What is he using it for... the totals are on the bottom when you run all the
accounts.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 11:35 AM
To: Vantage (Vantage List)
Subject: [Vantage]Inventory/WIP Acct Recon Report



Our CFO has asked if there is any way to gather the following information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report for
several different accounts (one at a time), and the run time for all of them
takes about 1 1/2 hours. That's alot of time out of one persons day, each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though it
would be lengthy, but have not had much luck. I tried looking for report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




[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/.
<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 Links









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://us.ard.yahoo.com/SIG=129fch89f/M=298184.6191685.7192823.3001176/D=gr
oups/S=1705007183:HM/EXP=1112114547/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
:HM/A=2593423/rand=464635417>


_____

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 Service
<http://docs.yahoo.com/info/terms/> .




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

(system) #5
Well not knowing exactly what he is doing... You should be able to get the same information for the COGS accounts if you are running all as running one account at a time... I guess I would have to see what exactly he is looking for before you could decide.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 1:24 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report



He is inserting the totals into a spreadsheet using Total Sales/Revenue and
Total Cost of Sales to determine the Gross Margin Percentage.

He wants to put this information together on a daily basis for supervisors
to see, and the process for coming up with the numbers takes too much time.
He is looking for some way to shorten the amount of time invested in getting
the numbers.

Not being the accounting expert, I never thought about running the report
without choosing an account with that giving you the results of all the
accounts. However, it is still a large time investment and I was trying to
find a way to get the same information without it taking so long.

Marilyn

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 28, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report


What is he using it for... the totals are on the bottom when you run all the
accounts.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 11:35 AM
To: Vantage (Vantage List)
Subject: [Vantage]Inventory/WIP Acct Recon Report



Our CFO has asked if there is any way to gather the following information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report for
several different accounts (one at a time), and the run time for all of them
takes about 1 1/2 hours. That's alot of time out of one persons day, each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though it
would be lengthy, but have not had much luck. I tried looking for report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




[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/.
<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 Links









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://us.ard.yahoo.com/SIG=129fch89f/M=298184.6191685.7192823.3001176/D=gr
oups/S=1705007183:HM/EXP=1112114547/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
:HM/A=2593423/rand=464635417>


_____

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 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 Links

(system) #6
-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 28, 2005 12:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report


Well not knowing exactly what he is doing... You should be able to get the
same information for the COGS accounts if you are running all as running one
account at a time... I guess I would have to see what exactly he is looking
for before you could decide.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 1:24 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report



He is inserting the totals into a spreadsheet using Total Sales/Revenue and
Total Cost of Sales to determine the Gross Margin Percentage.

He wants to put this information together on a daily basis for supervisors
to see, and the process for coming up with the numbers takes too much time.
He is looking for some way to shorten the amount of time invested in getting
the numbers.

Not being the accounting expert, I never thought about running the report
without choosing an account with that giving you the results of all the
accounts. However, it is still a large time investment and I was trying to
find a way to get the same information without it taking so long.

Marilyn

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 28, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report


What is he using it for... the totals are on the bottom when you run all the
accounts.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 11:35 AM
To: Vantage (Vantage List)
Subject: [Vantage]Inventory/WIP Acct Recon Report



Our CFO has asked if there is any way to gather the following information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report for
several different accounts (one at a time), and the run time for all of them
takes about 1 1/2 hours. That's alot of time out of one persons day, each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though it
would be lengthy, but have not had much luck. I tried looking for report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




[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/.
<http://groups.yahoo.com/group/vantage/files/.>
<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>
<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>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Links









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/.>
<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>
<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>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129fch89f/M=298184.6191685.7192823.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129fch89f/M=298184.6191685.7192823.3001176/D=gr
>
oups/S=1705007183:HM/EXP=1112114547/A=2593423/R=0/SIG=11el9gslf/*http://www.
<http://www.>
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
>
:HM/A=2593423/rand=464635417>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<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 Service
<http://docs.yahoo.com/info/terms/ <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/.
<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 Links









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://us.ard.yahoo.com/SIG=129sa2k95/M=298184.6191685.7192823.3001176/D=gr
oups/S=1705007183:HM/EXP=1112121399/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
:HM/A=2593423/rand=692114784>


_____

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 Service
<http://docs.yahoo.com/info/terms/> .




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

(system) #7
Believe it or not Stephanie, your first question opened my eyes just enough
to see that I wasn't seeing . When I run the report for all accounts it
does give him what he wants and much faster than running them one at a time.
I goofed on my first trial and inserted dates starting in 2000 and ending in
2005 - that's why it took so long that way. Sometimes its hard to see the
forest for the trees!

Thanks Stephanie!

-----Original Message
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 28, 2005 12:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report


Well not knowing exactly what he is doing... You should be able to get the
same information for the COGS accounts if you are running all as running one
account at a time... I guess I would have to see what exactly he is looking
for before you could decide.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 1:24 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report



He is inserting the totals into a spreadsheet using Total Sales/Revenue and
Total Cost of Sales to determine the Gross Margin Percentage.

He wants to put this information together on a daily basis for supervisors
to see, and the process for coming up with the numbers takes too much time.
He is looking for some way to shorten the amount of time invested in getting
the numbers.

Not being the accounting expert, I never thought about running the report
without choosing an account with that giving you the results of all the
accounts. However, it is still a large time investment and I was trying to
find a way to get the same information without it taking so long.

Marilyn

-----Original Message-----
From: Geary, Stephanie [mailto:sgeary@...]
Sent: Monday, March 28, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage]Inventory/WIP Acct Recon Report


What is he using it for... the totals are on the bottom when you run all the
accounts.

-----Original Message-----
From: Marilyn Fairchild [mailto:mfairchild@...]
Sent: Monday, March 28, 2005 11:35 AM
To: Vantage (Vantage List)
Subject: [Vantage]Inventory/WIP Acct Recon Report



Our CFO has asked if there is any way to gather the following information in
a much faster manner than he is doing at this time.

He wants to us only the Account Totals found at the bottom of the
Inventory/WIP Account Reconciliation Report. He is running this report for
several different accounts (one at a time), and the run time for all of them
takes about 1 1/2 hours. That's alot of time out of one persons day, each
day to get him the totals he is wanting to used in a spreadsheet.

I have looked for a way to recreate this report and be able to enter
multiple accounts so that the report need only be run once, even though it
would be lengthy, but have not had much luck. I tried looking for report
notes, but could not find anything on that either.

We are still on 5.0 at this time. Anyone have any suggestions or know of
something that is so obvious I can't see it?

Marilyn Fairchild
Systems Administrator
Pickwick Manufacturing Services




[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/.
<http://groups.yahoo.com/group/vantage/files/.>
<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>
<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>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >
Yahoo! Groups Links









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/.>
<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>
<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>
<http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=129fch89f/M=298184.6191685.7192823.3001176/D=gr
<http://us.ard.yahoo.com/SIG=129fch89f/M=298184.6191685.7192823.3001176/D=gr
>
oups/S=1705007183:HM/EXP=1112114547/A=2593423/R=0/SIG=11el9gslf/*http://www.
<http://www.>
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
>
:HM/A=2593423/rand=464635417>


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
<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 Service
<http://docs.yahoo.com/info/terms/ <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/.
<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 Links









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://us.ard.yahoo.com/SIG=129sa2k95/M=298184.6191685.7192823.3001176/D=gr
oups/S=1705007183:HM/EXP=1112121399/A=2593423/R=0/SIG=11el9gslf/*http://www.
netflix.com/Default?mqso=60190075> click here

<http://us.adserver.yahoo.com/l?M=298184.6191685.7192823.3001176/D=groups/S=
:HM/A=2593423/rand=692114784>


_____

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 Service
<http://docs.yahoo.com/info/terms/> .




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