Line Info 20-26

Use this field to enter the sum of eligible costs that have been delivered, invoiced, and accepted.  You must manually enter the value for this line.  

Currently, no method exists to automatically calculate this line.

This non-editable field is calculated by subtracting Line 20a from Line 11. The amount reflects the incurred costs associated with undelivered items.

The system calculates this non-editable field by multiplying the cost associated with undelivered items by the progress payment percentage.  This represents the amount of costs incurred on undelivered items eligible for progress payment.

This non-editable field has the same value as Line 14e.

The system calculates this non-editable field by adding Lines 20c and 20d.  The value represents the sum of eligible subcontractor progress payments and cost incurred on undelivered items.

This field displays the total value of goods and services that have been delivered by subcontractors up to and including the bill date on which the calculation of progress bills was performed.

The system calculates the amount displayed on this line by adding the sum of all delivery amounts in the Initialize A/R History screen.

The system calculates this non-editable field by subtracting Line 21a from Line 5.  It represents the price of items not delivered.

The system calculates this non-editable field by multiplying Line 21b, price of undelivered items, by Line 6b, liquidation percentage.

You must manually enter the value for this line.  It represents advance payments that have been made in addition to the regular progress payment cycle.

This non-editable field displays the value for the limitation for outstanding progress payments. The system calculates this value by subtracting Line 21d from Line 21c.  

This non-editable field displays the maximum amount of unliquidated progress payments that are allowed. The system calculates this value by selecting the lesser value of Line 20e or 21e.  

This non-editable field displays the estimated total liquidations.

The system calculates this value by summing the Liquidation Amount field for all paid delivery invoices in the Initialize A/R History screen (Accounting\Utilities\Transaction History) and summing the unpaid delivery invoices from same table. It then multiplies the unpaid delivery invoices by the liquidation rate. It adds the result of these calculations  together to obtain the value for this field.

The system calculates this non-editable field by subtracting Line 23 from Line 18.  Normally, this calculation results in a positive value. However, Line 23, estimated total liquidations, can occasionally exceed Line 18, total amount of previous progress payments requested.  This occurs if delivery invoices were invoiced but not paid and require no liquidation.  In this case, Line 24 will be zero (i.e. Line 24 cannot be a negative value).

This non-editable field displays maximum progress payments allowed or available. The system calculates this value by subtracting Line 24 from Line 22.  

This field displays the amount of current invoice for progress payment.  

The system calculates this value by using the lesser of Lines 25 or Line 19.  The system compares the maximum balance eligible progress payments (Line 19) with the maximum permissible progress payments (Line 25), and uses the smaller value as the invoice amount.