3 Replies Latest reply on Nov 27, 2011 11:34 AM by bumper

    Flat rates for labour

    tbcomputerguy

      Title

      Flat rates for labour

      Post

      Hi there, I am in the middle of an invoicing database for someone.  They have both labour rates and parts.  Both on their each portal on the invoice.  In some cases they wish to not enter an id for either a labour rate or part, they want to just enter some kind of a note and then charge a flat rate for the whole thing....kind of like a rate for a friend.  Not sure how to incorporate this into the program.  I thought about just having a flat rate table, like a parts table that can have records entered via a portal on a tab attached to the labour rates tab/portal.  But then i thought if nothing is is entered on the front tab how do i get the tab with the flat rate to show up on the invoice print out.

      A little guidance would be greatly appreciated.

       

      Dave

       

      I have attached a pic of the current invoice layout...set up as per client request

      ScreenHunter_02-Nov.-04-21.jpg

        • 1. Re: Flat rates for labour
          bumper

          One way would be to add a Flat Rate field to your Invoice table, then change the calculation of the Invoice Total to: 

          If ( Is Empty (Flat Rate); Total Labour + Total Parts ; Flat Rate) // the total calc is simplified, but you get the idea.

          This way all the actual costs are still in the appropriate tables. Might want to lock down the Flat Rate field so only a manager can access it. 

          • 2. Re: Flat rates for labour
            tbcomputerguy

            I have the theory of the invoicing, but what I am asking is, when entering a value the line items to pull over the products, i want to be able to select a line item for a flat rate.  Eg... bobs car should take 4 hours at 85 for labor costing 340, but i know bob and only want to charge him 275, how do I go about doing that?  Or can that be done.  Alson can i overwrite the price with out affecting the actual price?

             

            DAve

            • 3. Re: Flat rates for labour
              bumper

              I am assuming you have two tables for line items, one for parts and the other for labor? And you are not interested in give Bob a break on the cost of parts, but since he is your wife's brother-in-law you will give him a break on your labor costs. Next do you want the "break" to show in future reporting, ie, end of month labor costs, etc.?

              If the answer to the first question is no, consider doing so, if yes, then you have a couple of choices, one would be a line item in labor, give it a labor code number, call it discount, where you could enter a negative number that would reflect in the overall totals for labor costs by simply entering the amount of the "break" as a negative number. If you don't want to change the actual total of labor costs in the line items table, then repurpose my original suggestion, or:

              Create a just for show number field, normally this would show the sum of the labor costs, populate it via script, trigger or lookup. Include this field in the Invoice Total calculation instead of the real sum field, Total Labor. Then if you want to give a discount on labor since it is a number field you can easily overwrite it.

              The mechanics of what you are asking are not that difficult, the hard part is deciding how you want to account for the discount in the overall scheme of things. The owner may want to account for all the "breaks" and it even might be better to create a separate table just for these discounts.