Changing a report to view by date NOT transaction number
Posted: 15 Feb 2011, 14:31
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
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