Need to Remove Pending Cash Receipt

Yahoo Archive
1
Sorry, Ari, my email never went through last night.



I said just call up tech support then, because they should be able to
write a program to remove the group. At least it never hit the GL,
which was why I had originally said open up the period.







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ari Footlik
Sent: Wednesday, October 03, 2007 4:37 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Need to Remove Pending Cash Receipt



Yes - it's an entry that was never posted, ostensibly because it was a
junk entry that should have been deleted or negated anyway. The
comment-field on the entry says something like, "Test123."

--Ari
________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, October 03, 2007 4:25 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to Remove Pending Cash Receipt

Not sure on that, I don't think you have to go to that extreme. But I
am a little confused, is it an entry that was never posted?

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ari Footlik
Sent: Wednesday, October 03, 2007 4:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to Remove Pending Cash Receipt

Re-opening the periods related to these transactions didn't allow me to
access the cash-receipt group. Do you think I'd need to re-open every
period from the transaction-dates forward, or should I be able to open
on the the dates shown in the cash-receipt group?

Thanks again.
--Ari
________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: Wednesday, October 03, 2007 4:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Need to Remove Pending Cash Receipt

You can reopen past periods, but not sure about past years...I would
assume you can as well.

M. Manasa Reddy

manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Ari Footlik
Sent: Wednesday, October 03, 2007 3:29 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Need to Remove Pending Cash Receipt

Good afternoon, all!

My AR manager came to me today and pointed out an open cash-receipt
entry entity from early 2005 that cannot be opened, from an "test"
invoice that was created and never disposed of properly. The AR manager
wants to remove the junk invoice, or make an adjustment to the invoice,
but neither option is available apparently because 2005 has already been
closed and we cannot post the cash-receipt.

Any ideas on how we can resolve this?

Thanks in advance.

----------------------------------------------------------
Ari Footlik
IT Manager - R. A. Zweig

Recent Activity

*
12
New Members
<http://groups.yahoo.com/group/vantage/members;_ylc=X3oDMTJkc3NoaXRuBF9T
<http://groups.yahoo.com/group/vantage/members;_ylc=X3oDMTJkc3NoaXRuBF9T
>
Azk3MzU5NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2
bWJycwRzdGltZQMxMTkxNDQ2NzAy>

Visit Your Group
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdmw0NWY3BF9TAzk3MzU5
<http://groups.yahoo.com/group/vantage;_ylc=X3oDMTJjdmw0NWY3BF9TAzk3MzU5
>
NzE0BGdycElkAzIwMzY5BGdycHNwSWQDMTcwNTAwNzE4MwRzZWMDdnRsBHNsawN2Z2hwBHN0
aW1lAzExOTE0NDY3MDI->
Yahoo! Finance

