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
Hello, we have a follow problem: We transfer some big files manually in a ftp directory. If the adapter connect the directory concurrent as we transfer the file, he'll pick up the incomplete file and processed this. The problem is now, we get an erro [More]
hi experts , i was going through different threads that getting job as SAP ABAP fresher is very tough .If i consider my profile i have only 3.5 years of software development experience .If i do ABAP then i will be fresher in SAP . 1)so how should i p [More]
Hi Experts, what is the difference between BW3.5 Data Source and BI 7.0 Data Sources <removed by moderator> Regards Vijay Edited by: Siegfried Szameitat on Nov 12, 2008 3:27 PMHi, please use the search before posting --> search the forums, the in [More]
Hi All, I am getting this error " inconsistent datatypes: expected - got CLOB" for a region based upon a SQL query. The base table contains a CLOB field but that is empty. Also, something strange is happening. This error comes for some users and [More]
In one of our requirement we have used human task with different number of stages (14 stages ) and for all this we are using only one human task component and to route the task through different stages I am using advance routing rules (30 rules),we h [More]
Using Forms 10.1.2.3, IE7, JRE 1.6 When attempting to navigate within the bean area, it appears as if FORMS is suppressing the keyEvent when the tab key is pressed. This means that I cannot use tab or shift-tab to navigate within the PJC's editable f [More]
Im not well aware with Illustrator but I believe the community here should be able to help. I need help breaking off the part circled in green to match the original file. I used the ellipse tool along with some pathfinders to get to where Im at,now I [More]
Whenever I create a PDF from InDesign (CS3) I get missing artefacts/items on print production. It is caused by a transparent PSD file being laid over a spot color. I print a /ps file and then Distill to Press Quality. Overprint preview in ACrobat Pro [More]
Hello all, I have a TitleWindow custom component to which I send a html page. Does anybody know why it doesn't work? This is what I send:                     for (var i:Number = 0; i < sdeName.length; i++){                         if (sdeName.getItem [More]
Scenario: I am mixing a project in Logic 9 using new Alesis monitors with USB connector. I burnt out multiple mixes using Waveburner. In last instance, I burnt out cd, went to car to listen to it, then came back to Logic to touch up the mix. When I p [More]