teddybear
7th August 2006, 06:36
Dear guru,
Is there is way that I can find out which user approved an invoice in the finance module.
Thanks in advance.
tomlbacon
7th August 2006, 14:29
If it Accounts Payable you should be able to look in table tfacp200 to see the USERID.
Michiel Leerkes
7th August 2006, 16:16
First find the invoice in tfacp200, with only the transaction type and document number filled (the rest of the key empty).
Of that record take the fields tapr and dapr. These fields stand for the transaction type and document number of the approval document.
With these fields get the tfgld018 record (index is also transaction type and document number) and the field tfgld018.user will give you the person who approved the invoice.
The field to which the other reply is referring in tfacp200 only give the user who enters the invoice and that user can differ of course from the user who approved the invoice.
Regards,
Michiel