Hello,

The PORDER table has the purchase order headers, and you can use a SQL select statement or other means from X3, like table maintenance function or create a requester, to find out if , the purchase order number you are looking for exist or does not exist in the table.

If it does not exist, yes potentially it could have been deleted by a user.( You can turn on Audit in X3 for future so you can monitor deletion from PORDER for example, for that take a look at this blog here)

Regards,

Hello,

You can search in AESPION table if the parameter TABTRA is on (X3 folder) :

filter on estnat field:

select * from aespion where espfnc_0 = 'GESPOH' and espnat_0 =3 ;

espnat_0 =3 means : record was deleted

Result: