Skip to Content
0

Alert at Sales Order

Apr 07, 2017 at 02:41 PM

80

avatar image

Hello,

I am looking at creating an alert at the sales order in SAP B1 9.2. There are times when certain BP's are not allowed to sell particular items. I am looking for an alert that when the item they are not allowed to sell is added to a sales order, that an alert message pops up in the Sales Order and states they are not able to sell that item.

I was thinking of creating a UDF Table in the BP where we will populate what item that BP is not allowed to sell. I am not sure how else to do it, but am also curious if this is possible for an alert to be setup for this situation.

if anyone has any other ideas on this I would appreciate hearing them.

Thanks,

Ben

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

5 Answers

Balaji Selvaraj Apr 07, 2017 at 03:20 PM
0

Hi Ben,

If its one to one relationship with item and BP then you can use udf and set alert with help of query.

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
Ben Christoffels Apr 07, 2017 at 03:43 PM
0

Hi Balaji,

Each BP could have the same item restriction or each BP could have a different item they are not allowed to sell.

Would the alert be triggered when the item is added to the Sales Order?

Thanks

Ben

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Ben,

If a single BP is not allowed for multiple different items(one to many relation) .Or is it a single BP is not allowed to particular item alone(one to one relation).

Alert only triggers a information and it will not stop document from adding

0
Ben Christoffels Apr 07, 2017 at 04:50 PM
0

Would the scenario presented be able to be accomplished using a stored procedure in sbo_sp_TransactionNotification?

Share
10 |10000 characters needed characters left characters exceeded
Balaji Selvaraj Apr 07, 2017 at 05:24 PM
0

Hi Ben

Stored procedure will block the sale order from adding.

Regards:

Balaji.S

Share
10 |10000 characters needed characters left characters exceeded
Nagarajan K Apr 11, 2017 at 02:25 PM
0

Hi,

Alert will be triggered after adding the document with minimum of 1 minute.

You can use transaction notification to alert user before adding document.

Regards,

Nagarajan

Share
10 |10000 characters needed characters left characters exceeded