Nav 2013 R2 restrict delete on all posted documents.

zulq

How can I stop all users from deleting posted documents including super users?

Luc_VanDyck

Set the property DeleteAllowed to 'No' for all posted document Pages.

zulq

Sorry for not mentioning but have already done it at that level.

Juhl

Put Logic on the Table instead.

Put an ERROR() in the OnDelete trigger og the tables.

geordie

Juhl wrote:

Put Logic on the Table instead.

Put an ERROR() in the OnDelete trigger og the tables.

This is the same thing done by MS on some posted documents tables on IT localization

zulq

What I have done is put an error on all header tables if

posting date <> 0D

. Is this the best way to do it?

Wisa123

Quite redundant, because a posted Document should have a posting date anyway.

just put an Error('not allowed') or whatever you like on the beginning of the OnDelete Trigger of the table.

zulq

@Wisa123, where is the data stored before it's posted?

Wisa123

Unposted sales documents (quotes, invoices) are stored in table 37 - Sales Line (correct me if im wrong on the ID)

When the Invoice/Shipment is posted the concerning SalesLine's get deleted and SalesInvoiceLine's/SalesShipmentLine's are generated by the posting routines.
So if you dont want Posted Documents to be deleted you want to insert the Error in the onDelete of:
* Sales Invoice Line
* Sales Shipment Line

at least on the sales side of things.

Juhl

Put ERROR() on OnDelete trigger of tables:
110, 112 and 114 for sales
120, 122 and 124 for purchase

zulq

Thanks @Juhl, this is exactly the tables where I have place the code just wasn't so sure.