1. I'm trying to create a gridview report that will be used weekly to show our billing department which contractors need billing by a certain date. We have missed deadlines and our billing has been put off by the contractors a month when we do this. I know I can now add notes and alerts to the JC module. I'm trying to figure out a way to isolate the notes that deal with billing due dates for this report. Any suggestions?

2. Commission reports. I pay one particular salesperson a commission rate based on the "first billing" of the job. Commission is due only when the job is paid in full. We were able to create a report to calculate the commission percentage, but the report can only "see" last billing date, not the first. Steve came up with a workaround - but it's time consuming. Main report uses "due date" as the trigger for which percentage commission should be based on. However , it involves creating a 2nd report that lists which jobs need to have the due dates changed - by creating a change order - to have the due date actually represent the first billing date. Any suggestions on simplifying this for me? Unfortunately our salespeople are paid using different calculations for commission and this one is a pain.

Thanks in advance, Karen