How to get the detail of each invoice on a report?

Question

Can anyone help how to get the detail of each invoice on a report so that I don't have to print out each invoice? I haven't been able to find where to get all this detail on any other reports. I can find where to get a line item of each invoice showing item no. and item description, along with customer name and prices charged.

There is one in General Ledger for sales, but no items or item descriptions, it does give the reference no. but that isn't enough.

And under  customer reports, also cannot find any with items and item descriptions per invoice number.

Under reports for items, this doesn't include where they were invoiced or any other details on an invoice, so no good there either.

Need this because Reckon One have decided not to allow access to discontinued books, even though we currently use another book.  We've only got 60 days to do this.

many thanks,

Jean_10862158 · Answer

Hi @Reeta

Wow, I never noticed this one before, nor what was in "advisor" before.  This report almost does what I want. The only missing thing is the "reference code" which is above the line items.  Also I didn't see how to exclude payment receipts. I could filter them out in excel I suppose.

I could supplement it with one of the other reports that includes the reference code, so that we would need to refer to 2 separate reports when looking back.

Because we last paid for the book in July 25 to cover July to Aug, with only 5 months since and now read access is getting shut down seems to me not very nice, especially that 9 months ago when deciding on all this, one attraction was that we would always have access, at least for the 5 years that the Australian Taxation Office requires records to be kept.

Jean_10862158 · Answer

Because all this data is on a discontinued book which R1 cancelled a few days ago with no access, except I was able to get another 60 days so that we could download this data.

Why? Because we had a case this week where we wanted to look back at a particular customer's invoices to see what we had charged out, ie the line items in particular.  But other than printing all the invoices I could not see how else to do it.

The invoice list has no option to print the line items.

It is only customers' invoice information that we want, not the whole general ledger.

Eric Murphy · Answer

Just print the invoice list report and add all of the additional columns.

Why on earth would you want to see all of the items within an invoice on a report. It would be incredible unwieldy