Total commitment amounts for invoiced, paid, or retainage are incorrect

The reports, such as the Committed Cost with Detail report, show totals from the Job Cost (JC) commitment record and details from the Accounts Payable (AP) invoice. If you post entries in Accounts Payable but not in Job Cost, these two records won't match. Posting errors can also cause the amounts to be out of balance.

Post entries or correct commitment item totals

Estimated minimum time to complete the following steps: 10 minutes.

Confirm that all entries are posted

1. Check the unposted transactions in the Job Cost and Accounts Payable new files.
   1. In Job Cost, select Inquiry, Entries, and Entries by Batch.
   2. Select the New file, and then click OK.
   3. Check for batches from Accounts Payable.
   4. If you find AP batches, click the batch number and then click Transactions to review them.
   5. Click Close to exit the inquiry.
2. If there were unposted entries in the new file, post the entries to update Job Cost totals.
3. Review the posting journals to verify the entries posted.
4. Confirm there are no pending invoices in Accounts Payable for this commitment.
5. If pending invoices exist, either post or delete the pending invoices.

Refresh Commitment total (last commitment change or invoice or payment didn’t refresh totals)

1. Open commitment and view the total at the bottom.
2. If it doesn’t agree with the item detail totals, save the commitment and finish.
3. Open commitment again and view the totals to confirm they’re correct now.

Correct commitment item totals manually

If the totals are incorrect after posting entries and correcting rejections, the commitment item totals could be out of balance. You can use the invoice totals to get the correct balances and update the commitment item totals.

 NOTE: If you're using security, you must be an Application Administrator to perform these steps. 

1. Download and run the report attached below to get the correct totals.
   • Attachment: JCCommitmentItemValidation.rpt
2. Turn on the Audit Setup Activity setting.
3. In Job Cost, select Tasks and Commitments.
4. Enter the commitment ID in the Commitment box.
5. Press ENTER.
6. Click OK if a message appears warning that invoices or change orders were generated against the commitment.
7. Press ENTER until your cursor is in the grid.
8. Click the wrong commitment line item and then click Item Detail.
9. Correct the invoiced, retained, and paid amounts in the Item Details window.
10. After correcting the amounts on the item, click OK.
11. Click Save Line.
12. After changing each item line, click Save Commitment.
13. Click Finish and Start.
14. Turn off the Audit Setup Activity setting.

AP invoices are missing on the JC Committed Cost with Detail report (inconsistent upper/lower case on commitment ID)

Is there a Job Cost report to reconcile commitments for invoiced, retained, and paid amounts from Accounts Payable?