how to avoid user to delete the posted document?

julkifli33

hi all... i have a question
how to avoid user to delete the posted document?
i have an issue... i think there is a user that deleted the posted sales invoiced
and now we cannot track who did it?
is there a way ?
thanks

einsTeIn.NET

There's a property DeleteAllowed on the form. Did you try this?

julkifli33

einsTeIn.NET wrote:

There's a property DeleteAllowed on the form. Did you try this?

i havent tried this one
this one is good for me but is there any setting which prevent user delete the posted document/

mohana_cse06

through roles and permissions also you can restrict..
remove delete access for posted tables for particular roles..

julkifli33

mohana_cse06 wrote:

through roles and permissions also you can restrict..
remove delete access for posted tables for particular roles..

ow ok the roles
thanks a lot

Alex_Chow

julkifli33 wrote:

hi all... i have a question
how to avoid user to delete the posted document?
i have an issue... i think there is a user that deleted the posted sales invoiced
and now we cannot track who did it?
is there a way ?
thanks

Put on the OnDelete trigger of the table:

ERROR('STOP!!!!');

julkifli33

Alex Chow wrote:

julkifli33 wrote:

hi all... i have a question
how to avoid user to delete the posted document?
i have an issue... i think there is a user that deleted the posted sales invoiced
and now we cannot track who did it?
is there a way ?
thanks

Put on the OnDelete trigger of the table:

ERROR('STOP!!!!');

so simple and it works
thanks

mohana_cse06

julkifli33 wrote:

einsTeIn.NET wrote:

There's a property DeleteAllowed on the form. Did you try this?

i havent tried this one
this one is good for me but is there any setting which prevent user delete the posted document/

This was also simple..what was the issue with this?

julkifli33

mohana_cse06 wrote:

julkifli33 wrote:

einsTeIn.NET wrote:

There's a property DeleteAllowed on the form. Did you try this?

i havent tried this one
this one is good for me but is there any setting which prevent user delete the posted document/

This was also simple..what was the issue with this?

yes this is also simple...
but i need to set it in the table
so i dont have to set for each form/page

DenSter

julkifli33 wrote:

mohana_cse06 wrote:

einsTeIn.NET wrote:

There's a property DeleteAllowed on the form. Did you try this?

This was also simple..what was the issue with this?

yes this is also simple...
but i need to set it in the table
so i dont have to set for each form/page

Exactly =D>

einsTeIn.NET

As far as I know there's only one Form for each Posted Document Type where deletion is allowed. So the effort should be nearly the same. And most customers do not have access to the Table Designer. But anyway... I think there're many roads that lead to Rome and it depends on your individual situation what's the best solution for you.

Savatage

This is another one of our Setup Table Additions too.
Sales & Receiveable Setup
New Boolean = "Block Deletion Of Posted Documents"

Then on Table
OnDelete()
SalesSetup.Get;
If SalesSetup."Block Deletion Of Posted Documents" then
ERROR('You are not allowed to delete Posted Documents');

That way authorized people can turn it on & off if needed without having to go back to change the code.

DenSter

einsTeIn.NET wrote:

As far as I know there's only one Form for each Posted Document Type where deletion is allowed. So the effort should be nearly the same. And most customers do not have access to the Table Designer. But anyway... I think there're many roads that lead to Rome and it depends on your individual situation what's the best solution for you.

Yes there are many roads to Rome. The point though is that business logic should be triggered by the data, not the form that the data happens to be on. Whether you are allowed to delete a record from a certain table should not be decided by which form you are on. What will happen if certain users need to be able to delete that data anyway, more code on the form? Programming (I consider setting properties as programming) business logic in forms just makes managing the application needlessly complex.

einsTeIn.NET

DenSter wrote:

einsTeIn.NET wrote:

As far as I know there's only one Form for each Posted Document Type where deletion is allowed. So the effort should be nearly the same. And most customers do not have access to the Table Designer. But anyway... I think there're many roads that lead to Rome and it depends on your individual situation what's the best solution for you.

Yes there are many roads to Rome. The point though is that business logic should be triggered by the data, not the form that the data happens to be on. Whether you are allowed to delete a record from a certain table should not be decided by which form you are on. What will happen if certain users need to be able to delete that data anyway, more code on the form? Programming (I consider setting properties as programming) business logic in forms just makes managing the application needlessly complex.

Yes, I'm totally with you. I know about the issues behind. But I can also think of situations where it is easier to go another road and someone decides that it is worth to bear the consequences of that road. That's why I said it depends on your individual situation what's the best solution for you.