We work on a percentage complete invoicing system. We typically have 3 invoices for each project (30/60/10). I have no problem getting a list of the unpaid invoices as well as the open sales orders.
What I'd like to know is how to get a report of the amount (by customer) that has NOT yet been invoiced. Funds we WILL receive in the future.
Since projects can go on for long periods it's not as simple as subtracting one from the other.
Thanks...