Question

Material Requisition

  • 30 September 2019
  • 6 replies
  • 1121 views

Userlevel 5
Badge +8
In Material Requisition screen, how can we know who creates the MR, User NOT the Department?

6 replies

Userlevel 1
Badge +2

Setting up history logs can help you to get the relevant details

The History functionality provides a way of logging all the interesting transactions in the database. It can be set to detect changes such as inserts, updates or deletes on the table level and then log the chosen attributes.

To Setup the history logging click on Setup History Log in Solution Manager / Monitoring / History and enable insert/update options. It should help you track the changes and the executed by persons for future records.
If you have not setup this, you’ll not be able to track the changes for past records.
Userlevel 5
Badge +7
In case the History Log is not setup and you still want to find out the user who created the Requisition, simply use the below method.

Navigate to SQL Query Tool and enter below SQL Statement
code:
SELECT created_by_user_id FROM MATERIAL_REQUISITION WHERE order_no = 'x'


press Execute.

(replace x with the Requisition no)

For Long term:
For long term use, it is possible to create a read only Custom Field with the above SQL to show this information in the screen itself.

Follow below steps to add Created by to your Material Requisition Screen.

Navigate to Custom Fields and create a new Custom Field for LU MaterialRequisition.


Mark Searchable if you want to search using who created them.

Who created will right be there:
(Make sure you add the new field to layout using Properties)

In this example we use v.order_no are pass it to the query as

code:
SELECT created_by_user_id FROM MATERIAL_REQUISITION WHERE order_no = :order_no
Userlevel 5
Badge +8
Thank you Danuka and Shadow for the solutions given. They are very informative and helpful.
Userlevel 4
Badge +8
Does anyone know why the created by user is not a standard column here or in many other places?
Userlevel 5
Badge +10

Hi,

 

I have tried the code in APPS 9 and the 

created_by_user_ID

is not in Material_Requisition as a field?

Userlevel 5
Badge +7

Hi Matthew,

I’m afraid created_by_user_ID is not available in Applications 9 track. 

Reply