Hello there,

when this occurs in our software the Job ID on a Commitment Change Order is assigned as a Key Field in our Database. As a Key Field, unfortunately the old job is permanently attached to that Commitment record.

If a commitment has more than one job on it, even if the line(s) with the incorrect job have been zeroed out, the Specific Job prompt cannot be used as the filtering criteria that prompt uses will return a blank output / null value when printing the log reports in Project Management. The commitment does not display or print in this scenario.

As a resolution to this issue, the workaround is to not use the Specific Job prompt on the Print Selection filter on your reports in Project Management, instead use [Conditions] to condition on a specific purchase order or subcontract ID.

The ability to edit or remove blank commitment item lines in Job Cost and Project Management commitments will be available in a future release of the software. As a workaround, you can add [Conditions] on reports to suppress commitment item numbers which are blank or incorrect.

Sage Customer Portal Knowledgebase Article ID:27715 goes into the steps and considerations. At this time we are aware of this issue, and our Product Development team is currently working to resolve this in a future release.

Thank you Barrett for your response.

Unfortunately that won't work for us.  The reports are summary reports giving us committed cost per job.  Accounting uses one report to reconcile their sworn statement which is a summary of the committed cost status report.  Warranty uses a report as a summary of all  commitments for a job listing contact information.  Our controller uses the change order inquiry to review change orders per job to reconcile ccds.   We need all commitments for a specific job to show up.  

I've tried to edit the reports but I can't find any other index to query that will give me the information I need.  Right now I'm using JCCommitment as the table and choosing commitment and job as the fields.   Anyone have any suggestions on how to query the report to pull in commitments by job but without using job?

I would suggest posting your question on www.Tugweb.com in the Crystal Reports forum, if you are a member of TUG - "The Users Group for Sage 300 Construction and Real Estate & Sage Estimating". A Crystal Reports guru may be able to revise your Crystal Report to pull in commitment line items with multiple Job Numbers.

It may be wise to alter your workflow to state that NO Commitment Change Orders be issued without the issue being on a Change Request first. This would assure that this issue doesn't happen again.

I would suggest posting your question on www.Tugweb.com in the Crystal Reports forum, if you are a member of TUG - "The Users Group for Sage 300 Construction and Real Estate & Sage Estimating". A Crystal Reports guru may be able to revise your Crystal Report to pull in commitment line items with multiple Job Numbers.

It may be wise to alter your workflow to state that NO Commitment Change Orders be issued without the issue being on a Change Request first. This would assure that this issue doesn't happen again.

If the report can be re-designed to run off the Commitment Item rather than the job, than a condition or filter will work.