JBA ML - Gl and World Trade

I wanted to pick everyones brains to see if you can
come up with any suggestions.

We have the scenario where we have multiple companies
in GL that are, in fact, the same legal entity.  This
legal company has 3 VAT Registration numbers for
warehouses that we have in 3 different EC countries.
Note that these logical companies are in all countries
and are not specific to a single country.

We need to produce a VAT return for each VAT
Registration number with the data being spread over
the 4 companies.

I am making the assumption that I am going to have to
write our own VAT return report program to consolidate
the data from the multiple companies.  Is this a
correct assumption?

Also, does anyone know how you can generate separate
VAT returns for each VAT registration number within a
company.  Note that in World Trade it allows you to
define the VAT Registration Number for each country.

Any thoughts.

Thanks for your help.

__________________________________________________
Do You Yahoo!?
Send FREE video emails in Yahoo! Mail!
http://promo.yahoo.com/videomail/