Sitemap

Amicuk Programming Answers

Alert msg when add new po order

-0001-11-30   Views:0

Advertisement

i want alert message when i will add new po order. how can i do it? i have written trigger after insert , but it's not working.Firstly, You are not suppose to use triggers with SBO. You will have to create a query and attach it to an Alert.  How ofte

i want alert message when i will add new po order.
how can i do it?
i have written trigger after insert , but it's not working.

The replay answer
Advertisement
Firstly, You are not suppose to use triggers with SBO.
You will have to create a query and attach it to an Alert.  How often you want the alert to go off can be set in the Alerts Management Window.
A simple Query to give you DocNum, DocDate, CardCode for PO's created in that day would be
SELECT T0.DocNum, T0.DocDate, T0.CardCode FROM  [dbo].[OPOR] T0 WHERE DATEDIFF(DAY,T0.CreateDate, GETDATE()) = 0
Save this Query.  Then Go to Administration -> Alerts Management --- Open Saved Query and select this query,  Click Active and select the user and check the Int checkbox to send an alert through SBO's internal messaging.  You may set the frequency as desired.
If you are using a flag to mark the PO as read / alert received then this flag can be added in the Where Clause of the Query so that the same PO's don't alert repeatedly.
It all depends on your business need.
Let me know if you need further assistance
Suda

Go to See the other 9 answers

Alert msg when add new po order

Category:DefaultRelease time:-0001-11-30Views:130

i want alert message when i will add new po order. how can i do it? i have written trigger after insert , but it's not working.Firstly, You are not suppose to use triggers with SBO. You will have to create a query and attach it to an Alert.  How ofte[More]

How to add a specific order type into any particular report

Category:DefaultRelease time:2015-10-11Views:130

Hi All, How to add a specific document type(order type) into any particular report in order to review OTD performance. I need to add one specific order type to existing reports which will help to check the performance of the delivery type for that pa[More]

What is vat where we add in sales order

Category:DefaultRelease time:2015-10-11Views:130

hi gurus what is vat how we add in sales order if we do for cin what are the steps is it order, delivery invoice, excise invoice va01,vl01n,vt01n,vf01, j1,IIn, is it correct or not thanks in advanncedear nag VAT is value added tax if you want steps f[More]

Add in purchase order by B1WS

Category:DefaultRelease time:-0001-11-30Views:130

I m facing error "command not found" on add in purchase order using B1WS.What mendatory data should send using B1WS for add in purchase order?There is no function/BAPI to configure a Purchase order item. Your best bet would be to do a recording[More]

Message alert when Invoice date preceds Purchase order date

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I want to define message alert, when Invoice date precedes Purchase order date. Is there any standard message type is there, If yes please let me know. Otherwise how can i define this, please. Thanks CS..Hi, You can take help of your abbaper[More]

How to add my own order of songs to my iphone

Category:DefaultRelease time:-0001-11-30Views:130

How to add my own order of songs to my iphoneCreate a Playlist either from iTunes or your devices basing on your own preference of order.Read other 2 answers[More]

Variable in alert msg

Category:DefaultRelease time:-0001-11-30Views:130

hi friends i want to show value of a globle variable in alert msg is it posible if yes then how can i attach a variable with alert msg plz tell me in detail take care byeFor forms 9 you should first create an Alert in your form. We'll call it Alert '[More]

Alert generation from Add-On

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Can anybody explain me how can I use Alert in my Add-On. I mean I have an user-defined table T1 and a filed F1. An Alert will be sent to an user if value of F1 exceeds 50. If I generate an Alert with the Saved Query in Alert Management, then what[More]

How do I add scripts in order to make the page compatible with all the browsers.

Category:DefaultRelease time:-0001-11-30Views:130

How do I add scripts in order to make the page compatible with all the browsers.As Jon says, please be more specific about "don't line up right" I notice you are inserting some arbitrary <BR> tags which will cause very unpredictable displa[More]

Removing alert box in Add to Cart

Category:DefaultRelease time:-0001-11-30Views:130

Hi, I really need your help on how to remove the add to cart alert box. I thought using window.alert=function(msg){}  would help but it removes all the other alert boxes in the site. Thank you.I wouldn't remove the alerts all together, just display t[More]

Alert message(Query) for a Production order?

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I want to get an alert message for the production order doucument based on the due date of it. The user must get the alert a  one day before the duedate of the document. How to write the Query for it? Urgent ,waiting for earliest reply. R[More]

Hot
After moving my iPhoto Library folder to a different external HD, I've found that half the photos were no longer in the library. The second time I ran iPhoto, the number went DOWN. I thought the problem might be on the drive, but drive repair says no [More]
Hi, I have a need to search within a text field in SQL Server 2000. In the limitations section it notes that this is not possible. Is there a recommended workaround for this in terms of performance? I have no way of knowing the length of the text fie [More]
Does anyone know if this is possible? I playback preview files (mov,dv, etc) on quicktime pro all the time, and it would be helpful if I could view them on my plasma via my firewire port (the same way I do in Logic or Pro Tools).I don't 100% understa [More]
I want to put my Java Applet game on my homepage. But the server which I set up my homepage doesn't support the file name like XXX$XXX.class, which has '$' sign in the file name. Would anyone can tell me how to deal with this problem? And how can I m [More]
Two issues when playing audio files via a web browser (tried with Chrome and IE8): If I use wmode=transparent the control buttons are not shown, only the progress bar. When I removed wmode=transparent it worked fine. Is this correct behavior? Some br [More]
Here is my situation. I have a program that draws pictures which represent real things. There is a database underneath. The pictures represent things and I need to use the database to discern a lot of the info. I split the logic database tables from [More]
Is this possible? Cause I'm getting a WSDL Exception that the oracle.sql.BLOB is not a java bean. So how do I make it a java bean? What data type should I use?here is the object that was created. import java.io.Serializable; public class DiagramsObj [More]
Hi,      Can anyone please tell me the steps to load data from SAP BW standard table to master data text? How should the data source be created? Thanks in advance.Hi aparajith, Have you loaded the master data attr ? ECC Steps then load the attr text [More]
Hello! I currently have about 30 folders inside the Album section of my iPhoto that I would like to alphabetize so there's some organization.  I haven't been able to find anything of any use online.  Does anyone know how to rearrange the folders so t [More]
Hi Guys Does anyone know how to reassign clients to another management point on the same site. We have 3 seperate locations connected by a vpn, our main site has a primary site server with the management point role and the other 2 locations are just [More]