...

Anchor
job_cost_adding_subcontractors_t_6393 job_cost_adding_subcontractors_t_6393

Anchor
job_cost_adding_subcontractors_t_1600 job_cost_adding_subcontractors_t_1600

Adding subcontractors to a job record

Adding subcontractors to a job record involves the following:

Step 1: Assign a subcontractor to a job

You can enter information to a job regarding your vendors and subcontractors in the Subcontractors Maintenance window. The vendor record must exist in Microsoft Dynamics GP before it can be added to a Job Cost record.

1. Choose Cards > Job Cost > Job.
2. Choose a job, then choose Subs/Vendors.
3. Complete the following fields, as necessary.
   • Job Vendor, Address
     Enter a job vendor, or choose Add Vendors to choose a vendor and let the Job Vendor and Address fields default from the vendor record.
   • Hold
     This check box checkbox is used with the Advanced Subcontractor feature. For more information, see Advanced subcontractor feature.
   • Vendor Contract Type
     Choose a vendor contract type from the drop-down list. Choices are NTE, Lump Sum, and Unit Price.
   • Contract Date, Purchase Order #
     Enter the Contract Date and Purchase Order Number.

   • Retention %
     This amount defaults from the Job Maintenance record. You can choose the expansion button to open the Retention window, which allows you to specify a maximum retention amount for the current contract. Enter a Maximum Percent of Contract Amount Withheld and choose OK. The retention withheld percent will be withheld from the subcontractor's invoices until the maximum retention amount is reached. Once the maximum amount is withheld, no more retention will be withheld for the subcontractor on the job. 

     Note
     Retention will not be withheld if a job has a billing type of SOP.

     
     

   • Mod Rate
     Enter the modification rate of the contractor. This field is informational only.
   • User-defined
     Enter user-defined information. These fields are informational only.
   • Bonded, Lien Waiver on File, Insurance Certificate, Insurance Expr. Date
     Mark these check boxes checkboxes if applicable. If the Insurance Certificate check box checkbox is marked, the Insurance Expr. Date field is enabled. Enter the date the insurance expires.
   • Submit Date, Resubmit Date, Approved Date, Disapproved Date
     Enter the submit date, resubmit date, approved date, and disapproved date.
   • Original Contract Amt
     Enter the original contract amount. This amount will be used to calculate the amended contract amount after any change orders. For information on fields automatically updated, see Viewing updated subcontractor information.
4. To print the Subcontractor Status report, choose File > Print.
5. Choose Save.

Step 2: 

Anchor
job_cost_adding_subcontractors_t_820 job_cost_adding_subcontractors_t_820

Assign a subcontractor to a cost code.

The subcontractor must be assigned to a cost code for retention to be calculated.

1. Choose Cards > Job Cost > Job.
2. Choose a job, then choose Cost Codes.
3. Choose Add Cost Codes to add a cost code for the subcontractor on the selected job. You must add a cost code with a cost element other than Labor.
4. From the Transaction Type drop-down list, choose Vendor ID. The Transaction Type drop-down list is only visible when a cost code with a cost element other than Labor is displayed.

5. Choose a Vendor. Accounts payable or purchase order transactions posted to a subcontractor cost code will automatically have retention withheld, based on the retention percent assigned to the subcontractor in the Subcontractors Maintenance window. 

   Note
   You can assign numerous cost codes to a vendor, but only one vendor to a cost code. You can assign more than one vendor to a cost code using the Advanced Subcontractor feature.

   
   

6. Choose Save.
7. Close the Job Cost Codes Setup window.
8. Choose Save in the Subcontractors Maintenance window and the Job Maintenance window.

Anchor
job_cost_distributing_a_payable__6246 job_cost_distributing_a_payable__6246

Distributing a payable to a job and cost code

When the vendor's invoice arrives for payment, you must create a payables transaction and distribute the invoice to the correct job and cost code. This allows retention to be withheld.

...

Anchor
job_cost_releasing_a_payables_ho_578 job_cost_releasing_a_payables_ho_578

Releasing a payables hold

If the Pay When Paid option is marked in the Subcontractor Setup window and a vendor's invoice has been distributed to a Job and a Cost Code, the transaction record is marked on payment hold. You can release the hold on the payables transaction after you have been paid by the customer and are ready to pay the subcontractor.

1. Choose Transactions > Job Cost > Subcontractor Payments.
2. Choose a Job.
3. In the scrolling window, choose Mark All or mark individual transactions to release. To view transaction information, choose the document number of a marked transaction and zoom on the Apply to Document field. In the Payables Transaction Entry Zoom window, you can choose the Distributions button to view distribution information.
4. Choose Process in the Subcontractors Payments window. A message appears asking if you are sure you want to process the payments. Choose Process. The hold on the payable is released so the subcontractor can be paid with the next check run.

Anchor
job_cost_generating_retention_in_3258 job_cost_generating_retention_in_3258

Generating retention invoices

Once the subcontractor's job is complete to everyone's satisfaction, the retention amount can be paid.

1. Choose Transactions > Job Cost > Subcontractor Retention.
2. Choose a Job.
3. In the scrolling window, mark individual retention invoices or choose Mark All to create retention vouchers in Payables Management. To view information on a transaction, choose the document number of a marked transaction and zoom on the Apply to Document field. In the Payables Transaction Entry Zoom window, choose Distributions to view distribution information.
4. Choose Process in the Subcontractors Retention window. A message appears asking if you are sure you want to process the retention transactions. Choose Process. This creates a payables batch with the user ID as its name. A payable voucher is created for each marked item. You can process a portion of the retention amount in increments by entering an amount in the Retention % field before choosing Process; only that partial amount will be processed.
5. Post the batch in Payables Management. See the Microsoft Dynamics GP Payables Management Manual for more information.

Anchor
job_cost_viewing_updated_subcont_7681 job_cost_viewing_updated_subcont_7681

Anchor
job_cost_viewing_updated_subcont_9427 job_cost_viewing_updated_subcont_9427

Viewing updated subcontractor information

After the subcontractor's job is complete and retention invoices have been generated, the Subcontractors Maintenance window is updated to record the vendor and retention invoices. The Vendor Invoices field shows the total of all vendor invoices posted. The Retention Withheld field shows the total retention amount of all posted invoices. The Retention Invoices field represents the retention invoices that have been processed. The Total field shows the total vendor invoices.

1. Choose Cards > Job Cost > Job.
2. Choose a job, then choose Subs/Vendors.

Anchor
job_cost_reconciling_jobs_with_s_834 job_cost_reconciling_jobs_with_s_834

Reconciling jobs with subcontractors

You can run the reconcile procedure for jobs with subcontractors or vendors to verify the information in transaction open files. Reconciling adjusts the totals in the master files if a discrepancy exists, and identifies posted transactions that contain invalid data. You can reconcile for a specific job, a range of jobs, or all jobs that have subcontractors. Back up your Job Cost data files before running reconcile. Make sure no one is logged into Microsoft Dynamics GP when you reconcile Job Cost data files. If other users are logged in, an alert message appears, and the Job Cost reconcile process will not run to completion.

...