Request for basic Help

Yahoo Archive
1
Thanks so much for the help. I truly appreciate everything. With a little patience I will get this.

Thanks again

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



[Non-text portions of this message have been removed]
2
Hi all,

For all you really smart people out there this is a simple question.

Im trying to set-up a BPM that when a needbydate on a Sales Order has changed an e-mail would go out displaying pertinent info. I think im to use a pre-processing then look for changes on the ordered,orderdtl,orderrel tables
But what is throwing me is do I use a condition that if the updated table Needbydate has changed from ? to ? then email. It's the condition that im unsure of. Or is it a custom code. Coding is, unfortunately, my weak point.

Thank

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



[Non-text portions of this message have been removed]
3
I believe a BAM not a BPM is the way to go with this, you can monitor that
field and have an email sent when it changes.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Trzaska, Mark
Sent: Wednesday, May 01, 2013 11:02 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Request for basic Help

Hi all,

For all you really smart people out there this is a simple question.

Im trying to set-up a BPM that when a needbydate on a Sales Order has
changed an e-mail would go out displaying pertinent info. I think im to use
a pre-processing then look for changes on the ordered,orderdtl,orderrel
tables But what is throwing me is do I use a condition that if the updated
table Needbydate has changed from ? to ? then email. It's the condition that
im unsure of. Or is it a custom code. Coding is, unfortunately, my weak
point.

Thank

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



