modifying open invoices report to show "Other" label field but can't find it in the list
Comments
-
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
- 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.
Hope it helps.
Cheers
Jason0 -
Tried it but couldn't get any data to display in the column on modified report.
0 -
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?
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
1 -
Thanks JasonJ .... Have been trying to do this myself & have discovered the crucial success lies in 2 steps:
- 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")
- 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
(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!)
1 -
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.
0 -
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
(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!)
0
Categories
- All Categories
- 6.4K Accounts Hosted
- 10 📢 Reckon Accounts Hosted - Announcements
- 5.9K Reckon Accounts (Desktop)
- 3 📢 Reckon Accounts Desktop - Announcements
- 1.3K Reckon Payroll 🚀
- 21 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 21 Reckon Mate App
- 2.9K Reckon One
- 7 📢 Reckon One - Announcements
- 10 Reckon Invoices App
- 14 Reckon Insights
- 107 Reckon API
- 822 Payroll Premier
- 307 Point of Sale
- 1.9K Personal Plus and Home & Business
- 62 About Reckon Community