Multiple reps in Quickbooks

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sterne.law@gmail.com
    Platinum Member

    • Oct 2009
    • 1332

    #1

    Multiple reps in Quickbooks

    A manufacturing company needs to track 2 specific things.
    The sales rep and
    the technician that worked on a job.
    They want to pull a repost saying that technician X did R2000 worth of work.

    Other than timesheets and class tracking, any ideas how to go about this?
    Anthony Sterne

    www.acumenholdings.co.za
    DISCLAIMER The above is merely a comment in discussion form and an open public arena. It does not constitute a legal opinion or professional advice in any manner or form.
  • CLIVE-TRIANGLE
    Gold Member

    • Mar 2012
    • 886

    #2
    The rep part is simple; Reports->Sales->Sales By Rep Detail or Sales By Rep Summary.
    Alternatively, any revenue report can be selected and at the top bar there is a selection for "columns" and you can use the dropdown to selct rep.

    As regards the technicians, it depends on what method was used to differentiate the various technicians. I would assume on item code. If that is the case, then in either of the reports above you can select "Item" to reflect in the report. Then mess about with the "Sort By" option to improve the display and totalling.

    Alternatively again, you can use any revenue report and select the Filter tab and simply apply rep and technician filters to the output.

    Comment

    • HR Solutions
      Suspended

      • Mar 2013
      • 3358

      #3
      You can also use the "class"

      Comment

      • sterne.law@gmail.com
        Platinum Member

        • Oct 2009
        • 1332

        #4
        I class is an option.
        What I have done is add a custom field on invoice, which I then use as a filter.
        Assigning a rep is clear.
        Cant assign technician to an item because it will differ from time to time.
        Custom field is spot on except no dropdown list
        Anthony Sterne

        www.acumenholdings.co.za
        DISCLAIMER The above is merely a comment in discussion form and an open public arena. It does not constitute a legal opinion or professional advice in any manner or form.

        Comment

        • Dave A
          Site Caretaker

          • May 2006
          • 22803

          #5
          Originally posted by sterne.law@gmail.com
          Custom field is spot on except no dropdown list
          Drop downs are available for custom fields in QuickBooks Enterprise (max. 100 preset per custom field).

          However, I recommend you stick to using Class (and perhaps subclass) listings to track technicians / teams. This way you can track income and expenditure down to the individual technician level rather painlessly.

          Originally posted by sterne.law@gmail.com
          Cant assign technician to an item because it will differ from time to time.
          You can assign a class to individual line items
          Just make sure the template has the Class column displayed.

          If the challenge is separating a class in a report (e.g. Sales by Item Summary), click Customise Report, select the filters tab, select Class and change the setting from All to the class you want to examine.
          Participation is voluntary.

          Alcocks Electrical Services | Alcocks Pest Control & Entomological Services | Alcocks Hygiene Services

          Comment

          • sterne.law@gmail.com
            Platinum Member

            • Oct 2009
            • 1332

            #6
            Thanks guys.
            I am inclined to use class tracking, it's a powerful filtering tool.
            Anthony Sterne

            www.acumenholdings.co.za
            DISCLAIMER The above is merely a comment in discussion form and an open public arena. It does not constitute a legal opinion or professional advice in any manner or form.

            Comment

            Working...