BAQ Export Process/Dynamic Quesry Export

#ygrps-yiv-886104 P.ygrps-yiv-886104b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-886104 LI.ygrps-yiv-886104b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-886104 DIV.ygrps-yiv-886104b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-886104 TABLE.ygrps-yiv-886104b1e7fd89-0279-4ffe-a16a-1f1bcba0d537Table { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-886104 DIV.ygrps-yiv-886104Section1 { }

Yes the BAQ Export feature was added to

 

DMT 1.0.11.0 for Epicor 9.05.x
DMT 4.0.5.0 for Epicor 10.x

 

Kind Regards,

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: 05 May 2016 20:34
To: vantage@yahoogroups.com
Subject: [Vantage] Re: BAQ Export Process/Dynamic Quesry Export

 

 

Stephen, will these scripts work with E905.701? ( I realize I would have to modify the variables)



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
DDI:  +44 121 314 1179
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

Has anyone run into any trouble with this on a schedule?

Currently on 9.05.701 and trying to run a BAQ on a schedule for 12:01 AM.

The BAQ runs fine when you run the BAQEP "NOW" but if I put it on the schedule to run later, it doesn't work, well it "runs" but when it exports there are "0 Rows"

The BAQ is a simple one that is just running through and showing all "Bin on Hand" numbers.



As a secondary question regarding the setup of a schedule to run specific reports on the "Last Day of the Month" How are people handling it if at all? Right now I have a schedule setup for 12:01AM on the First Day of the Month since "Last Day" is not an option, and I set all the dates on the reports dynamically to "Yesterday" but wasn't sure if there was a better way.

Ned
Crawford Software
I cant speak to the no data issue, we ran lots of scheduled BAQ’s in 700c with no issues, but never ran on 701. To answer your last question, use dynamic option “End of current fiscal Period” Assuming you follow the monthly calendar this should account for differences in number of days in a month.

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...<mailto:rbucek@...>
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 5, 2016 12:00 PM
To: vantage <vantage@yahoogroups.com>
Subject: [Vantage] BAQ Export Process/Dynamic Quesry Export


Has anyone run into any trouble with this on a schedule?

Currently on 9.05.701 and trying to run a BAQ on a schedule for 12:01 AM.

The BAQ runs fine when you run the BAQEP "NOW" but if I put it on the schedule to run later, it doesn't work, well it "runs" but when it exports there are "0 Rows"

The BAQ is a simple one that is just running through and showing all "Bin on Hand" numbers.



As a secondary question regarding the setup of a schedule to run specific reports on the "Last Day of the Month" How are people handling it if at all? Right now I have a schedule setup for 12:01AM on the First Day of the Month since "Last Day" is not an option, and I set all the dates on the reports dynamically to "Yesterday" but wasn't sure if there was a better way.

Ned
Crawford Software



[Non-text portions of this message have been removed]
#ygrps-yiv-1342207976 P.ygrps-yiv-1342207976b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1342207976 LI.ygrps-yiv-1342207976b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1342207976 DIV.ygrps-yiv-1342207976b1e7fd89-0279-4ffe-a16a-1f1bcba0d537 { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1342207976 TABLE.ygrps-yiv-1342207976b1e7fd89-0279-4ffe-a16a-1f1bcba0d537Table { MARGIN:0cm 0cm 0pt;} #ygrps-yiv-1342207976 DIV.ygrps-yiv-1342207976Section1 { }
Never seen that issue but have had issues with the handling of Multiple line descriptions and comments.

You can now use DMT to export BAQs and schedule via windows scheduler it handles the multiline issues.

https://github.com/DotNetIT/EpicorDMTScripts



Sent from my iPhone

On 5 May 2016, at 18:17, Rob Bucek rbucek@... [vantage] <vantage@yahoogroups.com> wrote:

 

I cant speak to the no data issue, we ran lots of scheduled BAQ’s in 700c with no issues, but never ran on 701. To answer your last question, use dynamic option “End of current fiscal Period” Assuming you follow the monthly calendar this should account for differences in number of days in a month.

