The commitment ID is alpha or alphanumeric and there are AP distributions where the upper/lower case for the commitment ID is inconsistent and does not match the case of the commitment ID in JC.
For example, the commitment ID in JC is ABCD-1000. There are invoices where the distributions have the commitment ID as abcd-1000, or Abcd-1000, or ABcd-1000, or any other combination besides ABCD-1000. Anything that does not match ABCD-1000 exactly in upper/lower case, is excluded from the report.
These can get created from Import Invoices if in the import file the commitment is entered in the incorrect case and the Capitals setting is not being utilized on JC Commitment in Custom Descriptions.
Or they were created from interfacing programs using the API (Application Programming Interface) to send/create invoices and the commitment was entered in the incorrect case in the interfacing software. Some examples of interfacing programs using the API are Paperless, ProCore, and TimberScan. (Note: It has been confirmed that TimberScan will follow the Capitals settings in Custom Descriptions.)
Note: If you changed the description of Commitments in Custom Descriptions, the task, buttons, and fields will be named with your description. For example, if it was changed to Purchase Orders, the menu will show Tasks, Purchase Orders.
To verify the issue exists:
To fix the issue:
The commitment amount totals for invoiced, paid, or retainage are incorrect compared to Accounts Payable invoices
Is there a Job Cost report to reconcile commitments for invoiced, retained, and paid amounts from Accounts Payable?
The commitment amount totals for invoiced, paid, or retainage are incorrect because JC totals do not match AP transactions
Is there a report I can use to reconcile the commitment transactions to the commitment totals?