on 2019 Sep 24 8:13 AM
i just need to have the SQL query, from which IP/ Client name the Journal Entry or Outgoing payment has been made from SAP business One 9.0.
Hi
open the outgoing payment screen, search the payment and select in the menu Tools --> Log. You can see the detail, then search in OUSR table the user info, and check the info in USR5 table.
Kind regards
Agustín
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
i did exactly what you answered and got user info, but all i got from USR5 are list of transactions with Action 'I' Or 'O'
when you know the user code, use this data to query in usr5:
select * from usr5 where usercode = yourusercode
I think you need to know the user in the log screen did the payment, and then check in usr5 table all data you want.
i have a Voucher Number and need from which IP that voucher made.
how can i get the user log screen did the payment ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.