SBO Mailer and Auto Report Scheduling in SAP Business One

[Former Member]

Dear All,

As we all had come across for a requirement of Mail, and auto report scheduling from SAP Business One, Some ask that we need mail should automatically triggered once document is posted, auto report should be executed and mail on the provide parameter.

Earler we need to install outlook integration add-on  but from 9.1 we have a feasibility to select by which mean we want to shoot mail.

In SAP 9.1 we have option to select Default E-Mail Method, whether to select SBO Mailer or Outlook E-Mail, from 9.1 if we want to use outlook E-mail, then only requirement is to have outlook installed in your system.

In this document i will brief you steps to configure E-mail method as SBO mailer.

Following are the steps:

1. First step is to select the option of SBO mailer under Administration-->System Initilizaion-->General Settings-->

Service tab Under service tab, there is an option to select default method through mail should be triggered.

2. Once done with the above setting, user need to configure SBO Mailer setting under service manager.

Under service manageràSelect SBO Mailer (from Drop down), go to settings.

And  map the Mail setting. for SMTP Server: need to provide the SMTP server details such as : mail.google.com or smtp.google.com, for configuring to any client location ask Client's IT manager about the SMTP server details.

And remember by default port available is 25, but this may not work, and may be a scenario occurs that you may ask for SMTP Port to IT person and it may not be available with him also. So to work with SBO mailer, Port should be either "587" or "465". The repsonse time will be in a minute for Port-587 and Port-465 repsonses soon.

Point To Remember: Please enter credential for User ID and Password belongs to same SMTP server, so that mail would trigger from the provicded Email-ID.

This option to enter user id and password, user need to select the Authentication as "Basic Authentication" which is the safest way to configure.

For some SMTP server TLS encryption requires to be enable and for some it is not, so it may be hit and trial method to check whether required or not. Because sometimes it may happen that you had configured each and every steps and also had checked TLS Encryption but E-mail is not triggred from SBO, so if you un-check and then try and then you get E-mail in your inbox.

3.Next setting is to configure connections , under service manager-->SBO Mailer

Click on Connection tab configure DB Type and DB Server and then next is to select the databse for which we want to send e-mail using SBO mailer.

4. Once completed with the above setting stop the service for SBO mailer and then restat the service.

5. Now open SAP under administration-->Setup-->General-->User.

Open the user detail which is login in SAP and fill the detail for E-mail in user setup. Update the user setup. It is mandatory that user which is login in SBO should have e-mail id under user setup.

6. For auto mail trigger go to Administration--> System Initilization--> Print prefrences--> Per Document and select your desire document and check on setting under "When Adding Document"

For Auto Report Scheduling:

1.Under Service manager-->SBO Mailer-->Setting, port should be either 587 or 465. And Should define the scheduled report settings

For SAP Business One Client Executable click on browse button and find the mention path.

Enter Subject Prefix , Sender name, Sender e-mail which may or may not be same as provided for SBO Mailer.

2. Next step is to setup path for attachment default printer etc under  administration-->System Initialization-->General Setting.

Note: A printer needs to be configured with the system and should be set as default for the user system.

3. Then after performing above steps next setting is to configure under control Panel--> Administration-->Services--> SAP Messaging Service.Double click on SAP Messaging services and then click on LogOn tab. Under logon tab click on radio button for This Account, click on browse. Select user, user should belong to Local Administrative group (this condition is mandatory). Enter the password credentials for the user.

     

4. After completion of each and every above mention configuration then click on SAP Messaging services Stop the services and then Restart the service again. Open SAP Business One, test by sending a test email (to any other user)

5. Once test is completed, go to query manager, select the query, make sure that user must had defined  report layout (QPLD),select the schedule button , Report execution scheduler window will open.User need to define criteria for scheduling report and auto mail. To track schedule, go to toolsàScheduled Report Overview. Under this form user can see all the scheduled report and there status.

6. For further details for How to configure report schedule plea     se refer to SAP Note:  1798434.