How to Override the Compliance Status of a Subcontractor  Document Overview  - This document is mostly used by Project Administrators   - Ability to view compliance status of each subcontractor per invoice per job    NOTE: Project Accountants do NOT update subcontractor compliance in CMiC. If compliance needs to be updated, it must be done by the Project Administrator.    Sample Compliance View Below.    Subcontract Management   Status  Over-ride Voucher Status      Enter Company number  Enter the Job number  Enter the Vendor number, or double click to search  Enter As of Date (optional)   Press Enter    Click the desired row of data so the cells turn blue (note: compliance changes will only be reflected on the selected row/invoice)  Click Compliance      Update Compliance items as needed  Click Save  Click Exit       

How to Reverse a Journal Entry  Document Overview  - Ability to undo a previously posted journal entry (reverses costs/labor)  NOTE: The original batch number of the previous journal entry is required.    Sample Report Below - Original Journal Entry.      Sample Report Below - Reversed Journal Entry.    Job Costing  Utilities   JC – Reverse/Recreate Posted JC Transactions       Enter the original journal entry batch number   Choose action: Reverse  Select Journal Code      Select the transacation  Click Process    

How to Run a Transaction Detail Log by Project  Document Overview  - Ability to filter total costs currently hitting a project by phase and category    Sample Completed Function Below.    Job Costing  Logs  Transaction Detail      Enter the Company number  Enter the Job number  Enter the Phase number (optional)   Click Apply Filter      Click Export to download the report; the report will generate as an Excel file      A new window will appear; when the report downloads, double click to open    

How to View a Summary of Subcontractor Compliance Status by Job   Document Overview  - View compliance status of subcontractors by job and compliance type   - View expiration dates of compliance items of subcontractors by job     Sample View Below.      Subcontract Management   Query   Compliance Summary Query        Enter Company number  Enter the project number in the Job/Picklist field  Click Populate    Select the desired row of information from either Compliance Groups or Compliance Cover Types  Click Drill Down      Review the Compliance item(s) in which the subcontractors are compliant/non-compliant on the job     

How to View All Voided Items in a Single Batch   Document Overview  - This can be useful as backup documentation   - Three reports will generate: Accounts Payable Voucher Void Report, Job Costing JC Posting Report and the General Ledger Posting Report    Sample Report 1 of 3 Below: Accounts Payable – Voucher Void Report            Sample Report 2 of 3 Below: Job Costing – JC Posting Report        Sample Report 3 of 3 Below: General Ledger Posting Report      Accounts Payable  Utilities   Print Posting Reports      Click the Query by Example search icon  Enter the batch number  Press Enter  Click Print    Click Run Report   

How to Void an Unpaid AP Invoice   Document Overview  - Can be useful when approved as an AP invoice but is part of a contract  - This is useful when paid via credit card payment    - Shows how to void when materials never showed up on site  - This is useful for when there is a duplicate AP invoice   - Can be useful when the invoice is invalid or requires a revision (missing sales tax, etc.)    Sample Report Below.    Accounts Payable  Voucher  Void Vouchers      Enter Company number  Click Create Batch  Input the Void Date  Input the Vendor number  Click Query      Click the Query by Example search icon  Input information in the search fields (invioce number, invoice amount, etc.)  Hit Enter      Check the white box in the Select column  Click Edit List to view the voided invoice  Click Void      Click Yes                   

How to View Category and Phase Codes Applied to a Project  Document Overview  - View all active and inactive phase and category codes on a project    NOTE: If a Phase and Category Code is missing and/or needs to be made active/inactive, contact the Financial Manager for assistance.     Sample View Below.  Category Code 71160 is setup under Phase Code 007420        Job Costing  Job  Assign Phases      Enter Company number  Enter the project number   Press Enter    Scroll through the list of Phase Codes assigned to the project  View which Phase Codes are active on the project       Choose a Phase Code to view the Category Codes setup under that Phase Code  Click Category Detail      Category Code 71160 is setup under Phase Code 007420  Click Close to exit   

How to View Subcontractor Vouchers and Payment Details by Job   Document Overview  - Ability to view all subcontractors on a specific job  - View all vouchers (AP invoices) per subcontractor on a specific job  - View voucher details (invoice amount, outstanding amount, change orders, retainage, due date, etc.) per subcontractor on a specific job  - Ability to view payment details per voucher (check number and date, amount paid)  - Ability to view outstanding retainage per subcontractor   Sample View Below.    Sample View Below: Payment Details.    Subcontract Management   Query   Executive Query by Job    Enter Company number  Enter the Job number  Click Query Data      Click Drill Down     Click the row of data of the desired contract/vendor to view vouchers  Click Vouchers      Click the row of data of the desired voucher to view payment details  Click Drill Down      Review payment details   

How to Void an Unpaid Subcontractor Invoice   Document Overview   - Ability to void a revised subcontractor invoice that was sent after the original was approved and posted  - Ability to void a subcontractor invoice that was approved in AP Workflow by error  - Shows how to void a duplicate subcontractor invoice    - Three reports will generate: Job Costing, Accounts Payable and General Ledger    Sample Report 1 of 3 Below: Job Coting – JC Posting Report.        Sample Report 2 of 3 Below: Accounts Payable – Voucher Void Report.      Sample Report 3 of 3 Below: General Ledger Posting Report.    Subcontract Management  Payments   Void Request for Payment      Enter Company number  Input the Voiding Date  Click Create Batch      Click the Query by Example search icon  Input the project information into the search fields (Vendor number, Voucher/Invioce number, etc.)  Press Enter      Check the white box in the Select column  Check “Print Reports” Immediately   Click Void      Select Yes to run reports (three reports will generate)      Click Run Report   

How to View Subcontractor Job and Payment History  Document Overview  - View all jobs subcontractors have submitted invoices on    - View invoice details (amount, outstanding amount, change orders, retainage, due date, etc.)   - Ability to view payment details per invoice (check number and date, amount paid)  - Ability to view outstanding retainage per subcontractor    Sample View Below.    Sample View Below: Payment Details.          Subcontract Management  Query   Executive Query by Vendor      Enter Company number  Enter the Vendor number  Click Query Data      Click Drill Down      Click the Query by Example search icon  Enter the invoice number and/or project number in the search fields   Press Enter    Click the row of data of the desired invoice/project to view  Click Vouchers    Click the row of data of the desired invoice to view payment details  Click Drill Down    Review payment details