My Oracle Support Banner

EGL: Amounts on French VAT Report (VATX0200) are Not Formatted Correctly (Doc ID 2879541.1)

Last updated on JUNE 30, 2022

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Customer is stating that on the French VAT Report CA3 (VATX0200), the amounts are not in the correct French legal format.

For example, the amount of 3,456.67 is not accepted in France. It should be 3 457.

(1) There should be a space to indicate the thousands
(2) There should be no decimal point. The amount has to be rounded.

The document, The International System of Units (SI) from the Bureau International des Poids et Mesures, states the following:

5.4.4 Formatting numbers, and the decimal marker

Following the 9th CGPM (1948, Resolution 7) and the 22nd CGPM (2003, Resolution 10), for numbers with many digits the digits may be divided into groups of three by a space, in order to facilitate reading. Neither dots nor commas are inserted in the spaces between groups of three. However, when there are only four digits before or after the decimal marker, it is customary not to use a space to isolate a single digit. The practice of grouping digits in this way is a matter of choice; it is not always followed in certain specialized applications such as engineering drawings, financial statements and scripts to be read by a computer.

For numbers in a table, the format used should not vary within one column.

The document, DIRECTION GÉNÉRALE DES FINANCES PUBLIQUES / TAXE SUR LA VALEUR AJOUTÉE ET TAXES ASSIMILÉES (GENERAL DIRECTORATE OF PUBLIC FINANCE / VALUE ADDED TAX AND SIMILAR TAXES), which is from the French government website of impots.gouv.fr, states the following:

LES ARRONDIS FISCAUX
La base imposable et le montant de l’impôt sont arrondis à l’euro le plus proche. Les bases et cotisations inférieures à 0,50 euro sont négligées et celles supérieures ou égales à 0,50 euro sont comptées pour 1.

English Translation

TAX ROUNDINGS
The tax base and the amount of tax are rounded to the nearest euro. The bases and contributions below 0.50 euro are neglected and those greater than or equal to 0.50 euro are counted as 1.

STEPS
1. Navigate to VAT and Intrastat > Value Added Tax > VAT Processes > Transaction Loader
2. Populate the VAT Transaction Loader Rqst Run Control ID as follows:
    a.  VAT Entity = French VAT Entity
    b.  All Products box is checked
    c.  Business Unit = French Business Unit
3. Run the VAT Transaction Loader (FS_VATUPDFS) process
4. Navigate to VAT and Intrastat > Value Added Tax > VAT Processes > Process Report Extract
5. Populate the Process Report Extract Run Control as follows:
    a.  VAT Entity = French VAT Entity
    b.  Country = France
    c.  Report ID = CA3
    d.  Report Type = VAT Return
6. Run the VAT Reporting SQR Report
7. Navigate to VAT and Intrastat > Value Added Tax > VAT Reports > Return and Other Reports
8. Populate the VAT Report Run Control ID as follows:
    a. Language = French
    b. Print As = Draft Report
    c. VAT Entity = French VAT Entity
    d. Country = France
9. Run the VATX0200
10. Review the French VAT Report CA3 -- Notice in box 04, there is a comma, a decimal point, and the amount is not rounded to the nearest euro

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.