Hello,

we would like to check which user printed a sales invoice first time.
I mean the user printed original invoice.

do you have any idea how can we check it?

we use Baan4c4, sales invoicing is integrated with finance.


thanks,

Hi,

I think that you can get the information from finance documents table tfgld018.
Field tfgld018.user.
Please check that the field is not updated to the user who does the financial finalization of the batch.

Moshe

The information you are looking for is in the Sales Order Line History (tdsls051) table. The Record Type (tdsls01.ckor) is used to document the following:

1 = Created
2 = Canceled
3 = Invoiced

The Record Type = 3 will contain the logname of the person who printed the sales invoice.

Hi,

unfortunately, tfgld018.user is the user who posted transaction in finance module.

If user does not send transaction to finance (only prints out invoice in SLS module) then a recurrent job does it in our system:
in this case we find only the job's name in tdsls051.logn

Maybe, we should develope this field?

See my previous posting.