Skip to Content
avatar image
Former Member

SAP Business One Alert to fire when a Customer is Put On or Off Hold

Hello all

I am trying to write a query to fire when the column name in table OCRD frozenFor is changed.

Basically if the Radio Buttons on the Business Partner form labeled Active or Inactive determine whether a BP is Active or not. The value in column frozenFor is set to a 'Y' if the BP is Inactive and is set to an 'N' if the BP is active.

Is there a way to Trigger and alert to fire if the column frozenFor changes?

Thanks in advance

Dana

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 11, 2016 at 02:56 AM

    Dear Dana

    After the user click the update button, the alert will be shown.

    Before the user click the update button, the alert will not be shown.

    Regards

    Edmund

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 12, 2016 at 05:55 AM

    Hi,

    Alert will execute only after the change is committed to the database.

    Regards

    Pradnya

    Add comment
    10|10000 characters needed characters exceeded