Hi All,

How we can checked what id used to delete sales order lines?

Hi,

There can be two ways to do that:-

1. You can add the sales order line table to the Audit and check any changes made on that table. That will give you every information like user name, date etc.

2. The second way is to a a UE DLL to the sales order line table. When a line is deleted, you can gather the required information in a customized table using scripts.

You can choose any one of the above mentioned ways. Else, the DBA is always the right person to get the information required. :)

Hi,

in BaanIV you can check the field logn "Login" in table tdsls051 (History sales order lines) via session ttaad4500 - General table display.
For deleted lines the field ckor "Recory Type" is filled with value 2 (deleted).

Regards,
Juergen

Hi,

There can be two ways to do that:-

1. You can add the sales order line table to the Audit and check any changes made on that table. That will give you every information like user name, date etc.

2. The second way is to a a UE DLL to the sales order line table. When a line is deleted, you can gather the required information in a customized table using scripts.

You can choose any one of the above mentioned ways. Else, the DBA is always the right person to get the information required. :)

Hello,

no need for audit and UE.

The info in LN is stored in tdsls451 sales order position history

tdsls451.logn => user
tdsls451.ckor = tdsls.ckor.cancelation => deleted

For Baan IV the info is given by juergen.

Regards

Hi Juergen & Bdittmar,

Thanks for correcting me. So, my answer can be applicable for any other places but not Sales Orders as not all the things are captured/audited by Baan.

Thanks again.

Hi,



The info in LN is stored in tdsls451 sales order position history

tdsls451.logn => user
tdsls451.ckor = tdsls.ckor.cancelation => deleted

A little bit change to that. I tried to delete a line but, the status was "Intake". The only way to track who deleted would be then, the user who did the last transaction on that line.

The status tdsls451.ckor was tdsls.ckor.cancelation when the line was cancelled.

when i check in tdsls051.....i only found tdsls051.ckor = 1. but there are 2 records with different item codes for the same pono. It means user not delete the item code but update the item code.

It is correct my understanding?

yes, that's correct.
Until the line is not deleted and only changed the field ckor still remains "1".
ckor = 2 means the line was deleted
ckor = 3 means the line is invoiced and finally processed

regards,
Juergen

Hi Juergen,

Thank you