Yes,I need to determine which codes to use, and where to put the "details" the specification codes get their information from.

Previously applied should be available from job cost information, but if the invoice module can't pull from there, then it can be an optional field. That's the way I set it up originally.

Total Complete is different than the subtotal. The subtotal represents the "TOTAL CONTRACT" including any change orders. The Total Complete is the dollar amount that represents the percentage of the job (Total Contract) that is actually complete and that can be billed to date. This is probably the 2nd optional field, and with each "new" invoice relating to this particular job, the Total Complete changes (increases), and therefore the subsequent dollar amounts in the following lines also change.

Using numbers - 1st Invoice

Subtotal: 100
Total Complete: 30
Retainage: 3
Total Earned Less Retainage: 27
Less Previously Applied:
Current Payment Due this Invoice: 27

2nd Invoice
Subtotal: 100
Total Complete: 50
Retainage: 5
Total Earned Less Retainage: 45
Less Previously Applied: 27
Current Payment Due this Invoice: 18

3rd Invoice
Subtotal: 100
Total Complete: 100
Retainage: 10
Total Earned Less Retainage: 90
Less Previously Applied: 45
Current Payment Due this Invoice: 45

I've billed 3 invoices - Total due from the 3 = 90
Then I create the Retainage invoices for the retainage = 10

This is what I need. The form is ready to go. It's how to get the information onto the form and therefore into Invoices that I need to know.

Thanks, and sorry it's so long,

Karen