Hello,

I wanted to see if anyone had a work around for this issue related to retention and invoice due dates.

Example: We have progress billing for November outstanding that has not been paid. In December, we are 100% complete with the job and bill retention to the owner. This triggers me to release all the retention on the job which moves it from "Retention" to "Net Due". When doing this, I have to select a new due date for the invoices which is generally 30 days from when we send the retainage pay application to the owner. 

The issue: The November progress billing invoice due date is now incorrect. Technically the bulk of it is due in December and is past due, and the retention is not yet past due. The due date is showing the due date for the retention piece, but not the progress billing piece. I have a report that shows past due AR and this would cause the November invoice to be left out of the report.

Any suggestions on this?