Common data > Common tables > Taxes > Tax rates 

Use this function to define the codes for tax rates that can be applied to sales and purchases.
In the Sales and Purchasing modules, the codes used are defined in the Tax determination function by crossing the BP Tax rule with the product Tax level.

SEEREFERTTO See the documentation on Tax determination for further information.

Prerequisites

SEEREFERTTO Refer to documentation Implementation

Screen management

Information from the first table

This table is used to determine a set of rates on a given date and possible rates by company.

  • If lines defined for the current company exist, these lines are not taken into account. If not, the lines for which the company code is blank are used.
  • If several lines exist, the line containing the most recent date that is prior to the date of the movement is taken into account.

Information from the second table

This table is used to define analytical allocations for each dimension type.

When setting up default dimensions, these allocations can be used to specify the dimensions used in posting entries linked to the various management processes such as sales, purchases, and fixed assets.

Entry screen

Fields

The following fields are present on this tab :

Block number 1

This field is used to define a tax code.

Enter or select the legislation code of the company.

When launching the VAT declaration extraction on a VAT entity (within the VAT framework) or on a company (outside the VAT framework), the VAT box setup needs to be compliant with the legislation of the head company as defined in the VAT entity or of the given company.

As a result, when a given VAT declaration needs to be run on VAT entities or companies of different legislations, several VAT box setups must be entered for the same VAT declaration and these legislations.

Example: DCLVATFRA+FRA and DCLVATFRA+BEL

When the French VAT declaration must be run on a French VAT entity and also on a Belgium VAT entity.

For Australian VAT declaration only: Affiliated companies submit GST and BAS data as a group, defined in GST groupings. One member of the group must be designated as the Head entity, representing the group as a single entity for tax purposes.

  • Description (field DESAXX)

This long description is used as a title in screens and reports.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFOThe connection language must be defined as a default language for thefolder.

  • Short description (field SHOAXX)

Short title used in the screens and reports. This title is recorded in your connection language.

By default the short title, the long title or the column header of a data are recorded (on creation/update) in the connection language of the user.
You can add your translation in another language using the Translation function:

  • Click Translation from the Actions icon in the corresponding field.
  • In the Translation window, add a new language code with the translation in this language.

A user who logs on with this language will view the short description, long description or column header in their connection language if a translation exists. Otherwise, these descriptions will be available in the folder language.

SEEINFOThe connection language must be defined as a default language for thefolder.

Use this field to access the different site/company groups available.
The group entered in this field allows you to filter the information displayed and to guarantee consistency of the function setup, but it is mainly used to have exceptions for several companies regarding a tax rule application.

By entering a company group, you can limit the scope to companies in the selected group only. When this data is used for another record or with a setup element also defined in the group, a control checks that the groups have at least one company in common when the groups are different.  

In addition, a consistency check is performed for the legislations of the companies in the selected group.
At least one of these companies must have the same legislation as the one entered in the Legislation field. If  not, a warning message displays.

Block number 2

  • Tax type (field VATTYP)

A tax code can be used to identify several tax types:

  • VAT (Value Added Tax): based on the excl.-tax amount
  • Additional tax: based on the excl.-tax amount on the quantity or any other item of a document line
  • Special tax: based on the excl.-tax amount on the quantity or any other item of a document line
  • Local tax: See below.

SEEINFOFor a Special tax or Additional tax, select the Subject to VAT check box if the tax type is subject to a VAT.

Local tax

Application

This type of tax is not managed in France.
It is applies to Canada and Argentina.

Prerequisites

The PTX - Tax rates implementation activity code must be activated beforehand.
To manage Argentine local taxes, the KAG - Argentinean activity code must be active.

Principle

Taxes on the document footer are applied according to the region of origin and/or destination.
This feature can be extended to other cases: The local taxes depend on information from the TAXLINK table. They can be used as additional taxes in the document footer. This particular case is useful for preventing the tax from being transferred directly into the table.

Location
  • In the Sales module, the local tax is displayed directly on the invoice footer.
  • In the Purchasing module, the four additional tax codes are displayed on the line and can be modified.
    SEEWARNINGIf the number of taxes is limited for sales, you cannot specify more than four taxes in purchasing lines.
  • Subject to tax (field VATCHA)

Select this check box to specify if a Special tax or Additional tax should be part of the VAT calculation.

Subject to tax does not apply to Local tax and is not needed if VATis selected for the Tax type.

  • VAT type (field VATPAY)

This field is used to specify the invoice stage at which the tax must be applied:

  • if the 'Issued' box is checked, the tax is due as soon as the invoice is sent (most common case),
  • if the 'Paid' box is checked, the tax is due after the invoice payment (service provisions for instance).

SEEINFO This specification is required for drawing tax declarations.

A tax rule represents the tax territoriality principle, in other words, the calculation rules to be applied to determine the tax amount.
As a general rule, by crossing a tax rule linked to the BP with a Tax level, you can determine the tax code to be applied to the document line and so, to the entry line.
In this field, you enter the tax rule associated with the BP: this tax rule will be suggested by default in all the transactions used by this business partner.

This field is used to specify the accounting code of the tax.
The accounting code is a default value used in the setting up of accounting entries.
It refers to a table listing a certain number of elements (control accounts, accounts or parts of accounts) that can be used to determine the accounting entries that will be posted.

Enter the formula number used to modify the calculation basis for this tax.This field is used when an exceptional tax must be calculated using a basis different from the ex-tax amount of the line. For example, some legislations base tax on quantities.

The result of the formula must be stored in the document line to enable the line calculation and total. Two fields, Amount 1 and Amount 2, store the calculated amount on a document line. One of those fields must be selected when a formula is defined. You can select the field in the Amount no. field.

 
  • Amount no. (field VATBAS)