Rob Bucek
Production Control Manager
D&S Manufacturing
301 E. Main St. | PO Box 279
Black River Falls, WI 54615
715-284-5376 Ext. 311
Mobile: 715-896-3119
rbucek@...<mailto:rbucek@...>
Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, May 5, 2016 12:00 PM
To: vantage <vantage@yahoogroups.com>
Subject: [Vantage] BAQ Export Process/Dynamic Quesry Export


Has anyone run into any trouble with this on a schedule?

Currently on 9.05.701 and trying to run a BAQ on a schedule for 12:01 AM.

The BAQ runs fine when you run the BAQEP "NOW" but if I put it on the schedule to run later, it doesn't work, well it "runs" but when it exports there are "0 Rows"

The BAQ is a simple one that is just running through and showing all "Bin on Hand" numbers.



As a secondary question regarding the setup of a schedule to run specific reports on the "Last Day of the Month" How are people handling it if at all? Right now I have a schedule setup for 12:01AM on the First Day of the Month since "Last Day" is not an option, and I set all the dates on the reports dynamically to "Yesterday" but wasn't sure if there was a better way.

Ned
Crawford Software


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



Stephen Edginton (Beng) | Solutions & Technical Director

Mobile:  +44 7734 858415
DDI:  +44 121 314 1179
Main:  +44 (0) 121 314 1170
Web:  www.dotnetit.co.uk

Dot Net IT Limited, One St Kenelm Court, Steel Park Road, Halesowen, B62 8HD, United Kingdom.

DotNetIT

Epicor Platinum Partner

Epicor Alliance Partner

Stephen, will these scripts work with E905.701? ( I realize I would have to modify the variables)
So, I know the setting is there in the option within the report to select "End of Month" and "End of Fiscal Period", that isn't so much the issue.Â

I was more talking about in the Task Agent when you setup a schedule, there is no way to setup the Schedule to run on the last day of the month. You can pick "Last <insert day of week>" but not the actual last day.

I know I could go in and change it every month to run on the number, we need to make this something that just exists in perpetuity without needing an adjustment every month.

Unless there is a unknown logic where if we set it to "every 31" it will run on 2/29 or 6/30 if the month has fewer than 31 days.

On Thu, May 5, 2016 at 1:16 PM, Rob Bucek rbucek@... [vantage] <vantage@yahoogroups.com> wrote:
I cant speak to the no data issue, we ran lots of scheduled BAQ’s in 700c with no issues, but never ran on 701. To answer your last question, use dynamic option “End of current fiscal Period” Assuming you follow the monthly calendar this should account for differences in number of days in a month.



Rob Bucek

Production Control Manager

D&S Manufacturing

301 E. Main St. | PO Box 279

Black River Falls, WI 54615

715-284-5376 Ext. 311

Mobile: 715-896-3119

rbucek@...<mailto:rbucek@...>

Visit our newly redesigned Website at www.dsmfg.com<http://www.dsmfg.com/>



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]

Sent: Thursday, May 5, 2016 12:00 PM

To: vantage <vantage@yahoogroups.com>

Subject: [Vantage] BAQ Export Process/Dynamic Quesry Export





Has anyone run into any trouble with this on a schedule?



Currently on 9.05.701 and trying to run a BAQ on a schedule for 12:01 AM.



The BAQ runs fine when you run the BAQEP "NOW" but if I put it on the schedule to run later, it doesn't work, well it "runs" but when it exports there are "0 Rows"



The BAQ is a simple one that is just running through and showing all "Bin on Hand" numbers.







As a secondary question regarding the setup of a schedule to run specific reports on the "Last Day of the Month" How are people handling it if at all? Right now I have a schedule setup for 12:01AM on the First Day of the Month since "Last Day" is not an option, and I set all the dates on the reports dynamically to "Yesterday" but wasn't sure if there was a better way.



Ned

Crawford Software





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



------------------------------------
Posted by: Rob Bucek <RBucek@...>
------------------------------------

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

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

<*> Your email settings:
  Individual Email | Traditional

<*> To change settings online go to:
  http://groups.yahoo.com/group/vantage/join
  (Yahoo! ID required)

<*> To change settings via email:
  vantage-digest@yahoogroups.com
  vantage-fullfeatured@yahoogroups.com

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

<*> Your use of Yahoo Groups is subject to:
  https://info.yahoo.com/legal/us/yahoo/utos/terms/