EDIT PROGRESS PAYMENT BILLINGS

Use this screen to view and change progress payment bills that have been generated by the Calculate Progress Payment Billings screen (Projects » Billing » Calculate Billings). This gives you a chance to make adjustments to the bills before you print and post them. You can edit only existing bills created by the calculation process; you cannot enter additional rows or insert additional rows into existing bills.

The method of editing the bills depends on the type of billing line. You can edit some lines on the main screen and change others in the Line Detail subtask. You can edit billing lines in the Line Detail subtask by changing the Billing Amount, Hold Amount, or Write Off Amount of a transaction. After editing the line detail, use the recalculation process in the Line Detail subtask. Edits made directly on the main screen are automatically incorporated into later calculations on the bill.

Please note that making edits to the billing amounts in this screen will cause a discrepancy between what has been billed and the costs that have been incurred.  This may cause problems during an audit.  There is no audit trail to record how or why a change is made in this screen.  The best way to adjust billing amounts is to make adjustments to the original source journal of the transaction.

For more information, please see Billing Special Topic BL-6, "Progress Payment Bills."

Review this screen after you have calculated progress payment bills, but before you print the final bills. Note that this screen is not required, but is recommended as part of your internal quality control procedures.

Project

This field displays the project that was generated by the Calculate Progress Payment Billings screen (Projects » Billing » Calculate Billings). This screen displays only bills that have been calculated; you cannot add records to this screen. Therefore, this field and the project name that appears to the right are non-editable.

Customer

This non-editable field displays the customer to which the progress payment bill will be sent. The customer name appears in the non-editable field to the right.

Invoice

This non-editable field displays the company-wide invoice number of the bill.

Status

Use this drop-down list to control the status of the bill. Valid options are:

When the bill is calculated, the status is Unselected. After reviewing the bill and making any necessary edits, change the status to Selected to indicate the bill is acceptable for posting. You can change the status of the bills for an individual project in this screen or for a range of bills in the Select Bills for Posting screen (Projects » Billing » Edit Billings). You can print bills with either a Selected or Unselected status, but only Selected bills can be posted.  Please note that the Calculate Progress Payment Billings process (Projects » Billing » Calculate Billings) will recalculate any bills that are on Unselected status.  This will result in the loss of any manual changes.

Bill Date

This non-editable field displays the invoice date of the bill. It is initially set to the invoice date entered in the Calculate Progress Payment Billings screen (Projects » Billing » Calculate Billings). You can edit this field, or manually clear and enter the bill date when the bills are printed, in the Print Progress Payment Bills screen (Projects » Billing » Print Billings).  This date will be shown on the form 1443 on line 8B. Date of This Request field of the Section I - Identification Information subtask.

Due Date

This field displays the calculated due date of the bill. This field can be edited.

Table Window

This table window contains billing information for lines 9 through 26 of the form 1443. For a complete discussion on each of these billing lines, please see Billing Special Topic BL-6, "Progress Payment Bills."

Line

The line number shown here corresponds to the line number on Government Form 1443.  These line numbers are non-editable

Description

The description shown here is the line description from Government From 1443. The line descriptions are non-editable.

Amount

The amount shown here will appear on the corresponding line on Government Form 1443. The Calculate Progress Payment Billings process (Projects » Billing » Calculate Billings) will insert amounts onto the appropriate line.

9. Paid Costs Eligible Under Progress Payment Clause

Use the Line Detail subtask to edit this field.

10. Incurred Costs Eligible Under Progress Payment Clause

Use the Line Detail subtask to edit this field.

11. Total Costs Eligible For Progress Payments

This field displays the sum of line 9 and line 10. It cannot be edited.

12a. Total Costs Incurred To Date  (At Target)

This field can be edited. It reflects inception-to-date incurred costs using burden rates selected when the bills are calculated.

12b. Estimated Additional Cost To Complete

This field can be edited.

13. Item 11 Multiplied By Item 6a

The value in this field is determined by the amount of estimated costs and whether these costs have exceeded the contract price. It includes the calculation of a loss ratio if costs have exceeded the contract price. Please see the Line Detail subtask for a detailed explanation of this field. This field cannot be edited.

14a. Progress Payments Paid To Subcontractors

Use the Line Detail subtask to edit this field.

14b. Liquidated Progress Payments To Subcontractors

Use the Line Detail subtask to edit this field.