[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
4
There is a BAM example I made for OrderRel in the file section under BAM folder.

The link below has the basics of how to add the .p procedure to a BAM. I used it when I first started using BAM custom emails.

http://f1.grp.yahoofs.com/v1/1FiBUdVcmahNmtCh_R3mI0-z03nhmnNlpxW3_qJoqwjPzw9qyT2xC1zZSNEotCef4lC5NDTo1fW_C_FZeX4Yp5aCjzcFiseBXMkCMwRDbpqr6hd9/BAM_Alert_OrderRel_DropShip.zip
If you use the release need by then you can reference the partnum, etc to make the email complete.

Let me know if you have any specific coding questions.

Greg Payne


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
Sent: Wednesday, May 01, 2013 1:19 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Request for basic Help



I believe a BAM not a BPM is the way to go with this, you can monitor that
field and have an email sent when it changes.

-----Original Message-----
From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
Trzaska, Mark
Sent: Wednesday, May 01, 2013 11:02 AM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for basic Help

Hi all,

For all you really smart people out there this is a simple question.

Im trying to set-up a BPM that when a needbydate on a Sales Order has
changed an e-mail would go out displaying pertinent info. I think im to use
a pre-processing then look for changes on the ordered,orderdtl,orderrel
tables But what is throwing me is do I use a condition that if the updated
table Needbydate has changed from ? to ? then email. It's the condition that
im unsure of. Or is it a custom code. Coding is, unfortunately, my weak
point.

Thank

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

[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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
5
You can do it without code.

Only looked at it without trying it, but if you add a post process on the update of Sales Order. As the condition select "Method changed the specific field of the designed query from any to any". If you design the query - just add the table you want to check and select the field you wish to check. Leave the any to any as it is.

In the action section select send an email based on template.

Regards

Martin Horton
Business Systems Manager
Broadcrown Ltd


From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: 01 May 2013 16:02
To: vantage@yahoogroups.com
Subject: [Vantage] Request for basic Help



Hi all,

For all you really smart people out there this is a simple question.

Im trying to set-up a BPM that when a needbydate on a Sales Order has changed an e-mail would go out displaying pertinent info. I think im to use a pre-processing then look for changes on the ordered,orderdtl,orderrel tables
But what is throwing me is do I use a condition that if the updated table Needbydate has changed from ? to ? then email. It's the condition that im unsure of. Or is it a custom code. Coding is, unfortunately, my weak point.

Thank

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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


Broadcrown Ltd. Airfield Industrial Estate, Hixon, Stafford, Staffs ST18 0PF, England
tel: +44(0)1889 272200 fax: +44(0)1889 272220 www.broadcrown.com

----- This email and the information it contains is confidential and may be legally privileged. It may be read, copied and used only by the intended recipient. Internet communications cannot be guaranteed to be secure or indeed error free as information can be intercepted, corrupted, lost, destroyed, delayed and or contain viruses. Broadcrown Ltd has scanned the email for viruses but does not accept responsibility once the email has been transmitted. The receiving company should scan the email and attachments (if any) for viruses. Any views or opinions expressed within this email are not necessarily the views or opinions of Broadcrown Limited except where the sender specifically states that they are. If you have received this document in error please email the sender and delete the message from your computer without taking copies -----

[Non-text portions of this message have been removed]
6
Does anybody have a BPM that notifies a changed date ? I know there is a field in order detail that shows when an order is changed. (OrderDtl.ChangeDate)

Sent from my iPhone

On May 1, 2013, at 6:13 PM, "Martin Horton" <mhorton@...<mailto:mhorton@...>> wrote:



You can do it without code.

Only looked at it without trying it, but if you add a post process on the update of Sales Order. As the condition select "Method changed the specific field of the designed query from any to any". If you design the query - just add the table you want to check and select the field you wish to check. Leave the any to any as it is.

In the action section select send an email based on template.

Regards

Martin Horton
Business Systems Manager
Broadcrown Ltd

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Trzaska, Mark
Sent: 01 May 2013 16:02
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Request for basic Help

Hi all,

For all you really smart people out there this is a simple question.

Im trying to set-up a BPM that when a needbydate on a Sales Order has changed an e-mail would go out displaying pertinent info. I think im to use a pre-processing then look for changes on the ordered,orderdtl,orderrel tables
But what is throwing me is do I use a condition that if the updated table Needbydate has changed from ? to ? then email. It's the condition that im unsure of. Or is it a custom code. Coding is, unfortunately, my weak point.

Thank

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska%40StanleyMachining.com<http://40StanleyMachining.com>><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska%40StanleyMachining.com<http://40StanleyMachining.com>>>

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

Broadcrown Ltd. Airfield Industrial Estate, Hixon, Stafford, Staffs ST18 0PF, England
tel: +44(0)1889 272200 fax: +44(0)1889 272220 www.broadcrown.com<http://www.broadcrown.com>

----- This email and the information it contains is confidential and may be legally privileged. It may be read, copied and used only by the intended recipient. Internet communications cannot be guaranteed to be secure or indeed error free as information can be intercepted, corrupted, lost, destroyed, delayed and or contain viruses. Broadcrown Ltd has scanned the email for viruses but does not accept responsibility once the email has been transmitted. The receiving company should scan the email and attachments (if any) for viruses. Any views or opinions expressed within this email are not necessarily the views or opinions of Broadcrown Limited except where the sender specifically states that they are. If you have received this document in error please email the sender and delete the message from your computer without taking copies -----

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





[Non-text portions of this message have been removed]
7
Where on the server is the best or customary place to put these .p files?

Thanks,
Bob Beaghan

--- In vantage@yahoogroups.com, Greg Payne <gpayne@...> wrote:
>
> There is a BAM example I made for OrderRel in the file section under BAM folder.
>
> The link below has the basics of how to add the .p procedure to a BAM. I used it when I first started using BAM custom emails.
>
> http://f1.grp.yahoofs.com/v1/1FiBUdVcmahNmtCh_R3mI0-z03nhmnNlpxW3_qJoqwjPzw9qyT2xC1zZSNEotCef4lC5NDTo1fW_C_FZeX4Yp5aCjzcFiseBXMkCMwRDbpqr6hd9/BAM_Alert_OrderRel_DropShip.zip
> If you use the release need by then you can reference the partnum, etc to make the email complete.
>
> Let me know if you have any specific coding questions.
>
> Greg Payne
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ned
> Sent: Wednesday, May 01, 2013 1:19 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Request for basic Help
>
>
>
> I believe a BAM not a BPM is the way to go with this, you can monitor that
> field and have an email sent when it changes.
>
> -----Original Message-----
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of
> Trzaska, Mark
> Sent: Wednesday, May 01, 2013 11:02 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Request for basic Help
>
> Hi all,
>
> For all you really smart people out there this is a simple question.
>
> Im trying to set-up a BPM that when a needbydate on a Sales Order has
> changed an e-mail would go out displaying pertinent info. I think im to use
> a pre-processing then look for changes on the ordered,orderdtl,orderrel
> tables But what is throwing me is do I use a condition that if the updated
> table Needbydate has changed from ? to ? then email. It's the condition that
> im unsure of. Or is it a custom code. Coding is, unfortunately, my weak
> point.
>
> Thank
>
> Mark Trzaska
> Administrator
> Stanley Machining & Tool Corp.
> 425 Maple Avenue
> Carpentersville, IL 60110
> Phone (847) 426-4560
> Fax (847) 426-6951
> e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>
>
> [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
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>
8
\\svr\Epicor905\Server\ud<file:///\\svr\Epicor905\Server\ud> or a sub directory is where the bam expects them. I have a dev sub directory to isolate changes to current BAMs.

It is explained in the zip file link.

Greg

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of robertbeaghan
Sent: Thursday, May 02, 2013 9:41 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Request for basic Help



Where on the server is the best or customary place to put these .p files?

Thanks,
Bob Beaghan

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, Greg Payne <gpayne@...<mailto:gpayne@...>> wrote:
>
> There is a BAM example I made for OrderRel in the file section under BAM folder.
>
> The link below has the basics of how to add the .p procedure to a BAM. I used it when I first started using BAM custom emails.
>
> http://f1.grp.yahoofs.com/v1/1FiBUdVcmahNmtCh_R3mI0-z03nhmnNlpxW3_qJoqwjPzw9qyT2xC1zZSNEotCef4lC5NDTo1fW_C_FZeX4Yp5aCjzcFiseBXMkCMwRDbpqr6hd9/BAM_Alert_OrderRel_DropShip.zip
> If you use the release need by then you can reference the partnum, etc to make the email complete.
>
> Let me know if you have any specific coding questions.
>
> Greg Payne
>
>
> From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Ned
> Sent: Wednesday, May 01, 2013 1:19 PM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
> Subject: RE: [Vantage] Request for basic Help
>
>
>
> I believe a BAM not a BPM is the way to go with this, you can monitor that
> field and have an email sent when it changes.
>
> -----Original Message-----
> 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
> Trzaska, Mark
> Sent: Wednesday, May 01, 2013 11:02 AM
> To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Request for basic Help
>
> Hi all,
>
> For all you really smart people out there this is a simple question.
>
> Im trying to set-up a BPM that when a needbydate on a Sales Order has
> changed an e-mail would go out displaying pertinent info. I think im to use
> a pre-processing then look for changes on the ordered,orderdtl,orderrel
> tables But what is throwing me is do I use a condition that if the updated
> table Needbydate has changed from ? to ? then email. It's the condition that
> im unsure of. Or is it a custom code. Coding is, unfortunately, my weak
> point.
>
> Thank
>
> Mark Trzaska
> Administrator
> Stanley Machining & Tool Corp.
> 425 Maple Avenue
> Carpentersville, IL 60110
> Phone (847) 426-4560
> Fax (847) 426-6951
> e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com<mailto:Mtrzaska@...%3cmailto:Mtrzaska%40StanleyMachining.com%3e%3cmailto:Mtrzaska@...%3cmailto:Mtrzaska%40StanleyMachining.com>>>
>
> [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/>
> (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
>
>
> ________________________________
> CONFIDENTIALITY NOTICE
>
> The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
>
> "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
>
>
> [Non-text portions of this message have been removed]
>


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
9
Bob asks:
>
> Where on the server is the best or customary place to put these .p files?
>

We put them under <epicor_folder>\server\ud\{company}

for example:

D:\Program Files\Epicor\Epicor905\server\ud\UFM

or

D:\Program Files\Epicor\Epicor905\server\ud\TEST

Make sure to keep a backup of this folder just in case an upgrade
wipes it out!!!

Mark W.
10
That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska@...>



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

This is the simplest way to approach.


1. Create a new BAM on OrderRel, save it.

2. From available fields find NeedByDate and select it. ( screen 1)

3. In Action Click Send Alert. I would also do create log as it is good info for research.

4. Add your email in the To or CC box. ( screen 2 )

5. Make sure that Global Alerts Email Process is set to run at startup

6. Change a date on an order and you should get a generic alert. ( If there are errors they will be in the server log. Email errors show in the global alert messages error log )


7. Now add alert program attached into you \\server\Epicor905\server\ud<file:///\\server\Epicor905\server\ud> directory



8. Set the alert program to the same path and name ( screen 3)



9. Test again and you should get a formatted email. You can open the .p program in an editor and change the content, from, to, etc.



Good Luck

Greg Payne



Screen 1
[cid:image002.jpg@01CE4763.6F898160]

Screen 2
[cid:image004.jpg@01CE4763.6F898160]
[cid:image009.jpg@01CE4763.6F898160]





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Request for basic Help



That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
12
Thanx a million. I will keep you posted on results

Sent from my Windows Phone
________________________________
From: Greg Payne<mailto:GPayne@...>
Sent: �5/�2/�2013 5:31 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Cc: Trzaska, Mark<mailto:mtrzaska@...>
Subject: RE: Re: Request for basic Help

Mark:

This is the simplest way to approach.


1. Create a new BAM on OrderRel, save it.

2. From available fields find NeedByDate and select it. ( screen 1)

3. In Action Click Send Alert. I would also do create log as it is good info for research.

4. Add your email in the To or CC box. ( screen 2 )

5. Make sure that Global Alerts Email Process is set to run at startup

6. Change a date on an order and you should get a generic alert. ( If there are errors they will be in the server log. Email errors show in the global alert messages error log )


7. Now add alert program attached into you \\server\Epicor905\server\ud<file:///\\server\Epicor905\server\ud> directory



8. Set the alert program to the same path and name ( screen 3)



9. Test again and you should get a formatted email. You can open the .p program in an editor and change the content, from, to, etc.



Good Luck

Greg Payne



Screen 1
[cid:image002.jpg@01CE4763.6F898160]

Screen 2
[cid:image004.jpg@01CE4763.6F898160]
[cid:image009.jpg@01CE4763.6F898160]





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Request for basic Help



That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
13
Thanx again
What I liked about bpm was I can design a template with pertinent order info. Can I do that with bam. Or like u said its very generic

Sent from my Windows Phone
________________________________
From: Greg Payne<mailto:GPayne@...>
Sent: �5/�2/�2013 5:31 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Cc: Trzaska, Mark<mailto:mtrzaska@...>
Subject: RE: Re: Request for basic Help

Mark:

This is the simplest way to approach.


1. Create a new BAM on OrderRel, save it.

2. From available fields find NeedByDate and select it. ( screen 1)

3. In Action Click Send Alert. I would also do create log as it is good info for research.

4. Add your email in the To or CC box. ( screen 2 )

5. Make sure that Global Alerts Email Process is set to run at startup

6. Change a date on an order and you should get a generic alert. ( If there are errors they will be in the server log. Email errors show in the global alert messages error log )


7. Now add alert program attached into you \\server\Epicor905\server\ud<file:///\\server\Epicor905\server\ud> directory



8. Set the alert program to the same path and name ( screen 3)



9. Test again and you should get a formatted email. You can open the .p program in an editor and change the content, from, to, etc.



Good Luck

Greg Payne



Screen 1
[cid:image002.jpg@01CE4763.6F898160]

Screen 2
[cid:image004.jpg@01CE4763.6F898160]
[cid:image009.jpg@01CE4763.6F898160]





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Request for basic Help



That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
14
Once you get the .p procedure running, then you can do any ABL code that you want on any table in the system. I left some of the formatting in the procedure commented out, since it all has to be converted to string for the body of the email. the ~n are new line and the ~t are tabs.

I had the old date and new date in the email as an example of referencing any of the before saved data as OLDtablename IE OLDOrderDtl.Neededbydate would be the previous date.

Greg

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 10:02 PM
To: Greg Payne; vantage@yahoogroups.com
Subject: [Vantage] RE: Request for basic Help

Thanx again
What I liked about bpm was I can design a template with pertinent order info. Can I do that with bam. Or like u said its very generic

Sent from my Windows Phone
________________________________
From: Greg Payne<mailto:GPayne@...>
Sent: ý5/ý2/ý2013 5:31 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Cc: Trzaska, Mark<mailto:mtrzaska@...>
Subject: RE: Re: Request for basic Help

Mark:

This is the simplest way to approach.


1. Create a new BAM on OrderRel, save it.

2. From available fields find NeedByDate and select it. ( screen 1)

3. In Action Click Send Alert. I would also do create log as it is good info for research.

4. Add your email in the To or CC box. ( screen 2 )

5. Make sure that Global Alerts Email Process is set to run at startup

6. Change a date on an order and you should get a generic alert. ( If there are errors they will be in the server log. Email errors show in the global alert messages error log )


7. Now add alert program attached into you \\server\Epicor905\server\ud<file:///\\server\Epicor905\server\ud> directory



8. Set the alert program to the same path and name ( screen 3)



9. Test again and you should get a formatted email. You can open the .p program in an editor and change the content, from, to, etc.



Good Luck

Greg Payne



Screen 1
[cid:image002.jpg@01CE4763.6F898160]

Screen 2
[cid:image004.jpg@01CE4763.6F898160]
[cid:image009.jpg@01CE4763.6F898160]





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 3:24 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Request for basic Help



That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[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




CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
15
Quick question. If I want to make it customer specific. Is that involve rewriting the .p code or modifying the bam.

Thanx again for all the help.

Regards,
Mark Trzaska


From: Greg Payne [mailto:GPayne@...]
Sent: Thursday, May 02, 2013 5:33 PM
To: vantage@yahoogroups.com
Cc: Trzaska, Mark
Subject: RE: Re: Request for basic Help

Mark:

This is the simplest way to approach.


1. Create a new BAM on OrderRel, save it.

2. From available fields find NeedByDate and select it. ( screen 1)

3. In Action Click Send Alert. I would also do create log as it is good info for research.

4. Add your email in the To or CC box. ( screen 2 )

5. Make sure that Global Alerts Email Process is set to run at startup

6. Change a date on an order and you should get a generic alert. ( If there are errors they will be in the server log. Email errors show in the global alert messages error log )


7. Now add alert program attached into you \\server\Epicor905\server\ud<file:///\\server\Epicor905\server\ud> directory



8. Set the alert program to the same path and name ( screen 3)



9. Test again and you should get a formatted email. You can open the .p program in an editor and change the content, from, to, etc.



Good Luck

Greg Payne



Screen 1
[cid:image001.jpg@...5E3380]

Screen 2
[cid:image002.jpg@...5E3380]
[cid:image003.jpg@...5E3380]





From: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com> [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 3:24 PM
To: vantage@yahoogroups.com<mailto:vantage@yahoogroups.com>
Subject: [Vantage] Re: Request for basic Help



That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com>>

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


[Non-text portions of this message have been removed]
16
Customer ID is on the Order Header, so you can't set a rule to filter. add a condition in the .p to set sendemail = true when it is a customer you want an alert on.

You can also do an INDEX clause for a list of customers

Add after Find OrderHed - Find first Customer where Orderhed.custnum = Customer.Custnum no-lock.

Change
assign SendEmail = true.

to

If Customer.CustID = "XXX" then
assign SendEmail = true.

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Trzaska, Mark
Sent: Friday, May 03, 2013 5:09 PM
To: Greg Payne; vantage@yahoogroups.com
Subject: [Vantage] RE: Re: Request for basic Help



Quick question. If I want to make it customer specific. Is that involve rewriting the .p code or modifying the bam.

Thanx again for all the help.

Regards,
Mark Trzaska

From: Greg Payne [mailto:GPayne@...<mailto:GPayne%40compulink-usa.com>]
Sent: Thursday, May 02, 2013 5:33 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>
Cc: Trzaska, Mark
Subject: RE: Re: Request for basic Help

Mark:

This is the simplest way to approach.

1. Create a new BAM on OrderRel, save it.

2. From available fields find NeedByDate and select it. ( screen 1)

3. In Action Click Send Alert. I would also do create log as it is good info for research.

4. Add your email in the To or CC box. ( screen 2 )

5. Make sure that Global Alerts Email Process is set to run at startup

6. Change a date on an order and you should get a generic alert. ( If there are errors they will be in the server log. Email errors show in the global alert messages error log )

7. Now add alert program attached into you \\server\Epicor905\server\ud<file:///<file:///\\>\\server\Epicor905\server\ud> directory

8. Set the alert program to the same path and name ( screen 3)

9. Test again and you should get a formatted email. You can open the .p program in an editor and change the content, from, to, etc.

Good Luck

Greg Payne

Screen 1
[cid:image001.jpg@...5E3380<mailto:image001.jpg%4001CE4816.EC5E3380>]

Screen 2
[cid:image002.jpg@...5E3380<mailto:image002.jpg%4001CE4816.EC5E3380>]
[cid:image003.jpg@...5E3380<mailto:image003.jpg%4001CE4816.EC5E3380>]

From: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>> [mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>] On Behalf Of Trzaska, Mark
Sent: Thursday, May 02, 2013 3:24 PM
To: vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com><mailto:vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>>
Subject: [Vantage] Re: Request for basic Help

That's the problem. Im just starting query's in vantage and have never really made ont. I do see the condition your speaking of.
I guess what im asking for is what would the actual query be. (when you click on "designed" and the query box shows up).
I really do appreciate any help with this. As I am drowning in other work.

Regards

Mark Trzaska
Administrator
Stanley Machining & Tool Corp.
425 Maple Avenue
Carpentersville, IL 60110
Phone (847) 426-4560
Fax (847) 426-6951
e-mail Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska@...<mailto:Mtrzaska%40StanleyMachining.com><mailto:Mtrzaska%40StanleyMachining.com>>

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

________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."

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


________________________________
CONFIDENTIALITY NOTICE

The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.

"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."


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