• From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Topic: Recapitulative Statement Report

Businesses within the European Union are required to produce a report listing all invoices issued to clients (who have a VAT number registered in another country within the EU) on a quarterly basis. The report must include the VAT No of client, invoice no and value and date.

Is there a way to issue such a report in FA?
If not, which tables need to be accessed to extract such information?

TIA
Carmelo

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Recapitulative Statement Report

Well, the tax report gives that info and there is also a report in the sales called summary something.

/joe

  • From: Malta
  • Registered: 04/06/2012
  • Posts: 123

Re: Recapitulative Statement Report

Thanks Joe, right to the point.
Carmelo

  • From: South Africa
  • Registered: 11/24/2009
  • Posts: 274

Re: Recapitulative Statement Report

Joe

The sale summary report does not give you a list of invoices. Just a summary of total business for a given period with a particular client.

Is there a way to just get a list of invoices (Documents)  with invoice numbers and amounts for a given period.

Regards

Wynand

Wynand

seahawk's Website

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,089

Re: Recapitulative Statement Report

But the printed tax report lists all tax invoices, both for sales and purchases.

Joe

  • From: South Africa
  • Registered: 11/24/2009
  • Posts: 274

Re: Recapitulative Statement Report

Joe

If you are nor registred for VAT or GST then the reports is blank.

The report also does not give a break down per customer. It is more of a document listing or summary for all the documents created through the sales and purchases tabs. That would be Invoice; Credit Note; Purchase invoice and Supplier Credit not.

Make it easier to reconcile all the documents for the month.

The type of reports that I was looking at is Invoice summary report for period from and to:


Doc Nr:             Customer         Status           Tax Ecl      Tax        Tax Included
--------              ------------        ---------           ---------      ----        ----------------
1234                 ABC                 Invoice           123           12           1234
   
One could group it according to the Status or doc type.

Regards

Wynand

seahawk's Website