14c. Unliquidated Progress Payments To Subcontractors

This field is the result of subtracting line 14b from line 14a. This field cannot be edited.

14d. Subcontractor Progress Billings Approved For Cur Pymt

 Use the Line Detail subtask to edit this field.

14e. Eligible Subcontractor Progress Payments

This field is the result of adding lines 14c and 14d. This field cannot be edited.

15. Total Dollar Amount

This field is the result of adding lines 13 and 14e. This field cannot be edited.

16. Item 5 Multiplied By Item 6b

This field is the result of multiplying line 5, Contract Price, by line 6b, Liquidation Rate. The fields for these two lines are located in the Section I - Identification Information subtask of this screen. This field cannot be edited.

17. Lesser Of Item 15 or Item 16

This field is the result of comparing lines 15 and 16 and using the lesser amount. This field cannot be edited.

18. Total Amount Of Previous Progress Payments Requested

This field can be edited. It is calculated from accounts receivable history (the Maintain A/R History screen (Accounting » Accounts Receivable » Beginning Balances)).

19. Maximum Eligible For Progress Payments

This field is the result of subtracting line 18 from line 17. This field cannot be edited.

20a. Costs Applicable To Items Delivered, Invoiced, and Accepted

This field can be edited.

20b. Costs Eligible For Progress Payments

This field is the result of subtracting line 20a from line 11. This field cannot be edited.

20c. Item 20b Multiplied By Item 6a

This field is the result of multiplying line 20b by the line 6a, Progress Payment Rate, located in the Section I - Identification Information subtask of this screen. This field cannot be edited.

20d. Eligible Subcontractor Progress Payments

This field is the same amount appearing on line 14e. This field cannot be edited.

20e. Limitation a(3)(i) or a(4)(i)

This field is the result of adding lines 20c and 20d. This field cannot be edited.

21a. Contract Price Of Items Delivered, Accepted and Invoiced

This field can be edited.

21b. Contract Price Of Items Not Deliv, Accepted and Invoiced

This field is the result of subtracting line 21a from line 5, Contract Price, located in the Section I - Identification Information subtask of this screen. This field cannot be edited.

21c. Item 21b Multiplied By Item 6b

This field is the result of multiplying line 21b by the line 6b, Liquidation Rate, located in the Section I - Identification Information subtask of this screen. This field cannot be edited.

21d. Unliquidated Advance Payments Plus Accrued Interest

This field can be edited.

21e. Limitation a(3)(ii) or a(4)(ii)

This field is the result of subtracting line 21d from line 21c. This field cannot be edited.

22. Maximum Unliquidated Progress Payments

This field is the result of comparing lines 20e and 21e and using the lesser amount. This field cannot be edited.

23. Tot Amt Applied And To Be Applied To Reduce Prog Pymt

This field can be edited.

24. Unliquidated Progress Payments

This field is the result of subtracting line 23 from line 18. This field cannot be edited.

25. Maximum Permissible Progress Payments

This field is the result of subtracting line 24 from line 22. This field cannot be edited.

26. Amount Of Current Invoice For Progress Payment

This field is the result of comparing lines 25 and 19 and using the lesser amount. This field cannot be edited.

Section I

Click this button to open the Section I - Identification Information subtask, where you can edit the information found in Section I, Identification Information, of the form 1443, as well as the certification information found in the footer of the bill.

Addresses

Click this button to open the Section I - Addresses subtask. In this subtask, you can edit the contracting and paying addresses that appear in line 1 of the form 1443.

Remit To

Click this button to open the Section I - Remit To subtask, where you can edit the Remit To address that appears in line 2 of the form 1443.

Line Detail

Click this button to open a subtask that has a drill-down feature that you can use to review and edit the individual transactions that compose some of the billing lines. This function is available for lines 9, 10, 13, 14a, 14b, and 14d of the form 1443. Depending on which billing line you have highlighted when you Click the button, one of three different subtask screens is called.

After you use these subtasks to edit the billing lines, you can incorporate your changes into the bill by clicking the Recalculate button. This process brings the changes forward to the main screen and changes the appropriate bill lines.

Doc Location

Click this button to open the Documentation Location subtask, which you can use to attach a file to a progress payment bill.

Table Information

Changes to this screen update the following tables:

PRG_PMT_EDIT_DETL

PRG_PMT_EDIT_HDR