Commission Accrual Report

Hi Frds,

Need help with a report. We need the details of Commission That will accrue in the near future to be booked as provisional expenses. We need the details for all sales order booked the commssion accrual details Split as follows:

1. Orders Created, Invoiced and Payment Not Received.

2. Orders Created and Not yet invoiced.

Is there any standard report for this? If not is there a way to get this information from backend tables or any custom report?

I would appreciate if anyone who has worked on similar requirements give us some lead.

Thanks,

Murali