Select the amount to be used to store the result of the formula: Amount 1 or Amount 2.
SEEINFO This list can only be accessed if a formula is specified.

For a formula applying to taxes, the amount number does not involve purchases. For purchases, there is as many amounts used as tax bases as there are tax codes on the purchase document line.

  • Legal mention (field TEXAXX)

Compulsory statements to be printed on the invoice footer.

This field contains the geographical subdivision corresponding to definition of the postal address. For example, a 'department' for France, and a state for the United-States.

The description of the geographic subdivision, as well as the control on the information entry, are defined in theCountries setup.

This field loads automatically after the postal code and town/city have been entered and is based on the Postal codes setup.
If the field is controlled, the control is carried out with respect to the Geographical subdivision table.

  • Application type (field APLTAX)

This field is for the KAG activity code for Argentinean legislation and defines the application sign of a local tax.

 

Table number 1

It is the code of the company for which a tax rate is defined.
Only a company with a legislation and group consistent with those defined in the header can be entered.

  • Start date (field STRDAT)

Start date for the tax rate application.


  • Rate (field VATRAT)

Use this field to specify the tax rate that can be applied to this tax.

  • Exempted sale (field VATEXEFLG)

For an EEC rule or tax suspension (Sales module), select this check box so that the tax code for accounting entries and does not trigger a VAT calculation for this rate.

  • Deductible % (field DEDRAT)

This field is used to enter a value corresponding to the percentage that can be deducted for non-recoverable taxes.

  • Threshold (field AMTTSD)

This field is used to enter a value for setting a deductibility threshold.
SEEINFO If the rate is inferior to the specified threshold, the tax will not be applied. If the rate is higher than the specified threshold, the tax will be applied.

Table number 2

This table is loaded automatically with the default dimension types associated with the basic tax data.

The setup determines if the analytical dimensions can be modified. They are initialized based on the setup of the default dimension.

In creation mode, if no order line has been entered and the project code is modified, the analytical dimensions are reset based on the setup of default dimensions.

In creation mode, as in modification mode, if an order line is entered and the project code is modified, the analytical dimensions are not reset.

Close

 

Specific Buttons

The following fields are included on the window opened through this button :

Block number 1

  • field OBJET

 

  • field CLES

 

Block number 2

  • From folder (field DOSORG)

Use this field to define the folder from which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

  • All folders (field TOUDOS)

Use this option to copy the record to all the folders defined in the dictionary (ADOSSIER table of the current solution).

  • To folder (field DOSDES)

Use this field to define the folder to which the record will be copied. The possible syntaxes are described in the Dedicated appendix.

Close

Click Copy to copy the record definition to or from another folder.

Click Legal data to view the legal data determined by the legislation for the current record.
The display window must be entered in miscellaneous table no. 959.
If no legislation is specified for the tax code, the legal data corresponds to the one entered in miscellaneous table no. 959.

The following fields are included on the window opened through this button :

Tax

This field is mandatory if a Tax code equals a Surcharge. You must enter the corresponding VAT tax code.

  • Operation to be excluded (field SPAEXEVAT)

Select this check box to exclude any record with this tax code from the VAT calculation process.

  • Import tax (field SPAIMPVAT)

Select this check box to include the VAT tax associated with an import operation. This is used when creating the Customs invoice document.

  • Purchase travel agency (field SPAPURTAG)

Select this check box to identify a purchase done through a travel agency.

  • Investments 303 (field SPAIVT303)

Select this check box to include 303 investments to be included in the 303 investments field of the VAT declaration.

  • Pro rata 303 (field SPAPRA303)

Select this check box so that these records are included in the Pro rata 303 field of the form.

  • Agrarian tax rule (field SPAAGRVAT)

Select this check box to apply the Agrarian tax rule.  

  • Used goods (field SPAUSEPDT)

Select this check box to identify the purchase or sale of used goods.

  • Special tax (field SPASPETAX)

Select this check box so that these records are used in “Impresos Oficiales X3.”

  • MOSS operation (field SPAMOSS)

 

Declarations

  • 303 box number (field BOX303)

 

  • 390 box number (field BOX390)

 

Withholdings

  • Nonresident (field SPANRS)

Select this check box to identify withholdings for services provided by a nonresident supplier.

  • Rentals (field SPARNT)

Select this check box to identify withholdings for rental operations.

  • Interests (field SPAINR)

Select this check box to identify withholdings for bank interest.

Close

Click Legal data to view the legal data determined by the legislation for the current record.

The display window must be entered in miscellaneous table no. 959.
If no legislation is specified for the tax code, the legal data corresponds to the one entered in miscellaneous table no. 959.

The following fields are included on the window opened through this button :

  • Exemption reason (field EXEMOT)

Enter or select the code for the VAT exemption.

The code defines the reason for the VAT exemption and it is required if you are claiming an exemption.
  • Exemption reason description (field EXEMOTDESC)

The VAT exemption description must be printed on the invoice report and indicated on the SAF-T document included with the invoice.

Close

Click Legal data to view the legal data determined by the legislation for the current record.

The display window must be entered in miscellaneous table no. 959.
If no legislation is specified for the tax code, the legal data corresponds to the one entered in miscellaneous table no. 959.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

To access any other GST data please use function GST periods.

To acces GST data, use the GST reporting periods function. In GST reporting periods, you can review GST data, manually enter BAS values, and generate the report necessary to prepare the data required for submitting to the Australian Tax Office (ATO).

Tables used

SEEREFERTTO Refer to documentation Implementation