Changing a report to view by date NOT transaction number

[carolinei]

Hi all,

I am ok-ish with the report designer, can find my way around it etc, but I now need to be able to show my Customer Reports, Day Book Reports, Invoices paid by date paid and not the transaction number.

The reason being - I have just noticed that we are set up for standard vat accounting and should be cash accounting, so my VAT for the last year is incorrect. I need to be able to print a report by date of paid customer invoices, so I can cross reference with my bank statements to ensure I haven't missed any and that when I do my adjustments that we are OK.

Some of our products you see are nil VAT as they are supplements, feeds and clothing - thats why I cannot just work off the bank statements, and because we deliver to the UK and Europe. (We are based in Ireland)

Any help on this would be great as I want to pull my hair out right about now.

Rgds

Caroline

[Donna]

hi Caroline,

do you enter transaction dates when you are about to generate a report?

when i do this it lists all the transactions during the period i enter by the date.

Donna