modifying open invoices report to show "Other" label field but can't find it in the list

Michele Shay_7255399
Michele Shay_7255399 Member Posts: 4
edited September 2019 in Reckon Accounts (Desktop)
I am trying to create an open invoice report that shows the "Other" label field I used when creating our invoice template. This contains information specific to our company that did not fit any other field type. Other is not listed in the drop down list for modifying report. Is there somewhere I need to activate it for use?

Comments

  • Jason Jiao
    Jason Jiao Alumni Posts: 29
    edited July 2015
    Hi Michele,

    Unfortunately those two fields cannot be populated in Reckon Accounts' reports. I have sent through the feature request to our development team.

    As a workaround, can you set up Custom fields for Items and add them to the invoice template?
    1. Set up the custom field for a item:
    • From the Lists menu, select Item List.
    • Double-click any item to open the Edit Item window.
    • Click Custom Fields and then click Define Fields.
    • Enter the name that you want to use in the Label field and leave the default value blank
    • Click OK three times to save the data
    2. Add the item custom field as a column to a Invoice Template
    • From the Lists menu, select Templates.
    • Double-click on the template you wish to change.
    • Click on Additional Customisation.
    • Click the Columns tab
    • Select the custom field that you created above.
    • Click OK.
    3.Now you can customise the Open Invoice Report to display the data.

    Hope it helps.

    Cheers
    Jason
  • Michele Shay_7255399
    Michele Shay_7255399 Member Posts: 4
    edited September 2019
    Tried it but couldn't get any data to display in the column on modified report.
  • Jason Jiao
    Jason Jiao Alumni Posts: 29
    edited July 2015
    Sorry Michele, the open invoice report only shows the transactions' header or summary of the tax invoice whereas the columns are associated with the line items. Do you require the 'Other' field attached to the invoice header or items?
      image

    If you require it attaching to the invoice, can you create a custom field on the customer record (Additional Field tab>Define Field of the Custom Fields section)? Then you can customize the Template and the Open Invoice Report to display the data.

    If you need it for the items, can you to customise the report by going to Filter tab>Account in the choose filter box>select Yes for include split details? This will display the custom field information for the items. However this gives incorrect open balance numbers as the split line items are included in the report.

    Hope information helps what you are trying to achieve.

    Thanks
    Jason


  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited November 2016

    Thanks JasonJ .... Have been trying to do this myself & have discovered the crucial success lies in 2 steps: 

    1. Create this custom COLUMN by adding a "Custom FIELD" (Label only) on an Item.  Next, click on the "Modify Report" tab on your displayed report (eg for you Michele, "Open Invoices")
    2. On the "Display" tab, in the "Columns" list, TICK your custom-created Item field (Label) which should be listed (even though it's actually a template "column"!)  Click "OK" again on the "Modify Report" main window (to save your modifications)

    (This also eliminates the split issue Jason describes below when opting to show split details for accounts instead)


    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!)
  • Helen Gaffney
    Helen Gaffney Member Posts: 3
    edited October 2016
    Hi Shaz Would I be correct in saying that it will only work with new data going forward.   Would you know a way to report on an 'other' label field already setup and appearing on invoices that has not previously been customised as you suggest.
  • Acctd4
    Acctd4 Accredited Partner Posts: 3,366 Reckon Accounts Hosted Expert Reckon Accounts Hosted Expert
    edited November 2016

    Hi Helen

    Yes, you're correct in that it will only populate going forward.

    For reporting on a previously-set-up "Other" label ..... 

    Is this a Custom Field or a Custom Column? 

    Check exactly what "Label" it is in the your invoice template (on the "Additional Customisation" tab & "Layout Designer")    Depending on how it was setup, it might be listed in the Custom Filters or Columns on the "Display" tab in "Modify Report."  (Although you may have named it something else, the actual Label/Column you're using may be under another default title in RA!) 


    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!)