Query to get number of PO created
This query will fetch you the number of Purchase Orders created in month. The input parameter passed is from date and to date. This will group the number of PO created into months and provide you [...]
Query to get Invoice,value of invoice and cash collected details:
Introduction: This query will fetch you the below data.1) Total Number of invoices2) Total value of invoices (USD)3) Cash collected (USD)The input parameter passed is from date and to date. SQL [...]
Query to give responsibility details which is missing for a user
Introduction: This query will fetch you the responsibility details which is missing for a user. The input parameter passed is ‘user name’ which will get processed and provide you with the [...]
Query to give user responsibility details
Introduction:This query will fetch you the user responsibility details such as responsibility name, application name, description, security group, start date and end date. The input parameter [...]