Customizing,Viewing and Managing Messages/Alerts

[former_member629800]

Dear Team

I want to customize the Message/Alerts window. My Auditor ask me that he wants to see the name of the supplier after the column of the user name of the creator of the PO.

Please guide how can I do this.

Thanks,

[KennedyT21]

Please close your thread by marking helpful/correct answer.

Thanks,

Kennedy

[former_member186095]

Hi,

By using standard alert of SAP B1 is not available for your issue.

You can use query alert and create the customized alert in SAP B1 --> admin module --> alert management --> click open save query and after that check the active tick box.

The user that creates the PO is recorded in the OPOR table --> field usersign. You can also use one of these two fields i.e. Buyer or Owner,see the black box in the following screen capture.

but if you use user sign, it will not be visible. Usersign can be set to visible by using customization. Usersign is user who is currently login into SAP B1

The sample query can be as follows:

select distinct opor.usersign, opor.docnum, opor.docdate from opor where opor.docstatus = 'o'

I put a docstatus field in where condition because by best business practice, only in the open documents are needed to know their creators.

It will make your db slow performance if all documents are viewing in the alert message windows.

Annother query alert if you want to use buyer or owner:

A. using field buyer

SELECT T1.[Slpname]"PO Buyer", t0.docnum, t0.docdate, t0.docstatus FROM OPOR T0 inner join oslp t1 on t1.slpcode = t0.slpcode

B. using field owner:

SELECT distinct T1.firstname+t1.lastname"Document Owner", t0.docnum, t0.docdate, t0.docstatus FROM OPOR T0 inner join OHEM t1 on t1.empID = t0.ownercode where t0.docstatus = 'o'

In best business practice, the use of document owner field is recommended  as the field to record the document creator rather than usersign.

Good luck

JimM

[former_member629800]

Hi Jimmy

I have tried to follow the suggested practice but in my case the Open Saved Query button is suppressed. I have tried to do so by first checking the Active Check box but still it remains suppress.

Please tell me why it remains suppress.

I am loging into the SAP application with the user manager so there shouldn't be authentication problem also.

Please guide me further.

Thanks,

[KennedyT21]

Hi Ravi,

Check does Your SBO Mailer service  is started in the Service Manager and the settings for the alert management has done in service manager.

Alert management Open with the Find Mode need to click on the add mode to invoke new alerts.

Hope It helps

Regards

Kennedy