Open invoices report with items
Jeremy_9364289
Member Posts: 4 Novice Member
HI all,
I'm using Reckon accounts HOSTED 2017.
I want a report of our open invoices that includes the items in each invoice.
So like this:
John Smith Invoice no 202311
1 lot of work @ 2.00
2 hrs of labour @ 20.
Total invoice : 22.00
Any Ideas?
I'm using Reckon accounts HOSTED 2017.
I want a report of our open invoices that includes the items in each invoice.
So like this:
John Smith Invoice no 202311
1 lot of work @ 2.00
2 hrs of labour @ 20.
Total invoice : 22.00
Any Ideas?
0
Comments
-
Hi Jeremy,
Welcome to the Reckon Community!
I understand what you're trying to achieve but from what I have tested, it's all possible except for showing a total for each individual invoice.
Please see below what I've done:
1. Reports > Custom Transaction Detail Report
2. Modify Report
3. Columns > Item
4. Total by > Customer
5. Sort by > Num
6. Select the 'Filters' tab
7. Select the 'TransactionType' filter and from the drop-down menu select 'Tax Invoice'
8. Select the 'Paid Status' filter and from the radio buttons select 'Open'
9. Click OK
The report will then generate every open invoice with each individual line on the invoice, but it will total every invoice by the customer, instead of each invoice. I can't see a way for it to total for each invoice.
I hope this helps somewhat.
Luke.
2 -
Nice to see someone knows how to utilise the buit-in report writer!!!!!
1 -
Wonderful Luke. THANK YOU!
1
Categories
- All Categories
- 6.7K Accounts Hosted
- 16 📢 Reckon Accounts Hosted - Announcements
- 6K Reckon Accounts (Desktop)
- 7 📢 Reckon Accounts Desktop - Announcements
- 1.4K Reckon Payroll
- 33 📢 Reckon Payroll - Announcements
- 21 Reckon Payroll Help Videos 🎥
- 25 Reckon Mate App
- 2.6K Reckon One
- 9 📢 Reckon One - Announcements
- 12 Reckon Invoices App
- 15 Reckon Insights
- 99 Reckon API
- 308 Point of Sale
- 1.9K Personal Plus and Home & Business
- 68 About Reckon Community