Material Requisition

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.

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


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

Thank you Danuka and Shadow for the solutions given. They are very informative and helpful.

Does anyone know why the created by user is not a standard column here or in many other places?