Skip to Content

Alert at Sales Order

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Apr 07, 2017 at 03:20 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2017 at 03:43 PM

    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

    Add comment
    10|10000 characters needed 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

  • Apr 07, 2017 at 04:50 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 07, 2017 at 05:24 PM

    Hi Ben

    Stored procedure will block the sale order from adding.

    Regards:

    Balaji.S

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2017 at 02:25 PM

    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

    Add comment
    10|10000 characters needed characters exceeded