Group cost code out of balance on the Job Cost Close Month journal
Description
Cause

The Close Month Validation report shows in balance because it doesn’t validate group cost codes. Other reconciliation reports are available for group cost codes.

Resolution

 CAUTION: We've provided the attached reports as a possible solution to your issue. They weren’t reviewed by Quality Assurance. You can modify them to meet your reporting needs or adapt them for use with future releases of the software. 

  1. Save and print the attached report that matches your cost code format.  
    Cost Code Formats Example Cost Codes Report to use
    x-xx 1-23 or 12-34 JC Group Cost Code Rec (2 sections, x-2)
    x-xx-xxx 1-23-456 or 12-34-567 JC Group Cost Code Rec (3 sections, x-2-3)
    x-xx-xxxx 1-23-4567 or 12-34-5678 JC Group Cost Code Rec (3 sections, x-2-4)
    x-xxx 1-234 or 12-345 JC Group Cost Code Rec (2 sections, x-3)
    x-xxx-xxx 1-234-567 or 12-345-678 JC Group Cost Code Rec (3 sections, x-3-3)
    x-xxx-xxxx 1-234-5678 or 12-345-6789 JC Group Cost Code Rec (3 sections, x-3-4)
    x-xxxx 1-2345 or 12-3456 JC Group Cost Code Rec (2 sections, x-4)
    x-xxxxx 1-23456 or 12-34567 JC Group Cost Code Rec (2 sections, x-5)
     NOTE: If your cost code format doesn’t match one of the examples, modify the report in Report Designer or contact your Sage Consultant for a modified report design. 
  2. Review the reconciliation report.
  3. The reports print information for three amount types: JTD Costs, Estimates, and Dollars Paid. The Close Month Journal includes the amount type that is out of balance for the group cost code. A value prints in one of the amount type Proof columns when the sum of the detailed cost codes doesn’t equal a group cost code. Check both the Group and Group Two totals for each cost code section if your cost code has three sections.
  4. Make corrections to the job.



Attachment: jc_group_cost_code_rec_3_sections_x-4-3.rpt
Attachment: jc_group_cost_code_rec_3_sections_x-2-2.rpt
Attachment: jc_group_cost_code_rec_3_sections_x-2-3.rpt
Attachment: jc_group_cost_code_rec_2_sections_x-3.rpt
Attachment: jc_group_cost_code_rec_2_sections_x-4.rpt
Attachment: jc_group_cost_code_rec_2_sections_x-2.rpt
Attachment: jc_group_cost_code_rec_3_sections_x-2-4.rpt
Attachment: jc_group_cost_code_rec_3_sections_x-3-4.rpt
Attachment: jc_group_cost_code_rec_3_sections_x-3-3.rpt
Attachment: jc_group_cost_code_rec_2_sections_x-5.rpt
Attachment: jc_group_cost_code_rec_2_sections_x-6.rpt
Attachment: jc_group_cost_code_rec_3_sections_x-2-1.rpt
Attachment: jc_cost_code_reconciliation_cc_4_section.rpt

Steps to duplicate
Related Solutions

How do I read the Close Month Journal in Job Cost?