CMiC Upgrade - Operations Accounting
-
How to Override the Compliance Status of a Subcontractor
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
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
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
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
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
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
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
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
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
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