Auto-run a query

Yahoo Archive
1
Maybe a bit late to this, but you can also create a progress script that
can be run from the windows scheduler that could aggregate your data and
put it into a UD table to pick up at any time. Exporting will give you
historical access, but not an easy method if you need to look at values
over time. If you have the script throw the data into a UD table then
you can index it accordingly and allow the user to pick it up with a BAQ
report whenever they see fit.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Karen Schoenung
Sent: Monday, January 28, 2013 8:38 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Auto-run a query





You use the BAQ export function (under Utilities) and instead of now,
choose an option under the drop down list of an already defined schedule
(if you have some set up)

-----Original Message-----
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf Of John Kreger
Sent: Monday, January 28, 2013 7:19 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: Re: [Vantage] Auto-run a query

Karen,
It's actually just a snapshot of some stock levels for items. It doesn't
do any calculations just gives him a snapshot of the system at that
time. I just don't know how to schedule a BAQ to run and export a csv or
spreadsheet...

Thanks,

John

On Mon, Jan 28, 2013 at 7:10 PM, Karen Schoenung <
kschoenung@... <mailto:kschoenung%40fisher-barton.com> >
wrote:

> **
>
>
> I am not sure what data it is pulling, but can he run it on the 1st at
> 12:05 am for transactions < today?
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
> Behalf Of lilj8069
> Sent: Monday, January 28, 2013 6:57 PM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Auto-run a query
>
>
> We have a BAQ that our CFO would like to auto-run every month at
> 11:59pm on the last night of the month. Is there an easy way to do
this?
>
> Thanks,
> John Kreger
>
> [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/.
<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/linksYahoo! Groups Links





[Non-text portions of this message have been removed]
2
We have a BAQ that our CFO would like to auto-run every month at 11:59pm on the last night of the month. Is there an easy way to do this?

Thanks,
John Kreger
3
I am not sure what data it is pulling, but can he run it on the 1st at 12:05 am for transactions < today?

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of lilj8069
Sent: Monday, January 28, 2013 6:57 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Auto-run a query



We have a BAQ that our CFO would like to auto-run every month at 11:59pm on the last night of the month. Is there an easy way to do this?

Thanks,
John Kreger



[Non-text portions of this message have been removed]
4
Karen,
It's actually just a snapshot of some stock levels for items. It doesn't do
any calculations just gives him a snapshot of the system at that time. I
just don't know how to schedule a BAQ to run and export a csv or
spreadsheet...

Thanks,

John


On Mon, Jan 28, 2013 at 7:10 PM, Karen Schoenung <
kschoenung@...> wrote:

> **
>
>
> I am not sure what data it is pulling, but can he run it on the 1st at
> 12:05 am for transactions < today?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of lilj8069
> Sent: Monday, January 28, 2013 6:57 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Auto-run a query
>
>
> We have a BAQ that our CFO would like to auto-run every month at 11:59pm
> on the last night of the month. Is there an easy way to do this?
>
> Thanks,
> John Kreger
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
5
Make a Quick Crystal Report and have it auto schedule.


*Jose C Gomez*
*Software Engineer*
*
*
*
*T: 904.469.1524 mobile
E: jose@...
http://www.josecgomez.com
<http://www.linkedin.com/in/josecgomez> <http://www.facebook.com/josegomez>
<http://www.google.com/profiles/jose.gomez> <http://www.twitter.com/joc85>
<http://www.josecgomez.com/professional-resume/>
<http://www.josecgomez.com/feed/>
<http://www.usdoingstuff.com>

*Quis custodiet ipsos custodes?*


On Mon, Jan 28, 2013 at 8:19 PM, John Kreger <lilj8069@...> wrote:

> Karen,
> It's actually just a snapshot of some stock levels for items. It doesn't do
> any calculations just gives him a snapshot of the system at that time. I
> just don't know how to schedule a BAQ to run and export a csv or
> spreadsheet...
>
> Thanks,
>
> John
>
>
> On Mon, Jan 28, 2013 at 7:10 PM, Karen Schoenung <
> kschoenung@...> wrote:
>
> > **
> >
> >
> > I am not sure what data it is pulling, but can he run it on the 1st at
> > 12:05 am for transactions < today?
> >
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> > Of lilj8069
> > Sent: Monday, January 28, 2013 6:57 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Auto-run a query
> >
> >
> > We have a BAQ that our CFO would like to auto-run every month at 11:59pm
> > on the last night of the month. Is there an easy way to do this?
> >
> > Thanks,
> > John Kreger
> >
> > [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/linksYahoo! Groups Links
>
>
>
>


[Non-text portions of this message have been removed]
6
You use the BAQ export function (under Utilities) and instead of now, choose an option under the drop down list of an already defined schedule (if you have some set up)

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of John Kreger
Sent: Monday, January 28, 2013 7:19 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Auto-run a query

Karen,
It's actually just a snapshot of some stock levels for items. It doesn't do any calculations just gives him a snapshot of the system at that time. I just don't know how to schedule a BAQ to run and export a csv or spreadsheet...

Thanks,

John


On Mon, Jan 28, 2013 at 7:10 PM, Karen Schoenung < kschoenung@...> wrote:

> **
>
>
> I am not sure what data it is pulling, but can he run it on the 1st at
> 12:05 am for transactions < today?
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of lilj8069
> Sent: Monday, January 28, 2013 6:57 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Auto-run a query
>
>
> We have a BAQ that our CFO would like to auto-run every month at
> 11:59pm on the last night of the month. Is there an easy way to do this?
>
> Thanks,
> John Kreger
>
> [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/linksYahoo! Groups Links
7
Is this in Epicor 9? In Epicor 9 you can run the Business Activity Query
Export process that will run the BAQ and put it in a folder as a .CSV
file or a .PDF.

Not sure if this is in Vantage, been too long since I've seen those
screens.



Regards,



Chris Wineinger

ERP Specialist

Interior Systems, Inc. <http://www.isiamerica.com/>

241 N Broadway Ste 600

Milwaukee, WI 53202

Office # 414.224.0957 X2051

Direct# 414.847.0701

Cell # 414.840.6594





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