Welcome to The Forum SA. As a visitor you have read only access to the public content areas of this website. You will have to register as a member to access all content, post messages and network with our members. Membership is free and registering is quick and easy. You can click here to register now and become a member within minutes.
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.
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.
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.
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.
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.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, personalize advertising, and to analyze site activity. We may share certain information about our users with our advertising and analytics partners. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.
Comment