Skip to Content
0

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

Nov 10, 2016 at 09:02 PM

59

avatar image

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

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

2 Answers

Edmund Leung Nov 11, 2016 at 02:56 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Pradnya S Nov 12, 2016 at 05:55 AM
0

Hi,

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

Regards

Pradnya

Share
10 |10000 characters needed characters left characters exceeded