Also add where orderhed. EntryPerson Is equal to user
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Brian W. Spolarich " <bspolarich@...>
Date: Tue, 24 Nov 2009 12:14:04
To: <vantage@yahoogroups.com>
Subject: RE: [Vantage] Can I prevent a user from deleting a sales order
You can't delete a Sales Order that's been transacted against (i.e. a shipment) regardless.
Why not make a BPM that raises an exception when one attempts to delete?
You'd probably want to capture both the DeleteByID method and the Update method. I'm going to guess that the Sales Order Entry program actually calls Update for a delete with RowMod=D, so you'd want to have the condition on the Update BPM be "there is at least one deleted row in ttOrderHed".
-bws
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
���� bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Randy
Sent: Tuesday, November 24, 2009 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Can I prevent a user from deleting a sales order
We had somebody inadvertently delete a sales order. Can I prevent this from happening via customization, or at least create a message box that is meaner than the one which can be turned off?
I do not see an event in the event wizard that fits this scenario.
thanks in advance
Randy Weber
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]
Sent from my Verizon Wireless BlackBerry
-----Original Message-----
From: "Brian W. Spolarich " <bspolarich@...>
Date: Tue, 24 Nov 2009 12:14:04
To: <vantage@yahoogroups.com>
Subject: RE: [Vantage] Can I prevent a user from deleting a sales order
You can't delete a Sales Order that's been transacted against (i.e. a shipment) regardless.
Why not make a BPM that raises an exception when one attempts to delete?
You'd probably want to capture both the DeleteByID method and the Update method. I'm going to guess that the Sales Order Entry program actually calls Update for a delete with RowMod=D, so you'd want to have the condition on the Update BPM be "there is at least one deleted row in ttOrderHed".
-bws
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
���� bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Randy
Sent: Tuesday, November 24, 2009 12:10 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Can I prevent a user from deleting a sales order
We had somebody inadvertently delete a sales order. Can I prevent this from happening via customization, or at least create a message box that is meaner than the one which can be turned off?
I do not see an event in the event wizard that fits this scenario.
thanks in advance
Randy Weber
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
[Non-text portions of this message have been removed]