Equipment Use and T&M Billing on 6-3

SUGGESTED

We're using Sage 100 version 19.2.

When doing T&M billing with equipment costs, we generally have entries in 6-3 that do not have Equipment Unit and Billing Quantity populated on the T&M billing tab, requiring manual entry of data.  The equipment rate table is set up by equipment type (ie. type 10 = Vehicles; 20 = Skytrak, etc.).  Equipment usage is tracked through daily payroll (5-1).  What needs to be done to auto-populate the T&M Billing tab on 6-3?  Some screenshots are attached to clarify.  Thank you.

12_4_14 Screenshots T&M Billing.docx
Parents
  • 0

    You do have to assign the rate tables to the jobs.  Please send screen shots of the equipment rate table and the T&M rate screen for the job.

    When setting up a job for T&M billing, you can:

       Assign separate overhead and profit markup rates to each cost type.

       Assign a shown markup rate to each cost type.

       Assign a hidden markup rate to each cost type. When you calculate T&M invoices, Sage 100 Contractor adds the hidden markup to the job cost. The other markups shown, overhead and profit, are computed on top of the new billing amount. The hidden markup does not appear on the T&M invoice.

       Assign wage rate and equipment rate tables to the job. You can use the tables in place of using labor and equipment costs plus hidden markup. In addition, you can set a minimum daily charge, which is the minimum number of hours per laborer , or you can set the minimum units per piece of equipment to charge.

    Suppose you own a backhoe and determine it is necessary to charge a minimum of three hours to recover the costs of ownership, maintenance, and mobilization. At a job site, you only use the backhoe for one hour. When you allocate the equipment use, Sage 100 Contractor bills the client for three hours instead of one.

    Consider the following additional points:

       If equipment records contain rental billing rates, Sage 100 Contractor creates the job cost with the rental billing rate in the Billing Amount text box and with the Override check box selected. The program uses this amount when calculating the T&M Invoices even if an Equipment Rate table is selected for the T & M job.

       If you want to use the T & M Equipment Rate table you must either: (1) clear the Override check box on the job cost record and exclude billing rates from the equipment record before the job cost records are created; or (2) enter the job cost record directly into 6-3 Job Cost record.

       If equipment records do not contain billing rates when you calculate the T & M invoices, Sage 100 Contractor replaces the billing amount with the rate from the Equipment Rate table. If an Equipment Rate table is not assigned to the T&M job, Sage 100 Contractor replaces the billing amount with the cost plus hidden markup.

Reply
  • 0

    You do have to assign the rate tables to the jobs.  Please send screen shots of the equipment rate table and the T&M rate screen for the job.

    When setting up a job for T&M billing, you can:

       Assign separate overhead and profit markup rates to each cost type.

       Assign a shown markup rate to each cost type.

       Assign a hidden markup rate to each cost type. When you calculate T&M invoices, Sage 100 Contractor adds the hidden markup to the job cost. The other markups shown, overhead and profit, are computed on top of the new billing amount. The hidden markup does not appear on the T&M invoice.

       Assign wage rate and equipment rate tables to the job. You can use the tables in place of using labor and equipment costs plus hidden markup. In addition, you can set a minimum daily charge, which is the minimum number of hours per laborer , or you can set the minimum units per piece of equipment to charge.

    Suppose you own a backhoe and determine it is necessary to charge a minimum of three hours to recover the costs of ownership, maintenance, and mobilization. At a job site, you only use the backhoe for one hour. When you allocate the equipment use, Sage 100 Contractor bills the client for three hours instead of one.

    Consider the following additional points:

       If equipment records contain rental billing rates, Sage 100 Contractor creates the job cost with the rental billing rate in the Billing Amount text box and with the Override check box selected. The program uses this amount when calculating the T&M Invoices even if an Equipment Rate table is selected for the T & M job.

       If you want to use the T & M Equipment Rate table you must either: (1) clear the Override check box on the job cost record and exclude billing rates from the equipment record before the job cost records are created; or (2) enter the job cost record directly into 6-3 Job Cost record.

       If equipment records do not contain billing rates when you calculate the T & M invoices, Sage 100 Contractor replaces the billing amount with the rate from the Equipment Rate table. If an Equipment Rate table is not assigned to the T&M job, Sage 100 Contractor replaces the billing amount with the cost plus hidden markup.

Children