It's Now Personal
<http://us.ard.yahoo.com/SIG=12jg2p4i2/M=493064.10729649.11333340.867457
<http://us.ard.yahoo.com/SIG=12jg2p4i2/M=493064.10729649.11333340.867457
>
8/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1191453902/A=4507179/R=0/SIG=12de
4rskk/*http://us.rd.yahoo.com/evt=50284/*http://finance.yahoo.com/person
<http://us.rd.yahoo.com/evt=50284/*http:/finance.yahoo.com/person>
al-finance>

Guides, news,

advice & more.

Need traffic?

Drive customers
<http://us.ard.yahoo.com/SIG=12jtseog1/M=493064.10729656.11333347.867457
<http://us.ard.yahoo.com/SIG=12jtseog1/M=493064.10729656.11333347.867457
>
8/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1191453902/A=3848644/R=0/SIG=131l
83flq/*http://searchmarketing.yahoo.com/arp/srchv2.php?o=US2006&cmp=Yaho
<http://searchmarketing.yahoo.com/arp/srchv2.php?o=US2006&cmp=Yaho>
o&ctv=Groups5&s=Y&s2=&s3=&b=50>

With search ads

on Yahoo!

Green Y! Groups

Environment Groups
<http://us.ard.yahoo.com/SIG=12j0gm9g0/M=493064.11135488.11710474.867457
<http://us.ard.yahoo.com/SIG=12j0gm9g0/M=493064.11135488.11710474.867457
>
8/D=groups/S=1705007183:NC/Y=YAHOO/EXP=1191453902/A=4776366/R=0/SIG=11mj
2s6kj/*http://advision.webevents.yahoo.com/green/index.html
<http://advision.webevents.yahoo.com/green/index.html> >

Find them here

connect with others.

.

<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
<http://geo.yahoo.com/serv?s=97359714/grpId=20369/grpspId=1705007183/msg
>
Id=59618/stime=1191446702/nc1=4507179/nc2=3848644/nc3=4776366>


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





[Non-text portions of this message have been removed]
2
Is anyone familiar with a problem in running BAQ Report Designer where
it just DOESN'T run, or takes hours to return a preview of a report?
I have a fairly simple query running on a 600 record parts db (we're
still setting up to implement), so things should only take a few
seconds. It's a fairly recent problem, so something's changed, but
darned if I can figure out what...

Help?

Lynn Thomas
SAIC
3
Lynn,
Have you tried to run that query as a simple BAQ?
I wonder if you can be looking at one of the situations where the order of your joins is affecting the query run time.
When using the regular BAQ application, I noticed that the way I structured the query had a HUGE difference on the time it took to get the results, sometimes by minutes.

Carey


To: vantage@yahoogroups.comFrom: thomasl@...: Thu, 27 Sep 2007 14:58:14 +0000Subject: [Vantage] BAQ Report Designer at glacial speeds?




Is anyone familiar with a problem in running BAQ Report Designer whereit just DOESN'T run, or takes hours to return a preview of a report? I have a fairly simple query running on a 600 record parts db (we'restill setting up to implement), so things should only take a fewseconds. It's a fairly recent problem, so something's changed, butdarned if I can figure out what...Help?Lynn ThomasSAIC






_________________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

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

In the BAQ module the query analyzes as good and tests in a few
seconds. In Report Designer I see nothing back in half an hour or
more...I could almost do the task by hand in that time. OK, not
quite, but I'd have a very good start on it.

--- In vantage@yahoogroups.com, Carey S <rotary1@...> wrote:
>
> Lynn,
> Have you tried to run that query as a simple BAQ?
> I wonder if you can be looking at one of the situations where the
order of your joins is affecting the query run time.
> When using the regular BAQ application, I noticed that the way I
structured the query had a HUGE difference on the time it took to get
the results, sometimes by minutes.
>
> Carey
>
>
> To: vantage@...: thomasl@...: Thu, 27 Sep 2007 14:58:14
+0000Subject: [Vantage] BAQ Report Designer at glacial speeds?
>
>
>
>
> Is anyone familiar with a problem in running BAQ Report Designer
where it just DOESN'T run, or takes hours to return a preview of a
report? I have a fairly simple query running on a 600 record parts db
(we'restill setting up to implement), so things should only take a
fewseconds. It's a fairly recent problem, so something's changed,
butdarned if I can figure out what...Help?Lynn ThomasSAIC
>
>
>
>
>
>
> _________________________________________________________________
> News, entertainment and everything you care about at Live.com. Get
it now!
> http://www.live.com/getstarted.aspx
>
> [Non-text portions of this message have been removed]
>
5
if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r files for BAQ. I got them from support yesterday from Judy Perry. My wide open report that would get stuck for days now ran in 5 minutes. If you can't get to Judy on support call me offline and I can send you the files.

Lynn Thomas 83 <thomasl@...> wrote:
Is anyone familiar with a problem in running BAQ Report Designer where
it just DOESN'T run, or takes hours to return a preview of a report?
I have a fairly simple query running on a 600 record parts db (we're
still setting up to implement), so things should only take a few
seconds. It's a fairly recent problem, so something's changed, but
darned if I can figure out what...

Help?

Lynn Thomas
SAIC






Melissa Hietala
UMC, Inc.
melissah@...

---------------------------------
Got a little couch potato?
Check out fun summer activities for kids.

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

I'm on 8.03.305I, which had a fix for a problem we submitted, but I
honestly can't say for certain that this wasn't a problem before that.
Sometimes the exact days get a little blurry. No matter, I've called
support, and the guy I talked to knew Judy and forwarded the message
to her. He works in the same group but his expertise is elsewhere;
just taking overflow right now. OK. This is too big for anyone to
know all of it that thoroughly...

Lynn

--- In vantage@yahoogroups.com, melissa hietala <kevmel822@...> wrote:
>
> if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r
files for BAQ. I got them from support yesterday from Judy Perry. My
wide open report that would get stuck for days now ran in 5 minutes.
If you can't get to Judy on support call me offline and I can send you
the files.
>
> Lynn Thomas 83 <thomasl@...> wrote:
> Is anyone familiar with a problem in running BAQ Report
Designer where
> it just DOESN'T run, or takes hours to return a preview of a report?
> I have a fairly simple query running on a 600 record parts db (we're
> still setting up to implement), so things should only take a few
> seconds. It's a fairly recent problem, so something's changed, but
> darned if I can figure out what...
>
> Help?
>
> Lynn Thomas
> SAIC
>
>
>
>
>
>
> Melissa Hietala
> UMC, Inc.
> melissah@...
>
> ---------------------------------
> Got a little couch potato?
> Check out fun summer activities for kids.
>
> [Non-text portions of this message have been removed]
>
7
Carey hit the nail on the head for you Lynn - ANY query (no matter what language is used, SQL, Vantage's BAQ syntax, etc.,) is greatly affected by the number and order of table joins. Always join indexed columns first (example: Part.Company=JobHead.Company). Also avoid overjoining (not always easy to do do until you become well versed in the db structures!)

Writing otherwise identical BAQs using several differently ordered table joins can quickly reveal better optimization practices you can use in the current (and future) queries.


Carey S <rotary1@...> wrote:
Lynn,
Have you tried to run that query as a simple BAQ?
I wonder if you can be looking at one of the situations where the order of your joins is affecting the query run time.
When using the regular BAQ application, I noticed that the way I structured the query had a HUGE difference on the time it took to get the results, sometimes by minutes.

Carey

To: vantage@yahoogroups.comFrom: thomasl@...: Thu, 27 Sep 2007 14:58:14 +0000Subject: [Vantage] BAQ Report Designer at glacial speeds?

Is anyone familiar with a problem in running BAQ Report Designer whereit just DOESN'T run, or takes hours to return a preview of a report? I have a fairly simple query running on a 600 record parts db (we'restill setting up to implement), so things should only take a fewseconds. It's a fairly recent problem, so something's changed, butdarned if I can figure out what...Help?Lynn ThomasSAIC

__________________________________________________________
News, entertainment and everything you care about at Live.com. Get it now!
http://www.live.com/getstarted.aspx

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






---------------------------------
Tonight's top picks. What will you watch tonight? Preview the hottest shows on Yahoo! TV.

[Non-text portions of this message have been removed]
8
Don't forget that often just adding the filter for your company as the
first line will make a big difference in speeds too. For example if your
Primary table is the Part table, make your first filter - Part.Company =
"your company Code goes here"

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Friday, 28 September 2007 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Report Designer at glacial speeds?

Carey hit the nail on the head for you Lynn - ANY query (no matter what
language is used, SQL, Vantage's BAQ syntax, etc.,) is greatly affected
by the number and order of table joins. Always join indexed columns
first (example: Part.Company=JobHead.Company). Also avoid overjoining
(not always easy to do do until you become well versed in the db
structures!)

Writing otherwise identical BAQs using several differently ordered table
joins can quickly reveal better optimization practices you can use in
the current (and future) queries.


Carey S <rotary1@... <mailto:rotary1%40hotmail.com> > wrote:
Lynn,
Have you tried to run that query as a simple BAQ?
I wonder if you can be looking at one of the situations where the order
of your joins is affecting the query run time.
When using the regular BAQ application, I noticed that the way I
structured the query had a HUGE difference on the time it took to get
the results, sometimes by minutes.

Carey

To: vantage@yahoogroups.comFrom <mailto:vantage%40yahoogroups.comFrom> :
thomasl@... <mailto:thomasl%40cranepm10.comDate> : Thu, 27
Sep 2007 14:58:14 +0000Subject: [Vantage] BAQ Report Designer at glacial
speeds?

Is anyone familiar with a problem in running BAQ Report Designer whereit
just DOESN'T run, or takes hours to return a preview of a report? I have
a fairly simple query running on a 600 record parts db (we'restill
setting up to implement), so things should only take a fewseconds. It's
a fairly recent problem, so something's changed, butdarned if I can
figure out what...Help?Lynn ThomasSAIC

__________________________________________________________
News, entertainment and everything you care about at Live.com. Get it
now!
http://www.live.com/getstarted.aspx
<http://www.live.com/getstarted.aspx>

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

---------------------------------
Tonight's top picks. What will you watch tonight? Preview the hottest
shows on Yahoo! TV.

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



[Non-text portions of this message have been removed]
9
I believe the check for Company ID is done automatically on the primary file which is why the Company ID is ALWAYS the first thing in the BAQ name. I tested this out in Training Database which has multiple companies. It's impossible to see information from another company. That's good.

What's bad is the BAQ is therefore lying when it shows the Progress code. It's not the final end product.

Also, in 8.03.305i but don't know when it started, it supplies some index criteria automatically AFTER your criteria. This makes it hard to figure whether the indexes are used properly or not.
----- Original Message -----
From: "Stuart Noble" <stuart@...>
To: <vantage@yahoogroups.com>
Sent: Thursday, September 27, 2007 4:19 PM
Subject: RE: [Vantage] BAQ Report Designer at glacial speeds?


Don't forget that often just adding the filter for your company as the
first line will make a big difference in speeds too. For example if your
Primary table is the Part table, make your first filter - Part.Company =
"your company Code goes here"

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Robert Brown
Sent: Friday, 28 September 2007 9:06 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] BAQ Report Designer at glacial speeds?

Carey hit the nail on the head for you Lynn - ANY query (no matter what
language is used, SQL, Vantage's BAQ syntax, etc.,) is greatly affected
by the number and order of table joins. Always join indexed columns
first (example: Part.Company=JobHead.Company). Also avoid overjoining
(not always easy to do do until you become well versed in the db
structures!)

Writing otherwise identical BAQs using several differently ordered table
joins can quickly reveal better optimization practices you can use in
the current (and future) queries.


Carey S <rotary1@... <mailto:rotary1%40hotmail.com> > wrote:
Lynn,
Have you tried to run that query as a simple BAQ?
I wonder if you can be looking at one of the situations where the order
of your joins is affecting the query run time.
When using the regular BAQ application, I noticed that the way I
structured the query had a HUGE difference on the time it took to get
the results, sometimes by minutes.

Carey

To: vantage@yahoogroups.comFrom <mailto:vantage%40yahoogroups.comFrom> :
thomasl@... <mailto:thomasl%40cranepm10.comDate> : Thu, 27
Sep 2007 14:58:14 +0000Subject: [Vantage] BAQ Report Designer at glacial
speeds?

Is anyone familiar with a problem in running BAQ Report Designer whereit
just DOESN'T run, or takes hours to return a preview of a report? I have
a fairly simple query running on a 600 record parts db (we'restill
setting up to implement), so things should only take a fewseconds. It's
a fairly recent problem, so something's changed, butdarned if I can
figure out what...Help?Lynn ThomasSAIC

__________________________________________________________
News, entertainment and everything you care about at Live.com. Get it
now!
http://www.live.com/getstarted.aspx
<http://www.live.com/getstarted.aspx>

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

---------------------------------
Tonight's top picks. What will you watch tonight? Preview the hottest
shows on Yahoo! TV.

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



[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




[Non-text portions of this message have been removed]
10
We only have one company running in Vantage (really, a very tiny
operation here), and I'm pulling data from only 3 tables, none of them
terribly large, which puts severe limits on how complex this can
be...and, in BAQ, it works fine. The problem is in the Report
Designer. Also, it's worked in the past w/o problems. Something has
changed, but I can't pinpoint what.

I've got a call in to tech support for the .r files mentioned above.
If that doesn't help, something has gone really weird.

On another, but related topic, I DON'T like the Phrase Builder. It's
a good idea, but I find it very hard to make adjustments - like
changing the order of things - w/o starting over from scratch.

Lynn

--- In vantage@yahoogroups.com, "Stuart Noble" <stuart@...> wrote:
>
> Don't forget that often just adding the filter for your company as
the first line will make a big difference in speeds too. For example
if your Primary table is the Part table, make your first filter -
Part.Company = "your company Code goes here"
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Robert Brown
> Sent: Friday, 28 September 2007 9:06 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] BAQ Report Designer at glacial speeds?
>
> Carey hit the nail on the head for you Lynn - ANY query (no matter
what language is used, SQL, Vantage's BAQ syntax, etc.,) is greatly
affected by the number and order of table joins. Always join indexed
columns first (example: Part.Company=JobHead.Company). Also avoid
overjoining (not always easy to do do until you become well versed in
the db structures!)
>
> Writing otherwise identical BAQs using several differently ordered
table joins can quickly reveal better optimization practices you can
use in the current (and future) queries.
>
>
> Carey S <rotary1@... <mailto:rotary1%40hotmail.com> > wrote:
> Lynn,
> Have you tried to run that query as a simple BAQ?
> I wonder if you can be looking at one of the situations where the
order of your joins is affecting the query run time.
> When using the regular BAQ application, I noticed that the way I
> structured the query had a HUGE difference on the time it took to get
> the results, sometimes by minutes.
>
> Carey
>
> To: vantage@... <mailto:vantage%40yahoogroups.comFrom> :
> thomasl@... <mailto:thomasl%40cranepm10.comDate> : Thu, 27
> Sep 2007 14:58:14 +0000Subject: [Vantage] BAQ Report Designer at
glacial speeds?
>
> Is anyone familiar with a problem in running BAQ Report Designer
where it just DOESN'T run, or takes hours to return a preview of a
report? I have a fairly simple query running on a 600 record parts db
(we're still setting up to implement), so things should only take a
few seconds. It's a fairly recent problem, so something's changed,
but darned if I can figure out what...Help?
Lynn Thomas
SAIC
>
> __________________________________________________________
> News, entertainment and everything you care about at Live.com. Get it
> now!
> http://www.live.com/getstarted.aspx
> <http://www.live.com/getstarted.aspx>
>
> [Non-text portions of this message have been removed]
>
> ---------------------------------
> Tonight's top picks. What will you watch tonight? Preview the hottest
> shows on Yahoo! TV.
>
> [Non-text portions of this message have been removed]
>
>
>
> [Non-text portions of this message have been removed]
>
11
I didn't actually get them from Judy, but rather from Jim Nalls, who
knows her and contacted her. Got the files installed, per
instructions, this morning, but there's been no noticeable improvement
- after 15 minutes I'm pretty much convinced nothing's going to happen
in a useful time. I've stopped and restarted the app servers, and
even rebooted the machine, but no joy.

As small as my db is, it should return in a matter of seconds, but I'd
be pleased with anything less than 5 minutes.

Pending a reply to my email back to tech support, anyone have any
thoughts on this?

--- In vantage@yahoogroups.com, melissa hietala <kevmel822@...> wrote:
>
> if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r
files for BAQ. I got them from support yesterday from Judy Perry. My
wide open report that would get stuck for days now ran in 5 minutes.
If you can't get to Judy on support call me offline and I can send you
the files.
>
> Lynn Thomas 83 <thomasl@...> wrote:
> Is anyone familiar with a problem in running BAQ Report
Designer where
> it just DOESN'T run, or takes hours to return a preview of a report?
> I have a fairly simple query running on a 600 record parts db (we're
> still setting up to implement), so things should only take a few
> seconds. It's a fairly recent problem, so something's changed, but
> darned if I can figure out what...
>
> Help?
>
> Lynn Thomas
> SAIC
>
>
>
>
>
>
> Melissa Hietala
> UMC, Inc.
> melissah@...
>
> ---------------------------------
> Got a little couch potato?
> Check out fun summer activities for kids.
>
> [Non-text portions of this message have been removed]
>
12
What tables are you pulling in and what are the links between tables?



-----Original Message-----
From: Lynn Thomas 83 [mailto:thomasl@...]
Sent: October 01, 2007 9:06 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?



I didn't actually get them from Judy, but rather from Jim Nalls, who
knows her and contacted her. Got the files installed, per
instructions, this morning, but there's been no noticeable improvement
- after 15 minutes I'm pretty much convinced nothing's going to happen
in a useful time. I've stopped and restarted the app servers, and
even rebooted the machine, but no joy.

As small as my db is, it should return in a matter of seconds, but I'd
be pleased with anything less than 5 minutes.

Pending a reply to my email back to tech support, anyone have any
thoughts on this?

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, melissa
hietala <kevmel822@...> wrote:
>
> if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r
files for BAQ. I got them from support yesterday from Judy Perry. My
wide open report that would get stuck for days now ran in 5 minutes.
If you can't get to Judy on support call me offline and I can send you
the files.
>
> Lynn Thomas 83 <thomasl@...> wrote:
> Is anyone familiar with a problem in running BAQ Report
Designer where
> it just DOESN'T run, or takes hours to return a preview of a report?
> I have a fairly simple query running on a 600 record parts db (we're
> still setting up to implement), so things should only take a few
> seconds. It's a fairly recent problem, so something's changed, but
> darned if I can figure out what...
>
> Help?
>
> Lynn Thomas
> SAIC
>
>
>
>
>
>
> Melissa Hietala
> UMC, Inc.
> melissah@...
>
> ---------------------------------
> Got a little couch potato?
> Check out fun summer activities for kids.
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
13
I'm using Part, PartClass, PartRev, PartPlant, and PlantWhse; with
Part as the parent and each of the others a child, linked via Part
Number, of course. I'm trying to get (besides Crystal practice) a
consolidated look at some of the key fields as we build the Part
master file, and then print that so I can highlight, etc.

There are about 590 total parts, with some of them existing at both of
our plants, but most of them at only one. So I'm looking for less
than 1200 rows returned. I know the query itself is good - I've
analyzed and tested it in BAQ Maintenance.

Thanks!
Lynn

--- In vantage@yahoogroups.com, "vantage" <vantage@...> wrote:
>
> What tables are you pulling in and what are the links between tables?
>
>
>
> -----Original Message-----
> From: Lynn Thomas 83 [mailto:thomasl@...]
> Sent: October 01, 2007 9:06 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?
>
>
>
> I didn't actually get them from Judy, but rather from Jim Nalls, who
> knows her and contacted her. Got the files installed, per
> instructions, this morning, but there's been no noticeable improvement
> - after 15 minutes I'm pretty much convinced nothing's going to happen
> in a useful time. I've stopped and restarted the app servers, and
> even rebooted the machine, but no joy.
>
> As small as my db is, it should return in a matter of seconds, but I'd
> be pleased with anything less than 5 minutes.
>
> Pending a reply to my email back to tech support, anyone have any
> thoughts on this?
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
melissa
> hietala <kevmel822@> wrote:
> >
> > if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r
> files for BAQ. I got them from support yesterday from Judy Perry. My
> wide open report that would get stuck for days now ran in 5 minutes.
> If you can't get to Judy on support call me offline and I can send you
> the files.
> >
> > Lynn Thomas 83 <thomasl@> wrote:
> > Is anyone familiar with a problem in running BAQ Report
> Designer where
> > it just DOESN'T run, or takes hours to return a preview of a report?
> > I have a fairly simple query running on a 600 record parts db (we're
> > still setting up to implement), so things should only take a few
> > seconds. It's a fairly recent problem, so something's changed, but
> > darned if I can figure out what...
> >
> > Help?
> >
> > Lynn Thomas
> > SAIC
> >
> >
> >
> >
> >
> >
> > Melissa Hietala
> > UMC, Inc.
> > melissah@
> >
> > ---------------------------------
> > Got a little couch potato?
> > Check out fun summer activities for kids.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
14
> I'm using Part, PartClass, PartRev, PartPlant, and PlantWhse; with
> Part as the parent and each of the others a child, linked via Part
> Number, of course. I'm trying to get (besides Crystal practice) a
> consolidated look at some of the key fields as we build the Part
> master file, and then print that so I can highlight, etc.

I find that if I start with the table with index fields that restrict the
query the most, I get better performance. For example, we did a BAQ to find
jobs that still have un-issued materials. The first attempt selected on the
JobMatl issued flag. It turns out that it's not an indexed field and the query
had to serially read the entire table. It took about four minutes. We started
over with the JobHead table and first selected only Released jobs that were
not closed (both index fields) and then linked to the JobMatl table and
summarized the records that were not issued complete. It ran in ten seconds.

Generally, the higher up you put your selection criteria, the faster your BAQ
will run.

Mark W.
15
It will have to read the entire table, that's really the point; to let
me look at ALL of my parts in both plants, so I can scrub it before we
go live. But there aren't that many. In BAQ maintenance, where I
design the query, it runs in, actually, about 10 seconds. In BAQ
report designer, it hasn't done anything after 15 minutes. In the
past, it worked fine, too. I'm not at all clear on just what changed,
either. Somehow, I don't think going from 574 parts to 590 is the
real issue.

One of the things baffling me is why it should take so long in Report
Designer when it comes back so fast in query design....

--- In vantage@yahoogroups.com, "Mark Wonsil" <mark_wonsil@...> wrote:
>
> > I'm using Part, PartClass, PartRev, PartPlant, and PlantWhse; with
> > Part as the parent and each of the others a child, linked via Part
> > Number, of course. I'm trying to get (besides Crystal practice) a
> > consolidated look at some of the key fields as we build the Part
> > master file, and then print that so I can highlight, etc.
>
> I find that if I start with the table with index fields that
restrict the query the most, I get better performance. For example, we
did a BAQ to find jobs that still have un-issued materials. The first
attempt selected on the JobMatl issued flag. It turns out that it's
not an indexed field and the query had to serially read the entire
table. It took about four minutes. We started over with the JobHead
table and first selected only Released jobs that were not closed (both
index fields) and then linked to the JobMatl table and summarized the
records that were not issued complete. It ran in ten seconds.
>
> Generally, the higher up you put your selection criteria, the faster
your BAQ will run.
>
> Mark W.
>
16
All the tables need to be linked by Company also



Steve



-----Original Message-----
From: Lynn Thomas 83 [mailto:thomasl@...]
Sent: October 01, 2007 12:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?



I'm using Part, PartClass, PartRev, PartPlant, and PlantWhse; with
Part as the parent and each of the others a child, linked via Part
Number, of course. I'm trying to get (besides Crystal practice) a
consolidated look at some of the key fields as we build the Part
master file, and then print that so I can highlight, etc.

There are about 590 total parts, with some of them existing at both of
our plants, but most of them at only one. So I'm looking for less
than 1200 rows returned. I know the query itself is good - I've
analyzed and tested it in BAQ Maintenance.

Thanks!
Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"vantage" <vantage@...> wrote:
>
> What tables are you pulling in and what are the links between tables?
>
>
>
> -----Original Message-----
> From: Lynn Thomas 83 [mailto:thomasl@...]
> Sent: October 01, 2007 9:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?
>
>
>
> I didn't actually get them from Judy, but rather from Jim Nalls, who
> knows her and contacted her. Got the files installed, per
> instructions, this morning, but there's been no noticeable improvement
> - after 15 minutes I'm pretty much convinced nothing's going to happen
> in a useful time. I've stopped and restarted the app servers, and
> even rebooted the machine, but no joy.
>
> As small as my db is, it should return in a matter of seconds, but I'd
> be pleased with anything less than 5 minutes.
>
> Pending a reply to my email back to tech support, anyone have any
> thoughts on this?
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
melissa
> hietala <kevmel822@> wrote:
> >
> > if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r
> files for BAQ. I got them from support yesterday from Judy Perry. My
> wide open report that would get stuck for days now ran in 5 minutes.
> If you can't get to Judy on support call me offline and I can send you
> the files.
> >
> > Lynn Thomas 83 <thomasl@> wrote:
> > Is anyone familiar with a problem in running BAQ Report
> Designer where
> > it just DOESN'T run, or takes hours to return a preview of a report?
> > I have a fairly simple query running on a 600 record parts db (we're
> > still setting up to implement), so things should only take a few
> > seconds. It's a fairly recent problem, so something's changed, but
> > darned if I can figure out what...
> >
> > Help?
> >
> > Lynn Thomas
> > SAIC
> >
> >
> >
> >
> >
> >
> > Melissa Hietala
> > UMC, Inc.
> > melissah@
> >
> > ---------------------------------
> > Got a little couch potato?
> > Check out fun summer activities for kids.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
17
Are you running this trough a dashboard? I set this up in my data base
patch 305I and it took about 45 seconds to pull in 80,000 records.



Steve



-----Original Message-----
From: Lynn Thomas 83 [mailto:thomasl@...]
Sent: October 01, 2007 12:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?



I'm using Part, PartClass, PartRev, PartPlant, and PlantWhse; with
Part as the parent and each of the others a child, linked via Part
Number, of course. I'm trying to get (besides Crystal practice) a
consolidated look at some of the key fields as we build the Part
master file, and then print that so I can highlight, etc.

There are about 590 total parts, with some of them existing at both of
our plants, but most of them at only one. So I'm looking for less
than 1200 rows returned. I know the query itself is good - I've
analyzed and tested it in BAQ Maintenance.

Thanks!
Lynn

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
"vantage" <vantage@...> wrote:
>
> What tables are you pulling in and what are the links between tables?
>
>
>
> -----Original Message-----
> From: Lynn Thomas 83 [mailto:thomasl@...]
> Sent: October 01, 2007 9:06 AM
> To: vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com
> Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?
>
>
>
> I didn't actually get them from Judy, but rather from Jim Nalls, who
> knows her and contacted her. Got the files installed, per
> instructions, this morning, but there's been no noticeable improvement
> - after 15 minutes I'm pretty much convinced nothing's going to happen
> in a useful time. I've stopped and restarted the app servers, and
> even rebooted the machine, but no joy.
>
> As small as my db is, it should return in a matter of seconds, but I'd
> be pleased with anything less than 5 minutes.
>
> Pending a reply to my email back to tech support, anyone have any
> thoughts on this?
>
> --- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com,
melissa
> hietala <kevmel822@> wrote:
> >
> > if you are on 8.03.305H or 8.03.305I there is a fix. It is 2 new .r
> files for BAQ. I got them from support yesterday from Judy Perry. My
> wide open report that would get stuck for days now ran in 5 minutes.
> If you can't get to Judy on support call me offline and I can send you
> the files.
> >
> > Lynn Thomas 83 <thomasl@> wrote:
> > Is anyone familiar with a problem in running BAQ Report
> Designer where
> > it just DOESN'T run, or takes hours to return a preview of a report?
> > I have a fairly simple query running on a 600 record parts db (we're
> > still setting up to implement), so things should only take a few
> > seconds. It's a fairly recent problem, so something's changed, but
> > darned if I can figure out what...
> >
> > Help?
> >
> > Lynn Thomas
> > SAIC
> >
> >
> >
> >
> >
> >
> > Melissa Hietala
> > UMC, Inc.
> > melissah@
> >
> > ---------------------------------
> > Got a little couch potato?
> > Check out fun summer activities for kids.
> >
> > [Non-text portions of this message have been removed]
> >
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
18
Try adding a filter company = "xx" or Company = "yy"



Steve



-----Original Message-----
From: Lynn Thomas 83 [mailto:thomasl@...]
Sent: October 01, 2007 1:46 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Report Designer at glacial speeds?



It will have to read the entire table, that's really the point; to let
me look at ALL of my parts in both plants, so I can scrub it before we
go live. But there aren't that many. In BAQ maintenance, where I
design the query, it runs in, actually, about 10 seconds. In BAQ
report designer, it hasn't done anything after 15 minutes. In the
past, it worked fine, too. I'm not at all clear on just what changed,
either. Somehow, I don't think going from 574 parts to 590 is the
real issue.

One of the things baffling me is why it should take so long in Report
Designer when it comes back so fast in query design....

--- In vantage@yahoogroups <mailto:vantage%40yahoogroups.com> .com, "Mark
Wonsil" <mark_wonsil@...> wrote:
>
> > I'm using Part, PartClass, PartRev, PartPlant, and PlantWhse; with
> > Part as the parent and each of the others a child, linked via Part
> > Number, of course. I'm trying to get (besides Crystal practice) a
> > consolidated look at some of the key fields as we build the Part
> > master file, and then print that so I can highlight, etc.
>
> I find that if I start with the table with index fields that
restrict the query the most, I get better performance. For example, we
did a BAQ to find jobs that still have un-issued materials. The first
attempt selected on the JobMatl issued flag. It turns out that it's
not an indexed field and the query had to serially read the entire
table. It took about four minutes. We started over with the JobHead
table and first selected only Released jobs that were not closed (both
index fields) and then linked to the JobMatl table and summarized the
records that were not issued complete. It ran in ten seconds.
>
> Generally, the higher up you put your selection criteria, the faster
your BAQ will run.
>
> Mark W.
>





[Non-text portions of this message have been removed]
19
Good afternoon, all!

My AR manager came to me today and pointed out an open cash-receipt
entry entity from early 2005 that cannot be opened, from an "test"
invoice that was created and never disposed of properly. The AR manager
wants to remove the junk invoice, or make an adjustment to the invoice,
but neither option is available apparently because 2005 has already been
closed and we cannot post the cash-receipt.

Any ideas on how we can resolve this?

Thanks in advance.

------------------------------------------------------------------------
Ari Footlik
IT Manager - R. A. Zweig

ari@...
847-730-1532 (direct)
847-832-9001 (main)
847-832-9019 (fax)



[Non-text portions of this message have been removed]
20
You can reopen past periods, but not sure about past years...I would
assume you can as well.







M. Manasa Reddy

manasa@...

P: 630-806-2000

F: 630-806-2001

________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ari Footlik
Sent: Wednesday, October 03, 2007 3:29 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Need to Remove Pending Cash Receipt



Good afternoon, all!

My AR manager came to me today and pointed out an open cash-receipt
entry entity from early 2005 that cannot be opened, from an "test"
invoice that was created and never disposed of properly. The AR manager
wants to remove the junk invoice, or make an adjustment to the invoice,
but neither option is available apparently because 2005 has already been
closed and we cannot post the cash-receipt.

Any ideas on how we can resolve this?

Thanks in advance.

----------------------------------------------------------
Ari Footlik
IT Manager - R. A. Zweig

ari@... <mailto:ari%40zweig-cnc.com>
847-730-1532 (direct)
847-832-9001 (main)
847-832-9019 (fax)


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





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