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.

  • 0 in reply to Char DeLange

    The billing rates were removed from the equipment records.  Looking back at the original screenshots, why doesn't the equipment unit and billing quantity pre-populate on the T&M Billing tab?  Will these two items always need to be manually entered when calculating T&M billings?

  • 0 in reply to melliott

    I need to see the other screen shots.  They are supposed to automatically populate if you have it set up correctly.  It works just like the labor rate file

  • 0 in reply to Char DeLange

    How do I add additional screenshots to the reply?

  • 0 in reply to melliott

    Select the "Use Rich Formatting" option below and you'll be redirected to a Reply page that allows you to upload pics.

  • 0 in reply to melliott

    The equipment rate table looks ok but the job cost record has no t&m hrs/quantity for it to calculate the billing amount. Hrs x rate = billing amount

  • 0 in reply to Char DeLange

    That is exactly what the original question was.  Shouldn't the hours and quantity on the T&M billing tab of the job cost record auto-populate based on the equipment usage (hours and quantity) on the job cost record?  Having to manually enter the data is not an efficient use of time.

Reply Children