Skip to Content
Jan 03, 2013 at 10:43 PM

Query Sales Opportunities


Hello all,

I was wondering if it's possible to query the number, value and volume of sales opportunities won throughout a specific month or within a specific date range in SAP Business One 8.81.

I didn't find any columns in the OOPR table that relate to that or to the date on which the sales opp status changes to won.

Another question is would it be possible to write a query up for the list of business partners that have been converted from lead to customer within a specific date range.

The way I see it is SAP would have to be recoding somewhere when these transactions are happening for me to be able to call up this information now. I'm not sure if that is the case or if there is any other way of getting said information.

Thanks in advance.