KBA-01492: The Remaining Commitment to Pay column in the BFA workbook

Question:

What information appears in the Remaining Commitment to Pay column in the BFA workbook? What information appears in the Remaining Commitment to Pay line of the Project KPI?

The Remaining Commitment to Pay column was added to the BFA workbook to help compensate for the fact that Microsoft Dynamics SL‘s “outstanding committed amount”‘ is a much stricter financial accounting number. The Spitfire Remaining Commitment amount is simply the dollar amount of future anticipated payment requests.

The RemainingPayAmount is calculated per Commitment thus:

• If the Commitment is completed, then the remaining amount for the Commitment is zero.
• If any Pay Request for the Commitment is marked FINAL, then the remaining amount for the Commitment is zero.
• Otherwise, the current contract amount on each Commitment Item is compared to the amount paid on each Item.  Overpayments are ignored and the sum is the RemainingPayAmount for the Commitment.

For the KPI, the amounts are aggregated up to the project level.  For BFA, the amounts are aggregated at the cost code and account level.

Example:  Consider a electrical commitment with

• cost code 16000 for labor        on line 0001 with a value of \$10,000
• cost code 16050 for materials on line 0002 with a value of \$2,000
• cost code 16050 for materials on line 0003 with a value of \$3,000
• cost code 16200 for materials on line 0004 with a value of \$4,000

A series of payment requests have been made as such:

• Line 0001 has had \$4000 paid
• Line 0002 has had \$3000 paid
• Line 0003 has had \$2000 paid
• Line 0004 has had \$1000 paid

The Remaining to Pay by line would be

• Line 0001 – \$6,000
• Line 0002 – \$0 (because it is overpaid – no credit or additional payments are assumed)
• Line 0003 – \$1000
• Line 0004 – \$3000

Had any payment request been marked final, or the Commitment itself marked Completed, then the remaining to pay for that Commitment would be zero.

In BFA, the values above would appear by cost code and account:

• cost code 16000 for labor      would have \$6000 remaining to pay
• cost code 16050 for materials would have \$1,000 remaining to pay (zero from line 0002 and \$1,000 from line 0003)
• cost code 16200 for materials would have \$3,000 remaining to pay

KBA-01492; Last updated: September 18, 2017 at 11:34 am
Keywords:  SCRemainingPay, Commitment Remaining