Re: Intrastat and EC reports

["Tony Cregg" <tony.cregg@xxxxxxxxxxxxxxxxxxxx>]

Peter,

We tested INV400 in a multi-company environment on V6004 and discovered
numerous weaknesses, including:
  a.. A summary report was provided with no detailed audit trail. We were
uncomfortable about presenting a report to the tax authorities if we was
unable to trace back to the individual transactions being reported.
  b.. INV400 compares the country of receipt with the country selected for
reporting.  Any transactions where these do not match are included in the
report.  This caused issues in our multi-country envrironment, where INV400
included goods shipped from our French company to a French warehouse on the
UK Intrastat report.
  c.. INV400 is based entirely on inventory transactions at order cost,
whereas the reports should be produced at invoice cost.
  d.. INV400 makes no provision for the different Intrastat requirements in
the different EU countries.
  e.. The version of the program that we tested reported in currency, but
did not indicate which currency it was.  We also found that it added
together values in different transaction currencies.
We decided to abandon the INV400 reports and generated our own Intrastat
reports, driven from the tax tables.

SYS240 and SYS250 are cumbersome reports and bear no resemblance to the EU
reporting requirements.  Again, we found that it was more effective to
generate our own reports in the appropriate format for each country.

We believe that you must be able to reconcile any Intrastat reports or EC
sales lists with your tax reports.  To achieve this you need to implement a
robust VAT table that resolves different tax rate codes for local supplies,
EU supplies of goods, EU supplies of services, and supplies outside the EU.
These tax rate code can then be used to drive your EU reporting.

Contact me off-line if you require any more info

regards

Tony Cregg
ESS Ltd
ESSENTIAL FINANCE
Built by Finance Professionals for Finance Professionals

Mobile: + 44 (0) 7803 116 258
Email address: tony.cregg@xxxxxxxxxxxxxxxxxxxx
Web page: www.essentialfinance.net

----- Original Message ----- 
From: "Peter Haluska" <haluska@xxxxxxxxxx>
To: "SSA's BPCS ERP System" <bpcs-l@xxxxxxxxxxxx>
Sent: Tuesday, March 30, 2004 9:12 AM
Subject: Intrastat and EC reports


> Hi all,
>
> have somebody experience with EC Intrastat report (inv400) and EC-Sales
and
> Acquisitions lists(sys240,250)?
> We use v6004 july 99cum MM.
> Intrastat report is empty (but with 0 errors).
> What is necesery to set up or fullfill?
>
> Thanks
> Peter
>
> _______________________________________________
> This is the SSA's BPCS ERP System (BPCS-L) mailing list
> To post a message email: BPCS-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/bpcs-l
> or email: BPCS-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/bpcs-l.
>
>