add extra field on invoices similar to sales rep

Options
Brendan_7435685
Brendan_7435685 Member Posts: 4 Novice Member Novice Member
edited May 5 in Accounts Hosted

Hi, I am wanting to add an additional field in our invoices similar to sales REP, however instead of being for sales people, it is for installers, to track productivity of field staff. I also would like to be able to run a report on this similar to 'sales by rep summary'. Is there any way to do this? I have searched but found no tips on this type of scenario. Thanks

Answers

  • Tanvi_kataria
    Tanvi_kataria Reckon Staff Posts: 462 Reckon Staff Reckon Staff

    Morning @Brendan_7435685

    You can add/remove the field within the Template Customization. In Layout Designer within the template will allow you to make changes to the template as required. Please check this out - How to edit the Description Data field on a customised payslip template? — Reckon Community

    For the reports, we can simply generate a report and modify it as per your requirements. Let me take a look and will get back to you with the most similar report that can be of any help.

    Please feel free to let us know if any concerns. Thank you!

    Regards

    Tanvi

  • Brendan_7435685
    Brendan_7435685 Member Posts: 4 Novice Member Novice Member

    Hi Tanvi, thanks for the reply.

    I have already found that page for 'additional customisation', but it doesn't quite give me what i want.

    I am trying to add another field (or call it a duplicate field perhaps) for the Rep:

    image.png

    Ideally I would like to cal it something else.

    I can use the same data bank of employees for both the new field I want to add, and the existing Rep field.

    But i want to be able to run a separate report for the new field, in the same way as I do for the rep field.

    I already have the REP option selected as being shown on screen, I essentially need to do this again but with a different title:

    image.png
  • Acctd4
    Acctd4 Accredited Partner Posts: 4,004 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Hi @Brendan_7435685

    Use Custom Fields for Customers:

    image.png

    (Once you add it, it will add this new label in ALL Customer records 😊)

    … & you will then see that label added in the invoice customisation:

    image.png

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Brendan_7435685
    Brendan_7435685 Member Posts: 4 Novice Member Novice Member

    Hi Acctd4

    That is looking closer, thank you, I have done as you instructed.

    Am I able to pull from the same list of employees/sales reps using a pull-down menu like for the actual sales reps? I can just list all employees as sales reps when they are sometimes installers.

    Likewise I would like to create a report once this is implemented, I have had a look but can't see anywhere that 'installer' is listed anywhere now as a reporting option.

    Thnx

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,004 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Hi @Brendan_7435685

    " … Am I able to pull from the same list of employees/sales reps using a pull-down menu like for the actual sales reps ..?"

    Unfortunately not, as it's a manual field only 😬

    " … can't see anywhere that 'installer' is listed anywhere now as a reporting option …"

    Once added to forms as a Custom Field, you will see it on applicable reports as a Column option on the Display tab under Modify Report

    image.png

    You can also filter for a particular ("Installer") entry on the Filters tab:

    image.png

    😊

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)
  • Brendan_7435685
    Brendan_7435685 Member Posts: 4 Novice Member Novice Member

    Thank you, that works.

  • Acctd4
    Acctd4 Accredited Partner Posts: 4,004 Reckon Accounts Hosted Elite Expert Reckon Accounts Hosted Expert

    Good to hear @Brendan_7435685 ! 👍️🙌

    Shaz Hughes Dip(Fin) ACQ NSW, MICB

    *** Reckon Accredited Partner (AP) Bookkeeper - specialising EXCLUSIVELY in Reckon Accounts / Hosted ! ***

    * Regd BAS Agent (No: 92314 015)* ICB-Certified Bookkeeper* Snr Seasonal Tax Consultant since 2003 *

    Accounted 4 Bookkeeping Services

    Ballajura, WA

    shaz@accounted4.com.au

    https://accounted4.com.au

    (NB: Please give my post a Like or mark as Accepted Answer if I have been able to resolve your query as this helps others when seeking solutions!)