Warning: The attached report is provided as a possible solution to your issue. It was not reviewed by Quality Assurance. You may need to modify it to meet your reporting needs or adapt it for use with future releases of the software. Contact your Sage 300 Construction and Real Estate certified consultant for assistance with modifying this report.

Download the report below. Refer to How do I save, add, and print a report design?

Attachment: JCCommitmentItemValidation.rpt

This report has the following set up and options:

• Processes based on the JC Transaction record.
• Summarizes amounts invoiced, retained, and paid based on the JC commitment item record.

Use this report to compare commitment items to transactions if you have experienced problems when posting Accounts Payable and Job Cost commitments.

Refer to The commitment amount totals for invoiced, paid, or retainage are incorrect because JC totals do not match AP transactions for instructions to correct the totals if needed.

 

For a report that compares the commitment totals with the transaction totals, see Is there a report I can use to reconcile the commitment transactions to the commitment totals?