Posts by Bhuvaneswari Manoharan

Query to give pricelist name, start date, end date, organization and price

Introduction: This query will fetch you the pricelist name, start date, end date and price of the item. The input parameter passed is item name which will get processed and…

Read More

Query to give party and location details for a sales order

Introduction: This query will fetch you the party and location details for a sales order. The input parameter passed is ‘Sales order number’which will get processed and provide you with…

Read More

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…

Read More

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.…

Read More

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…

Read More

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 passed is ‘user name’…

Read More