sms integration with sap b1

[Former Member]

HI to all,

can it possible if sms integration with sap business one. means if i create a/r invoice if i add the document automaticlly send sms to the customer in that sms following matter to be send

invoice number,posting date,due date,invoice amount.can it possible .if yes then what is requirement for that.pls reply i will waiting for your reply...

Regards,

vishal.

[Former Member]

Check this SAP Note:658689 Sending SMS from SAP Business One

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=658689]

[Former Member]

Hi,

in that note it mention. This functionality is supported only for Israel localization.so it is not possibel for india..pls reply....

Regards,

Vishal

[Former Member]

Cannot enter the note attached

[Former Member]

Hi.

You Can Create CLR procedure that send sms via internet using sms gateway. And execute it in Transaction Notification.

[Former Member]

Hi michal,

pls tell me detail of CLR procedure and also tell procedure internet using sms gateway.

Regards,

Vishal

[Former Member]

hi

1.Create class library in Visual Studio 2005 C# Express Edition create assembley SQLCore

Write code:

using System; 

using System.IO; 

using System.Text; 

using System.Net; 

  

namespace SQLCore 

{ 

   

    public static class SMS 

    { 

        

        public static void PlusSend(string Sender, string Recipient, string Message) 

        { 

            string Destination = "http://www.text.plusgsm.pl/sms/sendsms.php"; 

            string Data = "?tprefix=" + Recipient.Substring(0, 3) + "&numer=" + Recipient + "&odkogo=" + Sender + "&termin=0&tekst=" + Message + "&godz=00&min=00"; 

            SMS.PostStringToURI(Destination, Data); 

        } 

  

        private static void PostStringToURI(string URI, string String) 

        { 

            byte[] Bytes = Encoding.UTF8.GetBytes(String); 

            HttpWebRequest Request = (HttpWebRequest)WebRequest.Create(URI); 

            Request.Method = "POST"; 

            Request.ContentLength = Bytes.Length; 

            Request.ContentType = "application/x-www-form-urlencoded"; 

            Stream RequestStream = Request.GetRequestStream(); 

            RequestStream.Write(Bytes, 0, Bytes.Length); 

  

            HttpWebResponse Response = (HttpWebResponse)Request.GetResponse(); 

            if (Response.StatusCode != HttpStatusCode.OK) 

            { 

                string Message = String.Format( 

                "POST failed. Response staus {0}.", 

                Response.StatusCode); 

                throw new ApplicationException(Message); 

            } 

        } 

    } 

}

for your localization you have to find your own sms gateway.

2.Compile project .

3.Copy dll to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn

4. Set SETTRUSTWORTHY on true using

ALTER DATABASE databasename SETTRUSTWORTHYON; 

go;

[more info about SETTRUSTWORTHY|http://msdn2.microsoft.com/en-us/library/ms187861.aspx ]

5.Create Assembly for your dll.

CREATE ASSEMBLY SQLCore 

FROM 'C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\Binn\SQLCore.dll' 

WITH PERMISSION_SET = EXTERNAL_ACCESS

6. Create Procedure

CREATE PROCEDURE dbo.[PlusSend](@Sender nvarchar(max), @Recipient nvarchar(max), Message nvarchar(max)) 

AS EXTERNAL NAME SQLCore.[SQLCore.SMS].PlusSend 

go;

7 .Fially execute using

EXECUTE dbo.[PlusSend]('SENDER'','PHONE NUMBER','Message')

Insert it in transaction notification.

Hope it helps.

[Former Member]

Dear Former Member ,

I was unable to do the process which you have mentioned  can you help me out the detailed process as i am using MS SQL 2012 not 2008 when i was 

CREATE ASSEMBLY SQLCore

FROM 'C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\Binn\SQLCore.dll'

WITH PERMISSION_SET = EXTERNAL_ACCESS

getting an error as CREATE ASSEMBLY failed because it could not open the physical file 'C:\Program Files (x86)\Microsoft SQL Server\80\Tools': 5(Access is denied.).

Regards,

Meghanath.S